Why use of VARCHAR(MAX) should be avoided
Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N): Performance comparison of varchar(max) vs. varchar(N) Views – 2066
Read More
Expiring Database Backups
The “Backup set will Expire” option is used to indicate how long a backup should be prevented from being over written by another…
Read More
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read More
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read More
PASS 2015 – Seattle WA – Pre-Con Day 1 – Pinal Dave
PASS 2015 10-26-30 Seattle WA Pre-Con Day 1 – 42 Tips to Performance Tuning, Optimization and Everything Pinal Dave TODO: Write missing index…
Read More
Display all SQL Server’s Undocumented DBCC Commands
To display SQL Server’s undocumented commands, you can run the following T-SQL:
|
1 2 3 4 |
DBCC TRACEON(2588); GO DBCC HELP ('?'); |
(use at your own risk, and not on a production…
Read More
Removing Log-shipping from a Secondary in a 2-way Log-shipping Scenario
I recently had a scenario where I wanted to drop a database (it was replaced by a new system) on a primary SQL…
Read More
Resolving Failover Log-shipping errors
Here is an error I recent received when failing-over our databases at work from our Primary SQL Server to our Secondary during a…
Read More
Unlocking an AD account with PowerShell
PowerShell has a module that will allow you to unlock an AD user. The AD PowerShell module has number of commands for managing…
Read More
SQL Server DBA Job Openings: A great review of a poorly written posting
…saw this today and found it VERY informative: A BETTER DBA JOB DESCRIPTION FOR EVERYONE Views – 2386
Read More