The 12 Days of SQLMAS

database real-time data processing streaming data integration

On the first day of SQLMAS my server gave to me one new migration.

On the second day of SQLMAS my server gave to me two tables to join and one new migration.

On the third day of SQLMAS my server gave to me three DNS errors, two tables to join, and one new migration.

On the fourth day of SQLMAS my server gave to me four RPC calls, three DNS errors, two tables to join, and one new migration.

On the fifth day of SQLMAS my server gave to me…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the sixth day of SQLMAS my server gave to me six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the seventh day of SQLMAS my server gave to me seven failed backups, six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the eighth day of SQLMAS my server gave to me eight KB pages, seven failed backups, six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the ninth day of SQLMAS my server gave to me nine spinlocks, eight KB pages, seven failed backups, six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the tenth day of SQLMAS my server gave to me ten deadlocks, nine spinlocks, eight KB pages, seven failed backups, six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the eleventh day of SQLMAS my server gave to me eleven implicit conversions, ten deadlocks, nine spinlocks, eight KB pages, seven failed backups, six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

On the twelfth day of SQLMAS my server gave to me twelve clustered GUIDS,

eleven implicit conversions, ten deadlocks, nine spinlocks, eight KB pages, seven failed backups, six nested views…. NOLOCK IS BAD! Four RPC calls, three DNS errors, two tables to join, and one new migration.

 

Please share this

Leave a Reply

Related Articles

Full-Text Index issues

Fixing Full-Text Index Issues

We’ve had Full-Text index issues come up with surprising frequency lately, so I thought I’d share the fix with all of you lovely people who read this blog. For reference, the customer in this example asked us to look at this problem on a server that is not managed by us.

Read More »