Testing all procs before upgrading to Compatibility Level 90
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,203 reads
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,203 reads
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,402 reads
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,100 reads
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
By Steve Jones
Today’s coping tip is to focus your attention on the good things you take...
By DataOnWheels
I had an amazing time adventuring to Wales with other members of the data...
I have a table with 489M rows and growing. The reason we had to...
Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...
Hi All, I have the column of data in SQL Server. Here I need...