SQL Server Code,Tips and Tricks, Performance Tuning

SQL Server 2016 added the FORMATMESSAGE function.  According to Books On Line, FORMATMESSAGE constructs a message from an existing message...

How do you find out the recovery model for all the databases on your SQL Server box? On a SQL Server 2005/2008 box you can use the sys.datab...

Hi and welcome to another fascinating SQL summer teaser. Summer it is except inPrinceton where it was 50 degrees this week. There was no tea...

Mladen Prajdic has created a SQL equivalent of the C# IsNotNullOrEmpty I looked at it and thought that there was way too much code Here is ...

You can run the following function (OBJECTPROPERTY(object_id, N'TableIsFake') ) on an object and it will return 1 if the table is fa...

SQL Server 2005 SP2 has an important enhancement to the OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. Becaus...

Below are 10 SQL Server functions that are hardly used but should be used a lot more I will go in more detail later on but here is a list of...

How do you check if auto update statistics is enabled on your database? It is pretty easy to check that, you can use the DATABASEPROPERTY fu...

I emailed a joke(see below) to some friends and one of them replied: "So what you're saying is that I should take a mistress?"...

Yesterday I showed how to do ranking in SQL Server 2000 , today we will look at how it's done in SQL Server 2005 CREATE TABLE Rankings ...