Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2009

reading.

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, 644 reads

Posted in Vinay Thakur on 30 August 2009

Conditional reIndex and update stats.

Hi,
 
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
AS
/* T.Pullen
This stored procedure checks index fragmentation in a database and defragments
indexes whose scan densities fall below…

Read more

0 comments, 746 reads

Posted in Vinay Thakur on 28 August 2009

Things to consider...

Hi....
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
http://blogs.msdn.com/billramo/archive/2009/05/15/dat315-session-review-for-ssms-tips-tricks-session.aspx
 
3.…

Read more

0 comments, 178 reads

Posted in Vinay Thakur on 20 August 2009

What's new in Sql server 2008

Hi...
 
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, 302 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
Manageability

Read more

0 comments, 312 reads

Posted in Vinay Thakur on 3 August 2009