SQL Server with Mr. Denny:

System Objects


October 16, 2013  2:00 PM

Replication and VLFs

Posted by: Denny Cherry
Database, Replication, SQL Server, SQL Server 2008 R2, Storage, System Objects, Transaction Log

Every once in a while you run across a problem that shouldn't be causing people as much problems as it is, yet there it is causing all sorts of problems for long...

March 13, 2013  2:00 PM

Deleting LOB Data and Shrinking the Database

Posted by: Denny Cherry
Andre Kamman, Database, Database Administration, DBCC PAGE, Mladen Prajdić, Paul Randal, SQL Saturday, SQL Saturday 194, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, System Objects, Tables

While attending SQL Saturday 194 in Exeter over in England one of the attendees came to Mladen...

July 12, 2012  2:00 PM

PBM, Replication and Stored Procedure Names

Posted by: Denny Cherry
Replication, SQL Server, SQL Server 2008 R2, SQL Server 2012, System Objects

One of the things that Policy Based management is really good at is making sure that people don't create stored procedures that start with "sp_".  However when the server that you are deploying the policies to is also being used for SQL Server replication this can get a little more complex seeing...

February 3, 2009  2:47 AM

Rights to System Stored Procedures

Posted by: Denny Cherry
Permissions, System Objects

Why on earth to people want to go changing the rights on the system objects. Continued »


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: