Logical Puzzle - 21 Dec 2004Commented on: 9 years ago
(January 3, 2005)
Both are correct. The powder is the easiest way to work it out. The halves theory is the easiest way to physically achieve the proper result. Honestly, I came up w/ the powder theory also but I'm...
All About RAISERRORCommented on: 9 years ago
(October 15, 2004)
The information is good but with most db developers, Query Anaylyzer is the tool of choice over osql. I've found that the utility of the RAISERROR command is when it's used with the WITH LOG option...
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More