Monthly Archives: August 2009

reading.

Posted on August 30, 2009 by Vinay

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

Posted in Books | Leave a comment

Conditional reIndex and update stats.

Posted on August 28, 2009 by Vinay

Hi,   This script is very helpful, specially for sql server 2000. I made some changes into this.   —————————->SP BEGIN CREATE PROCEDURE sp_defragment_indexes @maxfrag DECIMAL AS — Declare variables SET NOCOUNT ON DECLARE @tablename VARCHAR (128) DECLARE @execstr VARCHAR … Continue reading →

Posted in What I learned today | Tagged , | Leave a comment

Things to consider…

Posted on August 21, 2009 by Vinay

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 2.SSMS: Code Collapse and … Continue reading →

Posted in Computers and Internet, Experts | Tagged | Leave a comment

What’s new in Sql server 2008

Posted on August 10, 2009 by Vinay

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 … Continue reading →

Posted in Whats New | Leave a comment

What’s new in Sql Server 2005

Posted on August 3, 2009 by Vinay

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 … Continue reading →

Posted in Whats New | Leave a comment