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
Luiz Barros
Find and Replace a String in the Whole Database
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
Change column type on constrained columns
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
Blogs
Resources for Architecting Zero Downtime Deployments
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Daily Coping 23 Mar 2023
By Steve Jones
Today’s coping tip is to focus your attention on the good things you take...
SQL Bits 2023 Recap
By DataOnWheels
I had an amazing time adventuring to Wales with other members of the data...
Forums
Best way to ETL on large tablle with columnstore index
I have a table with 489M rows and growing. The reason we had to...
Unable To Create Transactional Replication - Microsoft SQL Error 20026
Hi All, This is Naveen Maroju. My previous DBA was created distribution database later...
Grouping the first letter in a string
Hi All, I have the column of data in SQL Server. Here I need...
Ask SSC