Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.
I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.
Let me know your opinion and if you find this useful.
pinaldave
Hi pinaldave,
I found this cheat sheet is very useful for me.
wonderful idea… :)
regards
Vasanth
the cheat sheet is very useful.thanks
this is nis
I can’t download the cheatsheet, my browser is grinding for a long time with no file download. Please help.
Srikanth,
I did not find any problems. Please try again.
Regards,
Pinal
Sorry my bad. It worked today :) I downloaded the cheat sheet.
Thanks the cheat sheet is really useful. You have done a wonderful job.
Good print out to have near me on my desk, thanks!
Very usefull - thanks!
Hello Sir,
The information there on this blog is very useful & helpful thanks for providing such informative infromation.
Sir i have a query in ms-sql server2000
can we convert numeric(18,0) to identity(1,1) which will be primary key ,
since this ID numeric(18,0) is a foreign key in another table so i wanted that this key should be as primary auto incrementing key
whereas i am also unable to do insert into statement for the same
error ocuuring is as : Cannot insert explicit value for identity column in table
Can you please help me out.
Thanks for Sheet , Great Idea …. Really Use ful .. Thanks a Lot …