Viewing 5 posts - 1 through 5 (of 5 total)
I have also got the answer wrong, though ran the script in SSMS 🙁
You can include the simple check of the characters number: select len(@string4)
August 3, 2012 at 6:06 am
#1521331
Got nothing when pointing on the url. I wonder why...
March 24, 2010 at 1:50 am
#1138724
I guess this can be implemented through default parameters. Please, share
experience, if you had to deal with this kind of subscripitons.
Elena
January 12, 2007 at 7:34 am
#682901
Try script from BOL, which can be also found on msdn http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_46cn.asp
E. Use DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database
January 4, 2006 at 3:29 am
#612543
DBCC SHOWCONTIG scans index for the table. Extent Scan Fragmentation value will be high if the index spans multiple files.
October 25, 2005 at 3:04 am
#599736