SQL Server Diaries

Linked Servers are easy to set up in all versions of SQL Server.  Using a Linked Server one can connect to databases on the same SQL Server instance, on other instances, other DBMSs such as Oracle, MySQL, Informix and using the appropriae driver (e.g. OLEDB, ODBC, etc.), even Microsoft Access or... [Read More]

This is somewhat of a reminder for SQL Server installations. In a Technet article titled Storage Top 10 Best Practices (published in 2006), Microsoft recomend that, in the case of the TEMPBD database, the number of files is equivalent to the number of CPU’s. The below script is an example... [Read More]

I was recently asked why, when an application was saving datetime values sometimes the actual value stored is different than the one sent to the database.  After investigating the issue I discovered that the programmers were relying on the local/client machine’s Regional Settings to display dates to the end user... [Read More]

I sometimes use the MSSQL Blocks application to monitor and especially collect information related to database locks.  I know that I could use an SQL Profiler trace or a Server-level trace however I found that this application is offers a “start and forget” approach. [Read More]

When accessing database objects, such as stored procedures, over a Linked Server the stored procedure output will be returned to the calling application.  There are occasions where we have to insert the results of the stored procedure into a temporary table to be used further on in our stored procedure.... [Read More]