Readers

Articles
How to Recycle a Virtual SQL Server 2005 Machine 1
This reader’s remote client needed a new virtual SQL Server 2005 machine within 24 hours to test a project release update. Learn how he added this server from 200 miles away.
Reset Identity Values
Use a stored T-SQL procedure called ResetIdentities.sql to globally reset all identity values in a database to their initial seed value.
A Clever Way to Connect to a Hidden Named Instance 2
If you're having trouble connecting to a hidden SQL Server named instance, try adapting the connection string. Here's how.
Queries Dragging? Try Defragging 6
If your queries against a table or database are running slow, the indexes in that table might be fragmented. The cspDefragIndexes stored procedure can quickly and easily take care of the problem.
BINARY_CHECKSUM Query Better for Big Table Samplings
Selecting a random sampling of rows from a large table in SQL Server 2000 used to take a long time and use a lot of disk I/O. The BINARY_CHECKSUM query changes all that.
UDF Eliminates Concatenation Woes 1
If you often need to provide multiple values in a variable but find the 8,000-character limit too restrictive, give dbo.fn_AddToBuffer a try.
SELECT vs. SET: Optimizing Loops
If you discover a loop in a stored procedure, you might find that the code iterates thousands of times before the loop exits. One way to improve the performance of loops is to optimize variable handling.
Compare Databases' Structural Differences
The sp_DBDiff stored procedure lets you can compare the structural differences of databases by generating a report that lists new tables, dropped tables, new columns, dropped columns, and column definition changes.
Easily Identify the Most Accessed Tables in Your Database 1
By combining the schema views of sys.tables and sys.dm_db_index_usage_stats in SQL Server 2005, you can find out which tables users access the most.
Handy CLR Functions That You Can Call from T-SQL Code
Here are 17 string-manipulation functions written in Visual Basic, Visual C#, and Visual C++ that you can call from T-SQL code.
Download T-SQL User-Defined String Functions
Here are some helpful user-defined functions for manipulating strings in T-SQL code.
Use CURSOR to Send Customized Email
Companies often need to send email to a group of people, but each mail message needs to contain unique information for each person. Here’s how you can accomplish that task.
Drop SQL Server Some Subtle Hints
Microsoft SQL Server’s cost-based optimizer must find the most efficient way to execute any query. To help with this difficult task, you can provide some subtle hints.
Letters, October 2005
Readers write in about August's "Logical Puzzle"-- plus some updates on our Readers' Choice issue.
Simulating Oracle Sequences in T-SQL Code 1
Oracle sequences offer certain advantages over SQL Server’s Identity column. Here’s how you can simulate Oracle sequences in T-SQL code.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014
blog

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×