June 26, 2013 2:00 PM
Posted by: Denny Cherry
Database Administration,
Execution Plans,
Indexing,
Nonclustered Index,
Quest Software,
SoSSE,
SQL Server,
Table ScanThe other day I was looking at parallel query plans on a customers system and I noticed that the bulk of the parallel queries on the system where coming from Spotlight for SQL Server.
The query in question is used by spotlight to figure out when the most recent full, differential and log...
May 28, 2013 4:27 PM
Posted by: Denny Cherry
AlwaysOn,
Database Administration,
Execution Plans,
Index,
Index Performance,
Index Seek,
Indexing,
SQL Server,
SQL Server 2012One of things to keep in mind with SQL Server 2012 AlwaysOn Availability Groups is that when the availability group has readable secondary replicas any rows that are changed will have an additional 14 bytes added to each row. These 14 bytes are used by the readable secondary to handle the read...
May 15, 2013 2:00 PM
Posted by: Denny Cherry
Database Administration,
Error Message,
ERRORLOG,
SQL Server,
SQL Server stored procedures,
Stored ProceduresA client that I've been working at for a while needed to start doing DBCC CHECKDBs on their production server. We hadn't been for a little while due to maintenance window constraints on their old production server. Now that we've scaled the application across 6 different servers we can now do...
May 1, 2013 2:00 PM
Posted by: Denny Cherry
Bulk Logged Recovery Model,
Database Administration,
Full Recovery Model,
Manageability,
Recovery Model,
Simple Recovery Model,
SQL Server,
Storage,
Transaction LogOne of the big myths of SQL Server resolves around the transaction log, and how it's used with the simple recovery model.
Many people think that the simple recovery model doesn't use the transaction log. More specifically they think that it's there because it has to be there, but that SQL...
March 13, 2013 2:00 PM
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,
TablesWhile 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...
December 12, 2012 2:00 PM
Posted by: Denny Cherry
Database,
Database Administration,
Microsoft Cluster Service,
Microsoft Windows,
MSCS,
SQL,
SQL Server,
SQL Server 2012,
StorageAs we all know by now AlwaysOn Availability Groups are an enterprise edition feature and SQL Server Clustering is a standard edition feature. Butt what happens when you have a small business that is running its apps on SQL Server Express. Can't SQL Express have any sort of high...
December 5, 2012 2:00 PM
Posted by: Denny Cherry
Auto Update Statistics Asynchronously,
Auto Update Stats,
Database,
Database Administration,
SQL,
SQL Server,
Statistics,
TablesA pretty cool feature that was introduced in SQL Server 2008 R2 SP1 is the ability to change the auto stats algorithm from the default of 20%+500 rows to a sliding scale. ...
November 21, 2012 9:00 AM
Posted by: Denny Cherry
Clustered Index,
Data Types,
Database,
Database Administration,
Database Design,
SQL,
SQL Server,
Stored Procedures,
T/SQL,
TablesDuring TechEd Europe I got a very scary phone call. A very large table was throwing errors that the value being inserted into the primary key column was overflowing the data type that makes up that column. In this case the data type in question was INT, so we were trying to stick the number...
November 17, 2012 2:00 PM
Posted by: Denny Cherry
Backup & recovery,
BACKUP DATABASE,
CREATE TRIGGER,
Data Loss,
Database,
Database Administration,
DDL Trigger,
Recovery,
SQL Server,
SQL Server 2008 R2,
SQL Server 2012,
T/SQL,
Transactions,
Trigger,
xp_create_subdirOne of the companies which I work with has the occasion to create new databases when they do releases of their software. Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs. As all the new databases are...
