With SQL Server 2008 coming out of support, will you upgrade?

Using SQL Server's Default Trace to Identify Autogrow Events in tempdb

by Additional Articles

Database Journal

Default Trace

We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.

Fixing ‘A required Privilege is not held by client’ Error

by Vishnu Gupthan

SQLServerCentral.com

required Privilege

This article is to explain a scenario I started facing in my work environment after some Windows Security patches rolled out .
A required privilege is not held by the client. The step failed.

The Age of Multiple Databases

by Steve Jones

SQLServerCentral.com

Editorial

There are lots of databases to choose from. Steve discusses using more of them in your work.

T-SQL Window Functions and Performance

by Additional Articles

SimpleTalk

T-SQL

T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.

Explicit Transactions

by Steve Hall

SQLServerCentral.com

Explicit Transactions

There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.