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

Content with tags T-SQL, SQL Server 2008 Rss

   Items 1 to 20 of 47    Older >>
 

Fun with real and float

By Dave 2013/07/01 | Category: float
Rating: (not yet rated) |  Discuss |   Briefcase | 2,288 reads

Number of Rows

By Dave 2013/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,388 reads

Change Tracking - 2008

Change tracking in SQL Server 2008 enables applications to obtain only changes that have been made to the user tables, along with the information about those changes.  Read more...
By Nitesh Dedhia 2012/06/18 | Source: SQLServerCentral.com | Category: change tracking
Rating: |  Discuss |   Briefcase | 7,372 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 20,822 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 34,919 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,341 reads

Table Value Constructors in SQL Server 2008

Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. Users who are stuck with previous versions of SQL Server can play along, since Rob Sheldon demonstrates that there have always been ways of doing this in SQL Server, though less elegantly.  Read more...
By Additional Articles 2011/07/07 | Source: SimpleTalk | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,398 reads

OUTPUT & NEWID()

By Jason Selburg 2011/04/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,991 reads

ANSI Padding

By Tom Thomson 2011/01/11 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 2,703 reads

What's the best way to count?

By Dave 2010/10/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,214 reads

The MERGE Statement in SQL Server 2008

When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy code with something quick, simple and maintainable. The MERGE syntax just takes a bit of explaining, and Rob Sheldon is, as always, on hand to explain with plenty of examples.  Read more...
By Additional Articles 2010/09/17 | Source: SimpleTalk | Category: sql server 2008
Rating:  Rate this |   Briefcase | 6,051 reads

T-SQL SQL 2008

By bitbucket-25253 2010/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,908 reads

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.   Read more...
By Tommy Bollhofer 2010/05/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 2,349 reads

Insert with OUTPUT clause

By vk-kirov 2010/05/19 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 3,056 reads

INSTEAD OF trigger and OUTPUT clause

By vk-kirov 2010/05/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,250 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 20,822 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 34,919 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 | 19,516 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 | 24,283 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,740 reads
   Items 1 to 20 of 47    Older >>
 
Tags
sql server 2005 (7)    
grouping sets (3)    
merge (3)    
spatial data (3)    
apply (2)    
data types (2)    
data warehousing (2)    
hierarchyid (2)    
performance tuning (2)    
stored procedures (2)    
triggers (2)    
administration (1)    
advanced querying (1)    
book reviews (1)    
change tracking (1)    
common language runtime (clr) (1)    
dba (1)    
filestream (1)    
float (1)    
information_schema (1)    
large udt (1)    
maintenance and management (1)    
miscellaneous (1)    
new feature of sql server 2008 (1)    
news (1)    
nitesh dedhia (1)    
operators (1)    
paging (1)    
parameters (1)    
security (1)    
sql server (1)    
star schemas (1)    
syscolumns (1)    
sysobjects (1)    
top (1)    
tvp (1)    
user defined table type (1)