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,153 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,401 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,099 reads
Blogs
What I’ve learned in my first 100 days with a consulting group
By DesertDBA
In case you don’t follow me on LinkedIn or Twitter, your humble host joined...
Power BI as a enterprise data warehouse solution?
By James Serra
With Power BI continuing to get many great new features, including the latest in...
Daily Coping 30 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Working with T-SQL function AVG ()
Comments posted to this topic are about the item Working with T-SQL function AVG...
The Useful Cloud Tags
Comments posted to this topic are about the item The Useful Cloud Tags
Choosing Filestream
Comments posted to this topic are about the item Choosing Filestream
Ask SSC