SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2009


Reading another great book ( I know its old but good book)...
Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.

Read more

0 comments, 1,423 reads

Posted in Vinay Thakur on 30 August 2009

Conditional reIndex and update stats.

This script is very helpful, specially for sql server 2000. I made some changes into this.
Thanx to T.Pullen for this script.
---------------------------->SP BEGIN
CREATE PROCEDURE sp_defragment_indexes @maxfrag DECIMAL
/* T.Pullen
This stored procedure checks index fragmentation in a database and defragments
indexes whose scan densities fall below…

Read more

0 comments, 1,646 reads

Posted in Vinay Thakur on 28 August 2009

Things to consider...

I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....
Cool Stuff:
1.SSMS: now you can take output copy into excel with heading. SSMS Tips and Tricks

Read more

0 comments, 508 reads

Posted in Vinay Thakur on 20 August 2009

What's new in Sql server 2008

Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything  includes features which other competitors (data base) and more. Here I made the change of my description as there is no major changes in sql server 2005 and 2008... Sql server 2008 has almost…

Read more

2 comments, 807 reads

Posted in Vinay Thakur on 10 August 2009

What's new in Sql Server 2005

Its very difficult to write what all new  in Sql server 2005, almost everything is new... the complete engine has changed and great improvement.each point require a complete chapter but I try to make it simple....
  Sql Server 2000 Sql Server 2005
Server Good Major Redesign/changes in the architecture

Read more

0 comments, 666 reads

Posted in Vinay Thakur on 3 August 2009