Viewing 15 posts - 46 through 60 (of 61 total)
I think most developers most of the time don't think about consistency in their application. SQL is so robust and ubiquitous that they take it's guarantees for granted even...
March 14, 2011 at 2:15 pm
jswong05 (11/5/2009)
David is smart. That is exactly right. http://support.microsoft.com/kb/937682How would this feature pass SOX audit? which is trying to control access.
This is one of many reasons why...
March 11, 2011 at 11:58 am
Shrinkfile is a bad option on production data files. It will fragment your indexes to heck and back. See this article.
February 17, 2011 at 12:28 pm
Is there a difference between online and offline?
What about sort in tempdb?
January 20, 2011 at 12:10 pm
I worry that the DISTINCT is going to give people the impression that OVER/PARTITION does the same thing as GROUP BY. It's an important distinction and the explanation doesn't...
November 4, 2010 at 11:20 am
ebay-1087924 (10/25/2010)
cdesmarais 49673 (10/25/2010)
But if you assume truly random inserts, updates, and deletes (a pair of GUIDs for example), my benchmarks came up consistently in favor of the heap.
You might...
October 25, 2010 at 2:28 pm
ebay-1087924 (10/25/2010)
October 25, 2010 at 2:14 pm
I just did a whole bunch of benchmarking with 2008 r2. On pure junction tables with any sort of reasonable FK sizes, it's still true. The extra int...
October 25, 2010 at 2:05 pm
denis.hosdil (10/25/2010)
cdesmarais 49673 (10/25/2010)
October 25, 2010 at 1:48 pm
Surrogate keys on pure junction tables are bad, but it seems like alot of people are putting clustered covering keys over both columns, which can be almost as bad. ...
October 25, 2010 at 1:27 pm
I've written lots of rollback scripts as part of deployments to deal with this, but (furious knocking on wood) I've never actually had to use one.
There isn't going to be...
October 15, 2010 at 2:41 pm
Is the OP maybe talking about fiber vs iSCSI?
October 15, 2010 at 12:14 pm
The very first things I look at in a proc are cursors, scalar UDF's, and IN abuse. Table/clustered index scans and temp tables may or may not be appropriate,...
September 10, 2010 at 12:02 pm
My brain is probably too rigid at categorizing things, but I would want to stick with the list of 5 as types and Unique, Filtered or Included columns as properties...
July 22, 2010 at 3:20 pm
Books online isn't completely consistent. The enumeration of index types depends on the context you are looking at it. Frex.
July 22, 2010 at 11:24 am
Viewing 15 posts - 46 through 60 (of 61 total)