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
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
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.
Thanks
Nice work
Good Work you have done
Really appriciate all of your mail now keeping always on my RSS from now !
Thanks !
Hi I wanna ask you, how can I intering data by Arabic in SQL server data base? this’s what I got ( ?????? ). thak you
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
Hi Imran ,
Good job ….. keep it up
Thank you Altaf
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
Hi Steve,
Thank you for your feedback. Nice suggestion. will post some solution over there also.
Imran
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?
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
Very nice,Thanks for Good Efforts
Thank you JK.
Hello Imran
Good work!!!!!
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,
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.
Hi Suresh,
I will look into this issue and get back to you shortly.
Thank you
Imran
Hi Imran ur doing Good job For all keep it up…
Thank you.
Thanks
Very nice blog!
I do have a small question, how do you post (part of your) blog text formatted in SQL ‘readable’ text.
You seem to have find a plugin (or created one).
Thanks in advance,
Peter
Thanks Peter. It is very simple,Just put your source code between these two tags.
“sourcecode language=”sql” gutter=”false”]
Source code here
[/sourcecode”
Add brackets in the beginning “[” and in the end “]”
Thanks for youre reply. I did need a plugin, http://wordpress.org/plugins/syntaxhighlighter/installation/ but that was not too difficult 🙂
hi..am harrison and i need tour help in getting informatin from my sql server 2008 concerning some changes done in the month of july and it has affected the analytical stock in microsoft store manager. please advice..also give me the querry to use since am not conversant with sql language
Thanks dude… for providing helpful code…
hii thanks for ur cordings.i got ur code from http://stackoverflow.com/. thank you again.keep it up.
Hi
I am using the given code to revert back the accidently updated columums in a table. But i get
(0 row(s) affected)
(0 row(s) affected)
(8 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
with no error message. It is not reverting back the data. What can be the reason Please help
Hi Imran
For me its not working. please help me to recover my deleted data. its really important for me.
Hi Sepehr,
What is the error message ?
Hi Imron,
I have a product names like this SAN Ports – 6 EMC/HDS Tier 1 864GB,SAN Ports – 8 EMC/HDS Tier 1 1152GB. I need to extract 864 and 1152 for the GB value only.How do I get the values.I have used getnumeric functions(using PATINDEX) but it returns 1684 and 811152 like this.Please help me to solve the issue.it very urgent
still i didn’t get any respose
how to pass multiple values in single parameter along with startdate and enddate…
My transaction log backup (.trn) file is 250 MB every 5 minutes. We take log backup every 5 minutes. I expect .trn file size to be 20 to 30 MB maximum based on the customer usage . I could not find the reason to explain 250 MB. VLF count is less than 20. SQL Agent jobs that run do not explain such a big file. I did export the data in .trn log backup file into Excel using fn_dump_dblog(). Too many columns and too cryptic column names. Looking for some one to help me look into Excel file (.trn file content), understand and tell em what is in that .trn file. Based on data in .trn, may be I can see which SP or Sql Agent JOb in the culprit. May be there is a better way to solve this mystery. I open to any strategy to fix this. I will be glad to pay for the time.
Thanks
Kumara
Hi Imran, is it possible to get inserted records information just like modified
Hi Naveen, yes it possible but inserted records are already there so why do need it?
Your Lag function article saved me. Thank you Sir! I will definitely bookmark your site for future reference.
Hi Sir
i need your mail id for i have doubts so we can discuss.plz
Hello. In 2016 I traveled to Dubai, and the local SQL Server user group set up a meeting so I could present. I checked in on them and the group seems to have died off. A Binoogle search returned this address as a potential place I could check to see if I could set up the same thing, or do some networking. Would you be able to assist?
Hello! I was in Dubai in 2016, and the local SQL Server User Group set up a meeting for me to present. They seem to be disbanded now. I will be in Dubai December 15-20. Could you connect me with anyone that might be able to put together a meeting so I could present again? This will allow me to share my extensive knowledge while also deducting my trip expenses as a business write-off! 🙂 Any help is appreciated!!
Best
Hi Mr. Kevin, apologies for the late response. This group is not active. We are trying to make it active again. Thanks