Tag Archives: Performance

What A Difference An Index Makes

M’colleagues over the way were having problems with an upgrade / feature installation of McAfee EPO UDLP (no, I have no idea what that means). Looking at what was happening on the SQL Server that’s at the back of that … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | Leave a comment

Notes on Instant File Initialization and Running Scripts on Multiple Servers

Instant File Initialization (IFI) IFI can be a useful performance booster if you’re in an environment where your database files grow regularly, although there’s an argument that if that happens regularly, you should grow them massively up front in a … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

45 Database Performance Tips for Developers

Just a quick post to point out that Red Gate has just put out an e-book of 45 Database Performance Tips for Developers. It’s free. And to sweeten the deal, they’re bundling it with a 14 day free trial licence … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , | 1 Comment

Book Review – “SQL Server Transaction Log Management” by Tony Davis and Gail Shaw

A couple of questions and comments on the Ask.SQLServerCentral.com website have shown some misunderstanding about the use of SQL Server’s Transaction Log files. At about the same time, I was approached by Red Gate as part of their Friends programme … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , , , , , , , | 1 Comment

T-SQL Tuesday #037 – SARGability – Not Just For WHERE Clauses

T-SQL Tuesday is a monthly SQL Server blogging event. One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic. This month’s event is … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , | 2 Comments

#T-SQL Tuesday #35 – Soylent Green

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , | 1 Comment

Waitresource Key

I was watching a server this morning, making sure that there was nothing untoward going on, and I caught sight of a LCK_M_S waittype with a very long number in the Resource column: KEY: 26:72057594819903488 (6b0068a71fb9). I watched a bit … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment