Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

It’s Not Too Late

You know you want to go on the SQL Cruise. You can. You just have to convince the boss that it’s worth doing. It is. I’ve said it before and I’ll repeat it as necessary, SQL Cruise changes peoples lives. I’ve watched people go on the cruise with a… Read more

0 comments, 27 reads

Posted in The Scary DBA on 1 December 2015

Why would you want to name a transaction?

Something that i keep seeing in documentation, in forum code and in real systems is transactions that have names

BEGIN TRANSACTION VeryImportantProcess

<do stuff>

COMMIT VeryImportantProcess

Now the question came up on the forums a while back as to what the point of this is. Why would you name a… Read more

0 comments, 21 reads

Posted in SQL In The Wild on 1 December 2015

Querying the Plan Cache

I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of that information is already there waiting for you to query it. Luckily, Jonathan Kehayias (b|t) did the hard work for us in his post Finding what… Read more

4 comments, 24 reads

Posted in Simple SQL Server on 1 December 2015

Summon Blue Screens of Death (for testing purposes only, of course)

Today I had a need to manually trigger and sustain a Blue Screen of Death (BSOD) inside a Windows Server VM. The goal was to be able to trigger a BSOD so that I could work on the detection of powered on but failed VMs inside a server environment. All… Read more

1 comments, 52 reads

Posted in Technobabble by Klee from @kleegeek on 30 November 2015

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens when your developer, DBA or whoever is hit by a bus?

The situation

User: Oh noes! The web sites down!

One quick call later

Developer: Hmm, it looks… Read more

4 comments, 70 reads

Posted in SQLStudies on 30 November 2015

Row-Level Security part 2 – Controlling Write Access

My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible to restrict write operations as well. This feature is currently available as a preview now generally available in Azure SQL Database V12. Let’s see how that works.

Filtering and…

Read more

0 comments, 96 reads

Posted in Gorandalf's SQL Blog on 29 November 2015

Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)

Continuation from the previous 72 parts, the whole series can be found at Since the very first version of SQL Server the maximum size for the Delta-Stores as well as the compressed Row Groups was limited to 1048567 Rows.…

Read more

0 comments, 101 reads

Posted in Niko's blog on 28 November 2015

Python Command Line Calls

There was a time I worked in a company any we lived in the command line. This was in the early 90s, prior to Windows v3.1 being released and we primarily used DOS on a Novell network.

We also had paper phone books on every desk for the 1,000+ people… Read more

2 comments, 138 reads

Posted in The Voice of the DBA on 27 November 2015

Find duplicate indexes in SSDT

Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them so SQL Developers do your DBA's a favour and stop them from ever being deployed :)

This new tool for the SSDT Dev Pack adds a menu…

Read more

0 comments, 115 reads

Posted in Ed Elliott's Sql Developer Blog on 27 November 2015

SQL Server – DROP IF EXISTS in SQL Server 2016

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets …

Continue reading Read more

0 comments, 154 reads

Posted in Kapil Blogs on 27 November 2015

Value can not be null Parameter Name:store TFS WorkItem Store Error

Error HRESULT E_FAIL has been returned from a call to a COM component.

System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.
   at Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.DataStoreNative.UpdateMetadata(IntPtr handle, Object rowset, String dbstamp, UInt32& changes)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.Datastore.UpdateMetadata(Object rowset, String dbstamp)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore.EndBackendCall(BackendCallData data)

Read more

0 comments, 73 reads

Posted in Querying Microsoft SQL Server on 26 November 2015

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media channels suggesting that the end was nigh… Read more

0 comments, 49 reads

Posted in SQL Server Rocks! on 26 November 2015

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a covering index. Before we look at those options, let’s talk about the need for a covering index.

The term covering index was created probably a decade ago. The idea is… Read more

0 comments, 102 reads

Posted in The Smiling DBA on 26 November 2015

Using Stored Procedures in SQL Server For Better Performance

Intoduction to Stored Procedures in SQL Server

SQL Server uses Different types of stored procedures. They are the quickest method of accessing and manipulating database on the server. SPs are codes and scripts that are predefined for repetitive tasks to be performed on the server involving a database/its table/pages,… Read more

0 comments, 161 reads

Posted in Zora's SQL Tips on 26 November 2015

Steps to create SQL database at Azure

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into …

Continue reading Read more

0 comments, 123 reads

Posted in Kapil Blogs on 26 November 2015

Complete DAX Function Reference

The DAX function documentation in MSDN can be found on separate pages,  organized by function categories and then details for every function.  This is useful but you can’t view all of the functions in one searchable page.  If you don’t know exactly what you’re looking for, it can be a…

Read more

3 comments, 92 reads

Posted in SQL Server BI Blog on 26 November 2015

Know More About SQL Server Error number 6401


The ACID acronym standing for Atomicity, Consistency, Isolation and Durability is the foundation of SQL transactions. Transactions are used when the database has to be modified by using one or more SQL statements and to make sure the security of the database as well. However, at times, this normal… Read more

0 comments, 128 reads

Posted in Zora's SQL Tips on 25 November 2015

Convert select statements in scripts into Inline-TVF's automatically

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really really simple using the TSql ScriptDom so here is another tool…

Read more

0 comments, 84 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script.

Honestly if you are doing anything with the…

Read more

0 comments, 90 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

Issues and opinions on the PASS anti-harassment policy (#sqlpass)

PASS just published an anti-harassment policy reminder, quickly followed by a  blog by Wendy Pastrick (about a bad experience at last month’s conference, and why it took a while to report it). We’ve had some conversation on Twitter about it all, and a couple of jokes, and some back and…

Read more

2 comments, 130 reads

Posted in SQL Awesomesauce on 25 November 2015

Older posts