2018-03-19 (first published: 2018-03-15)
392 reads
Alter
Alter all/specific columns by double dynamic SQL
The script uses dynamic SQL twice
first to get the detail about the database structure and create ddl out of it
second to execute each DDL created
2015-11-03 (first published: 2015-10-07)
947 reads
Generate alter datatype script for entire database
ntext, text, and image (Transact-SQL). This script will alter the data type from image to
varbinary(max) which is very much required as the data type is out
of support.
2011-11-28 (first published: 2011-11-14)
853 reads
RE: URGENT... Help needed with xp_cmdShell
Thanks.Changing option in EM/Mgmnt/server Agent/JobSystem worked ok!
2005-03-23
RE: All databases, all tables DBCC INDEXDEFRAG script -Help Review-
Re-indexing all the tables on all the databases might be an overkill. You might want to re-index tables which are highly fragmented. I had a script for that somewhere and will try to find it and post it.
2004-08-18
RE: FillFactor for Clustered Index on an identity col
The fillfactor setting for a clustered index on IDENTITY field can be set extremely high (95% - 99%), since there it is HIGHLY unlikely that a clustering key will be updated, causing a possible page split. Probably the best bet is to leave the setting at the default of 0, which has the result that […]
2003-08-28
1 reads
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers