Free SQL Server Learning - Using SQL Server DMVs to Help Improve Performance

solving sql server problems for millions of dbas and developers since 2006

SQL Product Highlight

Idera - SQL safe backup

SQL Server backup compression with network fault tolerance and zero impact encryption

Fast, compressed & encrypted SQL backup and restore
SQL Server backup compression of 95%
At least 50% faster than native SQL backups

Learn more!

Andy Novick

Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server's capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular "SQL Server Loadfest" event held in Waltham, MA.

Aggregates

Concat Aggregates SQL Server CLR Function (5/20/2010)
Multi parameter CLR aggregate in SQL Server 2005 (6/21/2010)

Database Administration

DBA Best Practices

Requesting and researching SQL Server enhancements with Connect (2/26/2009)

Error Handling

Using the NOWAIT option with the SQL Server RAISERROR statement (1/7/2009)

Functions - User Defined UDF

How to execute a DOS command when xp_cmdshell is disabled in SQL Server (8/11/2010)
SQL Server CLR function to concatenate values in a column (2/19/2009)
SQL Server function to validate email addresses (1/23/2009)
SQLCLR function to return free space for all drives on a server (4/16/2010)
Writing to an operating system file using the SQL Server SQLCLR (1/9/2009)

Hardware

Benchmark SQL Server IO after partition offset and allocation unit changes (11/2/2010)
Benchmarking SQL Server IO with SQLIO (10/4/2010)
Format drives with correct allocation and offset for maximum SQL Server performance (10/11/2010)
Partition offset and allocation unit size of a disk for SQL Server (9/23/2010)

Import and Export

Using OPENROWSET to read large files into SQL Server (12/10/2008)

Performance Tuning

Convert Implicit and the related performance issues with SQL Server (4/21/2009)
Issues with running DBCC SHRINKFILE on your SQL Server data files (7/7/2010)

SQL Azure

SQL Azure Migration Wizard (4/21/2010)

T-SQL

Calculating and verifying financial values in SQL Server (5/6/2010)
Getting a SQL Server RowCount Without doing a Table Scan (8/21/2006)
SQL Server work around for Msg 2714 There is already an object named #temp in the database (6/2/2009)

User Defined Type UDT

SQL Server User Defined Type To Store and Process Email Addresses (6/1/2010)

Sponsor Information

Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

SQL Monitor: prioritize your SQL Server workload with easy-to-use performance monitoring

Need SQL Server help and not sure where to turn? Reach out to expert consultants in the USA for a Health Check.

Free SQL Server performance monitoring software! Improve performance by 65% today with IgniteFree.

The SQL Server Security THREAT - It’s Closer Than You Think

Copyright (c) 2006-2013 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com