A DBA asked whether backups on new EMC storage should use a 256 KB transfer size. Here is what I learned about the MaxTransferSize parameter.
SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.
SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1
Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.
SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:
SQL SERVER – Converting YYYYDDD Ordinal Date Codes Safely
This Julian date example uses an ordinal YYYYDDD code. I distinguish that business encoding from an astronomical Julian day number.
Interview Question of the Week #009 – Is GO T-SQL Statement?
Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.
SQL SERVER – ReadOnly Databases and Notes Using Snapshots
Can you get the ReadOnly error without marking the database ReadOnly? Yes, using snapshots. Here is a script that shows the behavior step by step.