SQLServerCentral.com Content tagged T-SQL, Blogs

Comparing an inner join vs a subquery

Wed, 08 May 2013 06:00:00 UT

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...

SQL Server – Generate Calendar using TSQL

Tue, 16 Apr 2013 06:00:00 UT

Introduction Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....

UNPIVOT a table using CROSS APPLY

Fri, 12 Apr 2013 06:00:00 UT

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...

Sub query pass through

Tue, 26 Mar 2013 06:00:00 UT

Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided...

DROP and CREATE vs ALTER

Tue, 05 Mar 2013 07:00:00 UT

When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Duplicate rows in a table

Mon, 11 Feb 2013 07:00:00 UT

I recently got the following email: “I just keyed in two rows into a table with all identical column values. How...

Let’s Talk About Joins

Mon, 17 Dec 2012 07:00:00 UT

T-SQL Tuesday #37 This month please join us in the TSQL blog party that happens on the second tuesday of the...

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

T-SQL: CASE Statement

Tue, 11 Dec 2012 07:00:00 UT

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...

Tip: OVER and PARTITION BY

Wed, 28 Nov 2012 07:00:00 UT

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...

Don’t believe everything you read: Truncate table is not logged

Fri, 02 Nov 2012 06:00:00 UT

Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...

SQL Server # TSQL to Convert STRING in PROPER format

Thu, 18 Oct 2012 06:00:00 UT

Problem Statement SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...

Multiple CTEs

Thu, 11 Oct 2012 06:00:00 UT

Multiple CTEs It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...

SQL Server : Usage of OVER Clause

Mon, 17 Sep 2012 06:00:00 UT

Over clause can be used in association with aggregate function and ranking function. The over clause determine the partitioning and...

The MERGE statement in SQL Server

Thu, 06 Sep 2012 06:00:00 UT

The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based...

SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL

Wed, 25 Jul 2012 06:00:00 UT

In the last blog posting about AlwaysOn you have seen how you can deploy your first Availability Group through the AlwaysOn...

Which SELECT * Is Better?

Fri, 11 May 2012 06:00:00 UT

The short answer is, of course, none of them, but testing is the only way to be sure. I was asked,...

Identity Crisis

Wed, 02 May 2012 06:00:00 UT

I’m sure most people have identity values lurking somewhere in their databases. In fact I would guess that most people...

Checking Your Service Account with T-SQL

Thu, 01 Mar 2012 07:00:00 UT

Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect...

How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial

MERGE with OUTPUT clause

Wed, 29 Feb 2012 07:00:00 UT

A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...

Removing Identical Duplicate Rows

Tue, 28 Feb 2012 07:00:00 UT

Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...

Renumbering Rows in a Table Variable (or Table/Temp Table)

Thu, 24 Feb 2011 07:00:00 UT

I was recently working on a data cleanup problem where I had to do lots of comparisons of one row...

Distincting an IN subquery

Wed, 26 Jan 2011 07:00:00 UT

This is going to be a quick one… I keep seeing forum code (and production code) that includes the DISTINCT in...

Getting Fast Counts of Large Service Broker Queues

Fri, 21 Jan 2011 07:00:00 UT

Getting Fast Counts of Large Service Broker Queues This question regarding getting a fast count from a service broker queue came...

Check that what you expected is actually what you got - DB's and SQLCMD

Thu, 20 Jan 2011 07:00:00 UT

I feel that it is wise move for a script to actually check itself that the database connection that is...

Do IF statements cause recompiles?

Wed, 15 Dec 2010 07:00:00 UT

I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...

Finding Date Ranges for Calculating Statistics

Wed, 17 Mar 2010 06:00:00 UT

Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA: I need your input to derive the...

Breaking Down TempDB Contention

Wed, 10 Mar 2010 07:00:00 UT

Breaking Down TempDB Contention What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...

Sometimes, you have to fix it yourself

Wed, 24 Feb 2010 07:00:00 UT

The Problem SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Quick Tip Of The Day

Fri, 19 Feb 2010 07:00:00 UT

Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...

IN and NOT IN

Thu, 04 Feb 2010 07:00:00 UT

One of the most common mistakes made in T-SQL is thinking that these behave identically. I've personally opened up a...