Monthly 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.        

Posted in Books | Leave a comment

Conditional reIndex and update stats.

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…

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

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

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