Browse by Tags

• Configuration
• Did You Know
• Internals
• Rants and Ramblings
• SQL Server 2008
• Transact-SQL

• There is no such thing as a “Small Change” to a production database

  It seems like every week I get hit up with some kind of “Its a view only for this specific report,” or “It is a simple change that the vendor would have made if they had access” type of request related to SQL Server.  If you’ve never dealt with me, Read More... Posted Tuesday, August 03, 2010 10:50 PM by Jonathan Kehayias | 9 Comments Filed under: Database Administration, Miscellaneous

• Should SQL Server advanced features be available a la carte?

  SQL Server users love the new features inside of the platform and each new release brings more exciting enhancements that motivate end users towards upgrading from previous editions. However, one of the biggest gripes I see from the SQL Server Community Read More... Posted Monday, June 21, 2010 11:32 PM by Jonathan Kehayias | 9 Comments Filed under: Rants and Ramblings, Database Administration, Miscellaneous, SQL Server 2008

• Does the tempdb Log file get Zero Initialized at Startup?

  While working on a problem today I happened to think about what the impact to startup might be for a really large tempdb transaction log file.  Its fairly common knowledge that data files in SQL Server 2005+ on Windows Server 2003+ can be instant Read More... Posted Thursday, May 13, 2010 9:13 PM by Jonathan Kehayias | 9 Comments Filed under: Database Administration, Miscellaneous, Did You Know, Internals

• Why the “Toilet” Analogy for SQL might be bad

  Robert Davis(blog/twitter) recently blogged The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads , in which he uses an analogy for why increasing the value for the ‘max worker threads’ sp_configure option can be bad inside of SQL Server.  Read More... Posted Saturday, May 08, 2010 3:33 AM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Miscellaneous, Configuration

• Have you got air in your spare tire? (Have you checked your DR/HA plans?)

  This morning I was late to work because as I backed out of the driveway I noticed that my wife's car had a flat tire.  This should be a pretty simple thing to fix, but it turns out that the spare tire was also flat.  This too should have been Read More... Posted Wednesday, October 21, 2009 11:13 AM by Jonathan Kehayias | 8 Comments Filed under: Database Administration, Miscellaneous

• Another use for the Default Trace: Mapping Temporary Tables to Sessions

  Here’s another use for the information captured by the default trace.  Ever wonder what session created the tables that exist in tempdb?  Well you can find it using the default trace and the sys.objects view in tempdb.  Any time an object Read More... Posted Tuesday, September 29, 2009 6:06 AM by Jonathan Kehayias | 3 Comments Filed under: Transact-SQL, Database Administration, Miscellaneous

• SQLCAT Technical Note: Resolving PageLatch Contention on Highly Concurrent Insert Workloads Part 1

  Its funny to see this new technical note posted by the SQLCAT team today because we just recently had a discussion about this on Twitter.  My good friend Sankar Reddy ( Blog / Twitter ) sent me an IM with the link to this page based on the twitter Read More... Posted Tuesday, September 22, 2009 10:29 PM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Miscellaneous, Internals

• Update - SQL Blocked Process Monitor

  Due to dependency requirements I had to split this tool into two separate tools one for SQL Server 2005, and one for SQL Server 2008 today, and I have reposted the newer builds on the codeplex site: http://sqlblockedprocessmon.codeplex.com/ one build Read More... Posted Tuesday, April 28, 2009 10:18 PM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Miscellaneous

• Using SQL Client Configuration Alias to Create Linked Server

  If you have a named instance of SQL Server and you need to create a Linked Server to it, using the SQL Native Client will result in a Linked Server like SQLDEMO\SQLEXPRESS.  This isn't ideal for coding against.  One thing that you can do is Read More... Posted Tuesday, October 14, 2008 8:07 PM by Jonathan Kehayias | 0 Comments Filed under: Database Administration, Miscellaneous