<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
t-sql
,
sql server 2008
<< Previous 20
Items 21 to 40 of 45
Next 20 >>
SQL Server 2008
Read more...
By
Amol Naik
2010/01/11
|
Category:
sql server 2008
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,438 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,383 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,533 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,686 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,978 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,377 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,131 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,148 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,530 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,893 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,317 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,004 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,294 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,929 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,601 reads
GROUP BY ALL
Read more...
By
Hugo Kornelis
2008/08/04
|
Category:
sql server 2008
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,378 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,906 reads
Row Value Constructor in SQL Server 2008
This article illustrates different methods to insert data into a table, including the new Row Value Constructor, which simplifies the data insertion.
Read more...
By
Additional Articles
2008/05/16
|
Source:
Database Journal
|
Category:
sql server 2008
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,990 reads
<< Previous 20
Items 21 to 40 of 45
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)
common language runtime (clr)
(1)
dba
(1)
filestream
(1)
information_schema
(1)
large udt
(1)
maintenance and management
(1)
miscellaneous
(1)
news
(1)
operators
(1)
paging
(1)
parameters
(1)
security
(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.
