Subscribe to this blog
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.
0 comments, 488 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…
indexes whose scan densities fall below…
0 comments, 562 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
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 Expand Feature in SQL Server Management Studio 2008
http://blogs.msdn.com/buckwoody/archive/2009/07/30/code-collapse-and-expand-feature-in-sql-server-management-studio-2008.aspx
http://blogs.msdn.com/buckwoody/archive/2009/07/30/code-collapse-and-expand-feature-in-sql-server-management-studio-2008.aspx
3.…
0 comments, 105 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…
2 comments, 170 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 |
0 comments, 187 reads
Posted in Vinay Thakur on 3 August 2009