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,010 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,385 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
Origem Flash Headphone Sale
By Steve Jones
I reviewed a set of wireless headphones this summer, and I continue to use...
Troubleshooting NUMA Node Inbalance Problems
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Graph – Shortest Path
‘Shortest path’ is by far the most feature of SQL Graph for now. What...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Duplicate data
Hi Experts . I have table Temp_decimal_mismatch which has duplicate data . The duplicate...
https://faqssupplement.com/provexum-uk/
However the problem is the quality of the last thing these remedies! There have...
Ask SSC