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,000 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,382 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,096 reads
Blogs
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
SQL Server health check
If I want to do a SQL Server health check, which aspects should be...
CPU?Memory and IO bottleneck check
Which indices will show cpu bottleneck?memory bottleneck and IO bottleneck? for example: which indices...
Ask SSC