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...
2009-08-28
1,890 reads
Hi,This script is very helpful, specially for sql server 2000. I made some changes into this.Thanx to T.Pullen for this...
2009-08-28
1,890 reads
Hi.... I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....Cool Stuff:
1.SSMS: now...
2009-08-20
555 reads
2009-08-14
2,963 reads
Hi...Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything includes features which other competitors...
2009-08-10
888 reads
2009-08-05
3,616 reads
Its very difficult to write what all new in Sql server 2005, almost everything is new... the complete engine has...
2009-08-03
709 reads
Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...
2009-05-19
1,133 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...
Hi All, Hi All, I want to convert columns result into rows with comma....
Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG...