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.
By Kalen Delaney, 09/30/2010
Kalen explores whether a version of SQL Server can be considered a failure if its missing features that were supposed to be in it.
By Kalen Delaney, 08/19/2010
How can we ensure that everyone can find the SQL Server information they need?
By Kalen Delaney, 07/28/2010
Should you learn SQL Server internals? If you're interested in how SQL Server really works, you should.
By Kalen Delaney, 06/17/2010
Kalen explores the popularity of attending and speaking at the SQL Saturday events.