SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag T-SQL Rss

Search for any content tagged t-sql

   Items 1 to 20 of 752    Next 20 >>
 

Intersect, Except, Union, All and Any

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.  Read more...
By David Poole 2010/05/21 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 16,265 reads

Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.  Read more...
By Oleg Netchaev 2010/05/14 (first published: 2009/07/01) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 16,065 reads

SQL Server 2005 Paging – The Holy Grail

Handling the paging of results in T-SQL has been a challenge for a long time. Robert Cary presents an interesting technique in this article.  Read more...
By Robert Cary 2010/05/07 (first published: 2009/03/11) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 16,429 reads

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

In Part 1, we learned how to make both Cross-Tabs and Pivots. In Part 2, we'll learn how to automate a very common type of Cross-Tab report and maybe learn some extra tricks on the way.  Read more...
By Jeff Moden 2010/04/30 (first published: 2008/12/03) | Source: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |  Briefcase | 17,654 reads

SQL Server 2008 T-SQL Enhancements Part - IV

In the fourth installment that looks at T-SQL changes for SQL Server 2008, Ashad Ali examines how the Filestream data type works.  Read more...
By Arshad Ali 2010/03/26 (first published: 2009/08/28) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |  Briefcase | 9,382 reads

SQL Server 2008 T-SQL Enhancements Part - III

Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.  Read more...
By Arshad Ali 2010/03/19 (first published: 2009/08/27) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |  Briefcase | 12,253 reads

An Urgent Ad Hoc Report

In this new article, Yakov Shlafman shows us how he wrote a quick ad hoc report of expenses so that he could leave on time one day.  Read more...
By Yakov Shlafman 2010/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 6,337 reads

Finding Date Ranges for Calculating Statistics

Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA: I need your input to derive the...  Read more...
By Robert Davis 2010/03/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 923 reads

T-SQL: Why “It Depends”

Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.   Read more...
By Bob Hovious 2010/03/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 8,241 reads

Beginning T-SQL 2008 - Book Review

A book review of a new T-SQL book for SQL Server 2008, written by longtime SQLServerCentral author and MVP, Kathi Kellenburger.  Read more...
By Beverley Beverley 2010/03/15 | Source: SQLServerCentral.com | Category: book reviews
Rating: |  Discuss |  Briefcase | 1,299 reads

Breaking Down TempDB Contention

Breaking Down TempDB Contention  What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...  Read more...
By Robert Davis 2010/03/10 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 1,266 reads

Procedural, Semi-Procedural and Declarative Programming in SQL

A lot of the time, the key to making SQL databases perform well is to take a break from the keyboard and rethink the way of approaching the problem; and rethinking in terms of a set-based declarative approach. Joe takes a simple discussion abut a problem with a UDF to illustrate the point that ingrained procedural reflexes can often prevent us from seeing simpler set-based techniques.  Read more...
By Additional Articles 2010/03/09 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |  Briefcase | 2,694 reads

SQL Server 2008 T-SQL Enhancements Part - I

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.  Read more...
By Arshad Ali 2010/03/05 (first published: 2009/01/22) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |  Briefcase | 31,933 reads

Calculating Moving Averages with T-SQL

How to efficiently calculate moving averages with SQL Server using Stock Market data.  Read more...
By Gabriel Priester 2010/03/04 | Source: SQLServerCentral.com | Category: moving average
Rating: |  Discuss |  Briefcase | 9,098 reads

Efficiently Reuse Gaps in an Identity Column

This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.  Read more...
By Additional Articles 2010/03/03 | Source: SQLTeam.com | Category: identity
Rating: (not yet rated)  Rate this |  Briefcase | 2,147 reads

Randomizing Result Sets with NEWID

Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.  Read more...
By Seth Delconte 2010/03/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 5,983 reads

Sometimes, you have to fix it yourself

The Problem SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...  Read more...
By Wesley Brown 2010/02/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 910 reads

Tips for Simplifying Crosstab Query Statements

Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.  Read more...
By Additional Articles 2010/02/22 | Source: Database Journal | Category: t-sql
Rating:  Rate this |  Briefcase | 3,458 reads

Quick Tip Of The Day

Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...  Read more...
By Wesley Brown 2010/02/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |  Briefcase | 973 reads

Import Excel Spreadsheet to Database Tables

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.  Read more...
By Peter He 2010/02/17 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |  Briefcase | 14,172 reads
   Items 1 to 20 of 752    Next 20 >>