About

Welcome to raresql.com

It’s a platform designed with the purpose to provide unique and optimized solution for the real world SQL scenarios. Be it a simple select statement or a complex scenario, we share our knowledge & experience to achieve the end result.
The raresql team is just passionate about challenges.

Please comment your valuable feedback.

Regards,
raresql team
+Muhammad Imran

23 Comments »

23 Responses

on December 21, 2011 at 1:43 pm | Reply Jk pal

thanks for giving this code of deleted record.
But unfortunetly my database is drop then how to recover.
there is any log of drop db or elsewhere.

Plz Suggest.

Thanks
Jk Pal
- on December 22, 2011 at 1:40 pm | Reply Muhammad Imran
  
  Hi JK,
  It seems that your database has been deleted from your server.So ,you need to use some third party softwares to recover your mdf & ldf files from your windows.
  
  Thank you.
on December 22, 2011 at 7:20 pm | Reply Jk pal

Thanks
on March 27, 2012 at 11:33 am | Reply Abdul Rehman Khan

Nice work
on March 27, 2012 at 11:34 am | Reply Abdul Rehman Khan

Good Work you have done
on May 5, 2012 at 7:39 pm | Reply Vishal Pawar

Really appriciate all of your mail now keeping always on my RSS from now !
Thanks !
on August 29, 2012 at 10:06 pm | Reply Dhuha

Hi I wanna ask you, how can I intering data by Arabic in SQL server data base? this’s what I got ( ?????? ). thak you
- on August 31, 2012 at 3:27 pm | Reply Muhammad Imran
  
  Hi Dhuha,
  This is how you can insert arabic data into sql server database.
  
  Create table test([Arabic Name] nvarchar(50))
  insert into test values (N’عمران’)
  Select * from test
  
  Thank you.
  Imran
on November 14, 2012 at 8:31 am | Reply ALTAF

Hi Imran ,
Good job ….. keep it up
- on November 14, 2012 at 8:36 am | Reply Muhammad Imran
  
  Thank you Altaf
on November 22, 2012 at 7:01 pm | Reply Steve Bergkamp

Muhammad :
Your on my guru list. Very nice and insightful. Have you ever thought of putting any of your solutions out on sqlservercentral.com ?

Thanks!!!
Steve Bergkamp
- on November 25, 2012 at 8:38 am | Reply Muhammad Imran
  
  Hi Steve,
  
  Thank you for your feedback. Nice suggestion. will post some solution over there also.
  
  Imran
on December 5, 2012 at 2:40 pm | Reply Imran Rauf Qureshi

Hi Imran
Good efforts

Actully i want to ask about connection pooling in SQL Server 2005 with ADO.Net. What is the best way to handle thousand of connections?
- on December 5, 2012 at 11:31 pm | Reply Muhammad Imran
  
  Hi Imran,
  Thank you. Basically, pooling creates problem when a lot connections remain unclosed. It is recommended that once your task is done, immediately you need to close the connections.
  I found a very useful article including Microsoft recommendations about pooling, hope it will help you. http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx
  Let me know, if you need sample code as well.
  
  Many Thanks
  
  Imran
on December 5, 2012 at 5:40 pm | Reply JK

Very nice,Thanks for Good Efforts
- on December 5, 2012 at 11:32 pm | Reply Muhammad Imran
  
  Thank you JK.
on January 15, 2013 at 6:21 am | Reply NA

Hello Imran

Good work!!!!!
on January 30, 2013 at 7:11 pm | Reply kathy

Hi Imran,

I think you are the only one who can explain this. A SQL 2000 database was restored in SQL 2008R2 SP2

the problem is something is happeing to Rsys_Last_Id with trailing 00

We have isolated the problem to the Proc ‘rsp_getnewid’.

–First update the RSys_Last_Id to a value with trailing 00′s
Update RSys_Last_Id set Last_Id_Value = 0x00000000003F8F00 where Table_Name = ‘Arch_Activity’
–Now update using the body of the rsp_getnewid proc
Declare @tableName varchar(30), @lastIdValue binary(8)

UPDATE RSys_Last_Id SET Last_Id_Value = CONVERT(binary(4), LEFT(Last_Id_Value, 4)) +
CONVERT(binary(4), (CONVERT(binary(4), RIGHT(Last_Id_Value, 4)) + 1))
WHERE Table_Name = ‘Arch_Activity’
SELECT @lastIdValue = Last_Id_Value FROM RSys_Last_Id WHERE Table_Name = ‘Arch_Activity’

– now read the new value
Select * from RSys_Last_Id where Table_Name = ‘Arch_Activity’
– the result is 0x0000000000003F90

Thank you so much,
on May 18, 2013 at 8:54 am | Reply jitsureshkumar

Hi Imran,
I am regular reader to your website.
I have learned lot of things regarding SQL From your site.
I have one doubt regarding Performance related in SQL.
I have one table as FinalBill(It having 3 lacks records).When select with single column from that table with specified condition. it return around 1lacks records.but it getting more 8 secs records .so that i had checked index for this tables and index fragmentation for this table.It is ok. But Logical read getting more 2 Lacks .Please give advise for this one.
Normally It will take 8 secs or we have some issue in our table or db or server setting .
Please give clarification regarding this one.
- on May 18, 2013 at 11:15 pm | Reply Muhammad Imran
  
  Hi Suresh,
  I will look into this issue and get back to you shortly.
  
  Thank you
  Imran
on May 28, 2013 at 1:48 pm | Reply nizamudeen

Hi Imran ur doing Good job For all keep it up…
- on May 29, 2013 at 12:11 am | Reply Muhammad Imran
  
  Thank you.
on June 7, 2013 at 9:46 am | Reply Manish

Thanks