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

<< Newer    Items 21 to 40 of 47    Older >>
 

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,868 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 | 39,534 reads

SQL Server 2008

By Amol Naik 2010/01/11 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 3,472 reads

Find weak login passwords in your server

Use this script to search for SQL Server logins who use weak password  Read more...
By Th Tr 2010/01/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,522 reads

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...
By Thomas Cournane 2009/12/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,653 reads

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,834 reads

SQL Server 2008 T-SQL Enhancements Part - V

The fifth installment of Arshad Ali's series examines the spatial data types in SQL Server 2008. These new types allow the use of geospatial data in SQL Server applications.  Read more...
By Arshad Ali 2009/08/31 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 10,049 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,533 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,299 reads

SQL 2008 T-SQL

By bitbucket-25253 2009/08/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,162 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,365 reads

Dynamic SQL Merge

This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.  Read more...
By Glen Schwickerath 2009/04/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,111 reads

Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008

A tip from MSSQLTips that shows a few ways for implementing paging on large tables.  Read more...
By Additional Articles 2009/03/12 | Source: SQLServerCentral.com | Category: paging
Rating: (not yet rated)  Rate this |   Briefcase | 5,118 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 | 39,534 reads

Grouping with SQL Server 2008

Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.  Read more...
By Additional Articles 2009/01/13 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 3,100 reads

Table Variables

By Sudhir Chawla 2008/11/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,067 reads

Investigating the new Spatial Types in SQL Server 2008 - Part 2

This is the second article in the series on the new spatial data types in SQL Server 2008  Read more...
By Bennie Haelen 2008/11/20 | Source: SQLServerCentral.com | Category: spatial data
Rating: |  Discuss |   Briefcase | 5,402 reads

Grouping Sets in SQL Server 2008

This article shows how to use the GROUPING SETS feature in SQL Server 2008  Read more...
By Additional Articles 2008/11/19 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,989 reads

Introduction to New T-SQL Programmability Features in SQL Server 2008

This paper introduces key new Transact-SQL programmability features in Microsoft SQL Server 2008 as well as SQL/Common Language Runtime (CLR) enhancements.  Read more...
By Additional Articles 2008/10/24 | Source: TechNet Blogs | Category: t-sql
Rating:  Rate this |   Briefcase | 5,662 reads

GROUP BY ALL

By Hugo Kornelis 2008/08/04 | Category: sql server 2008
Rating: (not yet rated) |  Discuss |   Briefcase | 4,402 reads
<< Newer    Items 21 to 40 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)