Browse by Tags

• 64 Bit
• Catalog Objects
• Concurrency
• Documentation
• Dynamic Management Objects
• PASS
• Search
• SQL Techniques
• SQL Tools
• SSAS
• SSIS
• SSMS
• System Functions
• Third Party Tools
• T-SQL

• 2008: Error List in 2008

  Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn't the point,) when I found this blog: http://geekswithblogs.net/Sreeblog/articles/117576.aspx that basically Read More... Posted Wednesday, March 05, 2008 10:40 PM by drsql | 5 Comments Filed under: SQL Server, SQL Tools, SSMS

• 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 | 18 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 | 3 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 | 2 Comments Filed under: SQL Server, T-SQL

• PASS Followup, Technical Edition

  I have already given a rundown of most everything PASS here on my personal blog, including a series of posts with pictures too over the days of PASS ) but since this blog is all about things technical with SQL Server, I wanted to just rundown of some Read More... Posted Tuesday, September 25, 2007 1:03 AM by drsql | 2 Comments Filed under: SQL Server, PASS

• 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 | 2 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 | 2 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 | 5 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_index_usage_stats

  This object gives statistics on how an index has been used to resolve queries. Most importantly it tells you the number of times a query was used to find a single row ( user_seeks ), a range of values, or to resolve a non-unique query ( user_scans ), Read More... Posted Sunday, July 22, 2007 10:45 PM by drsql | 5 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_file_space_usage

  Give space usage of objects in tempdb (most likely this will be extended to more than just tempdb in a future edition of SQL Server.) Can be used to see how and why space is being used in Tempdb, on a file by file basis. Type: View Data: temporal, reflects Read More... Posted Saturday, July 14, 2007 3:35 PM by drsql | 3 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_partition_stats

  For the current database, gives you space oriented statistics for each partition of indexes (even if you only have one partion), like row count, page counts, etc. Resembles the sysindexes in previous versions of SQL Server, with more information. Type: Read More... Posted Wednesday, July 11, 2007 9:41 PM by drsql | 4 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• Blogging the DMV's

  Well, I am working on a project that is going to be a book on dynamic management views (and functions, but DMF is an interesting acronym, and objects, as in DMO, has a well known other meaning. What I will post will be one object in the following format: Read More... Posted Tuesday, July 10, 2007 12:14 AM by drsql | 4 Comments Filed under: SQL Server, T-SQL, Dynamic Management Objects

• SQL Server Search Macro (plus build your own directed search!)

  Microsoft has built a little site for searching the books online on the web (which gives you links that are more readily shared with others): http://search.live.com/macros/sql_server_user_education/booksonline That is nice, but what is nicer is that you Read More... Posted Tuesday, April 03, 2007 7:03 PM by drsql | 1 Comments Filed under: SQL Server, Search

• Getting the difference between two sets of like data

  A question came up on the forums the other day that a person wanted to compare two tables of data. Doing this is pretty easy using several techniques: Using EXCEPT Using NOT EXISTS Using a FULL OUTER JOIN First two sample tables which represent two sets Read More... Posted Thursday, February 08, 2007 9:59 PM by drsql | 3 Comments Filed under: SQL Server, T-SQL

• SSIS: ForEach Looping through a recordset

  I was trying to find a way to repeatedly run the same MDX CREATE GLOBAL CUBE statement 70 times, building 70 different offline cubes for sales rep type folks to carry around for a client, and I just couldn't get it. I have some experience with SSIS, mostly Read More... Posted Friday, January 19, 2007 12:26 AM by drsql | 0 Comments Filed under: SQL Server, SSIS, SSAS