(Kendal Van Dyke) We all know that we should document our SQL Servers, right? RIGHT?

(Kenneth Fisher) This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers I know use the function LEN to calculate the length of a string.

(Marcin Policht) In the series of introductory articles published recently on this forum, we have presented functionality incorporated into PowerShell that can be employed to create a SQL Server 2012 Integration Services catalog with an arbitrarily chosen folder structure, and deploy to it SSIS proj

(Erin Stellato) Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don’t accurately reflect the current contents of the table you’ll get a poorly-performing query. How do you find out if statistics are correct, and

(Ted Krueger) When working on SQL Server that is stretching IO and the subsystem to its limits, you are bound to see a buffer latch time-out error at some point.

(Pinal Dave) Just a day before I was working on some query and faced this error. As soon as I receive this, I realized that what I had done wrong and what I needed to fix. The suggestion demonstrated in the error message is to the point and accurate.

(Svetlana Golovko) The first article (“Part 1”) listed some of the checks for the database security audit. In this tip we look at many different security settings and configuration settings that you should be aware of. There are several scripts that you can run to know if there are any potential se

(Frank Solomon) Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article will describe recursion and its SQL Server implementations, complete with examples. It will also include SQL Server functions and a stored procedure that unpacks, or parse

(Arshad Ali) There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.

(Kalen Delaney) I just started using a new DMV (one that’s actually an ‘F’ not a ‘V’, as in Function) that gives us more info about distribution statistics. It returns info about the last statistics update date (which is also available with a function STATS_DATE()). It also provides the number of ro