April 2010 - Posts

• Table or index that goes nowhere

  SQL Server allows you to create a table or an index on a filegroup that has no file assigned to it. Because there is no data file to hold your data, the table or the index thus created cannot be used. This may not be a problem because often you would Read More... Posted Thursday, April 29, 2010 10:17 AM by Linchi Shea | 1 Comments Filed under: Filegroup

• SQL Trace challenge: a simple requirement

  SQL Trace (or SQL Profiler) is no doubt an excellent tool. But its filtering capability is rather primitive, and is very poorly documented. Here is a request that is simple and seems to be rather reasonable. Create a trace to filter for the following: Read More... Posted Thursday, April 29, 2010 12:48 AM by Linchi Shea | 20 Comments Filed under: Profiler, SQL Trace