By Kalen Delaney, 05/16/2012
Every SQL table and index has at least one Index Allocation Map (IAM). Learn more about IAMs and how much space is actually allocated to a SQL Server table.
By Kalen Delaney, 04/18/2012
The DBCC IND command is available in SQL Server 2012 and is still undocumented, but in SQL Server 2012 there's a replacement to DBCC IND that’s even more useful.
By Kalen Delaney, 03/15/2012
Unlike the documentation for previous SQL Server versions, the documentation downloads don't seem to be available as a standalone app. You have to have SQL Server 2012 already ...
By Kalen Delaney, 02/16/2012
Kalen Delaney offers an expert tip about a simple code change that can be made to search arguments (SARGs) to improve SQL Server performance.
By Kalen Delaney, 01/19/2012
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance.
By Kalen Delaney, 12/29/2011
Kalen discusses two reasons she finds SQL Server query hints to be fascinating.
By Kalen Delaney, 11/17/2011
Kalen Delaney asks which SQL Server 2012 features you want to learn about and how in-depth you'd like the coverage to be.
By Kalen Delaney, 10/20/2011
A look back at PASS Summit 2011, including how the #sqlpass hashtag grew excitement for the event, how first time attendees felt about their first PASS Summit, differences between ...
By Kalen Delaney, 09/15/2011
A look at the pros and cons of parameter sniffing, locked data, table scans, and query recompilation.
By Kalen Delaney, 09/01/2011
Kalen Delaney explores SQL Server training options, including online training, in-person training, and hybrid approaches.
By Delaney, Kalen, 07/21/2011
Kalen explores SQL Server Denali's future name, installation process, and commands that have been deprecated.
By Kalen Delaney, 06/16/2011
It is necessary to test your database application performance with many concurrent operations to simulate multiuser environments. Here's some suggestions for how to do so.
By Kalen Delaney, 04/21/2011
While browsing SQL Server’s documentation recently, I found two stored procedures for removing ghost records: sp_clean_db_free_space and sp_clean_db_file_free_space.
By Kalen Delaney, 03/17/2011
Find out how query hints can benefit you in certain situations and how the hints affect SQL Server's built-in query optimizer.
By Kalen Delaney, 02/10/2011
If you have a large OLTP database, it might make sense to move less frequently accessed data onto cheaper storage with less frequent backups. Learn how to use table partitions to ...
By Kalen Delaney, 02/10/2011
A look at SQL Server's three recovery models (i.e., SIMPLE recovery, BULK_LOGGED recovery, and Full recovery) and how each of them logs data.
By Kalen Delaney, 01/13/2011
By Kalen Delaney, 12/09/2010
The revised Microsoft Certified Master (MCM) in SQL Server requirements offer more opportunities for SQL Server professionals to become MCM certified. But will the new exams ...
By Kalen Delaney, 11/18/2010
When talking about relational databases, does it matter which terms you use to describe an object as long as the meaning is fully understood?
By Kalen Delaney, 10/21/2010
Kalen explores the best place to post technical information on social media networks.