Welcome to MSDN Blogs Sign in | Join | Help

Random Hacks!

Awaiting my Bohemian Rhapsody

News

Browse by Tags

All Tags » T-SQL   (RSS)
"Ad hoc updates to system catalogs are not enabled" in SQL Server
I got this error while trying to add records to sysmessages table in master db. Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this. The fix is, login with Admin privileges and performt Read More...
Count(1) vs Count(*)
There has been a long-standing doubt about the performance of the count statement. I was told by experienced developers in PL/SQL that using count(1) to find the rowcount was much more high-performing than using count(*), as count(*) fetches all the rows Read More...
Page view tracker