http://www.sqlmag.com/authors/author/author/5037667/rss/5037667en-USFri, 25 May 2012 10:28:03 GMTFri, 25 May 2012 10:28:03 GMThttp://www.sqlmag.com/article/sql-server/iams-keeping-track-space-143102
By Kalen Delaney
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.]]>Kalen DelaneyWed, 16 May 2012 13:01:00 GMThttp://www.sqlmag.com/article/sql-server/iams-keeping-track-space-143102http://www.sqlmag.com/article/sql-server/sql-servers-undocumented-142866
By Kalen Delaney
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.]]>Kalen DelaneyWed, 18 Apr 2012 12:44:22 GMThttp://www.sqlmag.com/article/sql-server/sql-servers-undocumented-142866http://www.sqlmag.com/article/sql-server-2012/sql-server-2012-released-concurrently-launch-events-142578
By Kalen Delaney
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 installed.]]>Kalen DelaneyThu, 15 Mar 2012 11:00:00 GMThttp://www.sqlmag.com/article/sql-server-2012/sql-server-2012-released-concurrently-launch-events-142578http://www.sqlmag.com/article/sql-server/small-code-bigger-sql-server-performance-improvements-142287
By Kalen Delaney
Kalen Delaney offers an expert tip about a simple code change that can be made to search arguments (SARGs) to improve SQL Server performance.]]>Kalen DelaneyThu, 16 Feb 2012 09:55:13 GMThttp://www.sqlmag.com/article/sql-server/small-code-bigger-sql-server-performance-improvements-142287http://www.sqlmag.com/article/sql-server/small-code-big-sql-server-performance-improvements-141959
By Kalen Delaney
Learn how you can replace a scalar-valued user-defined functions (UDFs) call with actual code to greatly improve SQL Server performance.]]>Kalen DelaneyThu, 19 Jan 2012 15:37:31 GMThttp://www.sqlmag.com/article/sql-server/small-code-big-sql-server-performance-improvements-141959http://www.sqlmag.com/article/sql-server/hint-query-hints-141750
By Kalen Delaney
Kalen discusses two reasons she finds SQL Server query hints to be fascinating.]]>Kalen DelaneyThu, 29 Dec 2011 16:02:47 GMThttp://www.sqlmag.com/article/sql-server/hint-query-hints-141750http://www.sqlmag.com/article/sql-server/sql-server-2012-141330
By Kalen Delaney
Kalen Delaney asks which SQL Server 2012 features you want to learn about and how in-depth you’d like the coverage to be.]]>Kalen DelaneyThu, 17 Nov 2011 15:28:13 GMThttp://www.sqlmag.com/article/sql-server/sql-server-2012-141330http://www.sqlmag.com/article/conferences-and-trade-shows/pass-summit-2011-highlights-140987
By Kalen Delaney
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 sessions, and more.]]>Kalen DelaneyThu, 20 Oct 2011 09:00:00 GMThttp://www.sqlmag.com/article/conferences-and-trade-shows/pass-summit-2011-highlights-140987http://www.sqlmag.com/article/database-administration/pros-cons-parameter-sniffing-140598
By Kalen Delaney
A look at the pros and cons of parameter sniffing, locked data, table scans, and query recompilation.]]>Kalen DelaneyThu, 15 Sep 2011 12:01:31 GMThttp://www.sqlmag.com/article/database-administration/pros-cons-parameter-sniffing-140598http://www.sqlmag.com/article/training-and-certification2/sql-server-training-options-140429
By Kalen Delaney
Kalen Delaney explores SQL Server training options, including online training, in-person training, and hybrid approaches. ]]>Kalen DelaneyThu, 01 Sep 2011 09:47:06 GMThttp://www.sqlmag.com/article/training-and-certification2/sql-server-training-options-140429http://www.sqlmag.com/article/SQLServerDenali/kid-town-sql-server-denali-139912
By Delaney, Kalen
Kalen explores SQL Server Denali’s future name, installation process, and commands that have been deprecated.]]>Delaney, KalenThu, 21 Jul 2011 11:10:13 GMThttp://www.sqlmag.com/article/SQLServerDenali/kid-town-sql-server-denali-139912http://www.sqlmag.com/article/sql-server/testing-heavy-load-simulating-multiple-concurrent-operations-139502
By Kalen Delaney
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.]]>Kalen DelaneyThu, 16 Jun 2011 16:07:00 GMThttp://www.sqlmag.com/article/sql-server/testing-heavy-load-simulating-multiple-concurrent-operations-139502http://www.sqlmag.com/article/sql-server/spring-cleaning-sql-server-stored-procedures-135938
By Kalen Delaney
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.]]>Kalen DelaneyThu, 21 Apr 2011 09:00:00 GMThttp://www.sqlmag.com/article/sql-server/spring-cleaning-sql-server-stored-procedures-135938http://www.sqlmag.com/article/quering/do-you-need-a-sql-server-query-hint-
By Kalen Delaney
Find out how query hints can benefit you in certain situations and how the hints affect SQL Server’s built-in query optimizer.]]>Kalen DelaneyThu, 17 Mar 2011 10:00:00 GMThttp://www.sqlmag.com/article/quering/do-you-need-a-sql-server-query-hint-http://www.sqlmag.com/article/database-administration/using-table-partitions-to-archive-old-data-in-oltp-environments
By Kalen Delaney
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 archive old data in an OLTP environment.]]>Kalen DelaneyThu, 10 Feb 2011 15:44:00 GMThttp://www.sqlmag.com/article/database-administration/using-table-partitions-to-archive-old-data-in-oltp-environmentshttp://www.sqlmag.com/article/log-files3/how-simple-is-logging-
By Kalen Delaney
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.]]>Kalen DelaneyThu, 10 Feb 2011 10:47:00 GMThttp://www.sqlmag.com/article/log-files3/how-simple-is-logging-http://www.sqlmag.com/article/sql-server/welcome-to-sql-server-2011
By Kalen Delaney
Welcome to (SQL Server) 2011]]>Kalen DelaneyThu, 13 Jan 2011 13:58:00 GMThttp://www.sqlmag.com/article/sql-server/welcome-to-sql-server-2011http://www.sqlmag.com/article/sql-server/measuring-expertise-the-new-sql-server-mcm-program
By Kalen Delaney
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 ensure that only qualified SQL Server professionals become MCMs?]]>Kalen DelaneyThu, 09 Dec 2010 10:39:00 GMThttp://www.sqlmag.com/article/sql-server/measuring-expertise-the-new-sql-server-mcm-programhttp://www.sqlmag.com/article/sql-server/sql-server-terms-what-s-in-a-name
By Kalen Delaney
When talking about relational databases, does it matter which terms you use to describe an object as long as the meaning is fully understood?]]>Kalen DelaneyThu, 18 Nov 2010 11:46:00 GMThttp://www.sqlmag.com/article/sql-server/sql-server-terms-what-s-in-a-namehttp://www.sqlmag.com/article/sql-server/how-much-social-networking-is-too-much-
By Kalen Delaney
Kalen explores the best place to post technical information on social media networks.]]>Kalen DelaneyThu, 21 Oct 2010 11:39:00 GMThttp://www.sqlmag.com/article/sql-server/how-much-social-networking-is-too-much-