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)

Got nothing when pointing on the url. I wonder why...

 I guess this can be implemented through default parameters. Please, share

experience, if you had to deal with this kind of subscripitons.

Elena

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

DBCC SHOWCONTIG scans index for the table. Extent Scan Fragmentation value will be high if the index spans multiple files.