October 18, 2007 6:18 PM
Posted by: Denny Cherry
Microsoft Windows,
SQLBob Ward of Microsoft has written an excellent blog about the lock pages is memory right over on the PSS blog.
October 17, 2007 5:46 PM
Posted by: Denny Cherry
SQL,
Windows ComputingI know that there is some confusion about what exactly the minimum server memory setting in sp_configure actually does. When I was at PASS I was able to ask the Microsoft guys this very question and here is what they told me.
The setting does not control how much memory SQL takes when it...
October 15, 2007 6:54 PM
Posted by: Denny Cherry
Service Broker,
SQLI've submitted a request to Microsoft (via the Connect site) to have them improve the error reporting which the Service Broker does to the error log. If everyone could vote for that submission (
October 11, 2007 2:15 AM
Posted by: Denny Cherry
Comic,
SQLWhile waiting for an index to be created I ran across this little beauty over at http://xkcd.com. I just had to share it.
October 10, 2007 1:58 AM
Posted by: Denny Cherry
DataManagement,
SQL,
StorageMany DBAs so not have the knowledge needed in the storage area to be able to ask the right questions to there storage engineers, and often storage engineers do not know the right questions to ask a DBA to get the answers that they need. Because of this database storage ends up being configured...
