Browse by Tags

• Best Practices
• Catalog Objects
• Concurrency
• Constraints
• Database Design
• Denali
• Development
• Dynamic Management Objects
• MVP
• PASS
• Performance
• Security
• Speaking
• SQL Server
• SQL Techniques
• SQL Tools
• SQLPASS
• System Functions
• Tips
• Utility
• Why We Write
• Writing

• Why We Write #4 - An Interview With Doug Lane

  My next guest is Doug Lane , who has been blogging for the past few years on his website: http://www.douglane.net/ . Doug is also a speaker who has spoken at SQL Saturdays as well as the SQL PASS Summit , and as I write these interview questions was on Read More... Posted Tuesday, April 23, 2013 10:56 PM by drsql | 2 Comments Filed under: T-SQL, Writing, SQLPASS, Why We Write

• One more reason to to understand query plans, not directly performance related

  One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming languages, it is very obvious what is going on inside the computer because you are working at Read More... Posted Tuesday, January 22, 2013 11:28 PM by drsql | 7 Comments Filed under: T-SQL, Development, Performance

• Utility Queries–Structure of Tables with Identity Column

  Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function to using sys.tables. When writing code that is expected to have reuse, it can be safer to use the tables rather than functions Read More... Posted Sunday, September 02, 2012 4:05 PM by drsql | 6 Comments Filed under: T-SQL, Development, SQL Tools, Utility

• Speaking at PASS 2012… Exciting and Scary… As usual…

  Edit: As I reread this, I felt I should clarify.. As usual refers mostly to the "Scary" part. I have a lot of stage fright that I have to work through. And it is always exciting to be picked. I have been selected this year at the PASS Summit 2012 to do Read More... Posted Saturday, June 23, 2012 7:03 PM by drsql | 1 Comments Filed under: T-SQL, PASS, Speaking, MVP, SQLPASS

• Utility Queries–Column Metadata

  Very often, I find myself wanting to query system metadata for columns. Some of the metadata is fairly easy to deal with, like if you want to find column names, just simply querying sys.columns is very straightforward. But if you want to query data types, Read More... Posted Sunday, April 22, 2012 11:57 PM by drsql | 0 Comments Filed under: T-SQL, Catalog Objects, Constraints, Utility

• Planning my Louisville SQL Saturday Presentation

  So it is Tuesday night, just a few days until my presentation entitled What Counts For A DBA and I am still not completely sure exactly what is going to go on. In fact, I don’t exactly plan to know what is going on until the presentation is over.  Read More... Posted Tuesday, October 25, 2011 10:47 PM by drsql | 0 Comments Filed under: T-SQL, Speaking

• Denali Enhancement–Duplicate Key Error Message

  When I was editing my chapter on implementing a database, I noticed a really nice improvement in the error message I had from the previous edition of the book. Instead of just telling me that there was a value in my modification statement that duplicated Read More... Posted Thursday, July 14, 2011 1:12 AM by drsql | 6 Comments Filed under: T-SQL, Constraints, Denali

• disallow results from triggers

  A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.   Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor Read More... Posted Saturday, June 06, 2009 10:38 PM by drsql | 1 Comments Filed under: T-SQL, SQL Techniques, Best Practices, Development, Tips

• Granting rights to all objects in a database

  File this under the “I can’t believe there is still stuff that I keep learning about SQL Server 2005!” though thankfully most things I find I learn are things I wouldn’t be all that likely to use. I was asked today how I felt about using the syntax: GRANT Read More... Posted Friday, March 13, 2009 12:38 AM by drsql | 8 Comments Filed under: T-SQL, Security, Tips

• 2008: Declaring and instantiating a value

  Ok, I admit it. Sometimes the least important things are the most fun. As I try to get my blog back up and kicking again after a few months of holiday fun coupled with some dreary personal life things (a death in the family and lots of sickness/busyness, Read More... Posted Saturday, March 01, 2008 7:40 PM by drsql | 16 Comments Filed under: SQL Server, T-SQL

• 2008: Rebuilding a Heap

  In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy. You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do. They have added to the ALTER TABLE command Read More... Posted Tuesday, February 26, 2008 11:10 PM by drsql | 7 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• Changing the owner of a database

  Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about Read More... Posted Wednesday, December 05, 2007 12:06 AM by drsql | 1 Comments Filed under: SQL Server, T-SQL

• sys.dm_db_index_operational_stats

  This object provides very useful stats on how many times an index has been used, locked, waited on, etc. An index in this context can mean several things: a clustered index, heap, index, or a partition of either of these. The grain of the function is Read More... Posted Sunday, August 26, 2007 4:12 PM by drsql | 5 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_exec_query_optimizer_info

  Information about how queries have been optimized since the server has been restarted. Note that counters are only affected when there is some sort of optimization event, not on every query. (reference: http://sqlserver-qa.net/blogs/perftune/archive/2007/05/11/get-statistics-on-query-plan-optimizer-execution.aspx Read More... Posted Monday, August 06, 2007 8:40 PM by drsql | 1 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_io_virtual_file_stats

  Excellent dmv that shows, for each file that SQL Server uses for the databases, stats on how frequently the file has been used by the database. This is one of the primary dynamic management views I use almost daily (well, not usually when I am on vacation, Read More... Posted Friday, July 27, 2007 9:26 PM by drsql | 12 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects