SQL Server with Mr. Denny:

System Objects

1

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 Prajdić, Andre Kamman and myself with an interesting problem.  She had a database table which was about 200 Gigs in size which she wanted to...

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 »


1