<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tags
sql server 2008
,
t-sql
<< Previous 20
Items 21 to 40 of 46
Next 20 >>
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,346 reads
SQL Server 2008
Read more...
By
Amol Naik
2010/01/11
|
Category:
sql server 2008
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,442 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,391 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,540 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,693 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
|
9,987 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,384 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,154 reads
SQL 2008 T-SQL
Read more...
By
bitbucket
2009/08/25
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,125 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,169 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
|
7,557 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
|
4,914 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,346 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,011 reads
Table Variables
Read more...
By
Sudhir Chawla
2008/11/27
|
Category:
t-sql
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,045 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,304 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,933 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
|
Category:
t-sql
Rating:
Rate this
|
Briefcase
|
5,605 reads
GROUP BY ALL
Read more...
By
Hugo Kornelis
2008/08/04
|
Category:
sql server 2008
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,379 reads
Enhancement in variable declaration – SQL Server 2008
Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time. This article shows you how to do it.
Read more...
By
Additional Articles
2008/07/09
|
Source:
Database Journal
|
Category:
sql server 2008
Rating:
Rate this
|
Briefcase
|
2,908 reads
<< Previous 20
Items 21 to 40 of 46
Next 20 >>
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)
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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
