Viewing 15 posts - 6,736 through 6,750 (of 7,418 total)
Excellent article overall.
These are extremely difficult concepts to introduce to people, and the article does a superb job of making the ideas accessible to anyone.
[I do think Alice should have...
January 11, 2013 at 8:45 am
Steven Willis (1/10/2013)
ScottPletcher (1/10/2013)
dwain.c (1/9/2013)
Steven - Those FUNCTIONs look like nice work. I've saved them off for future analysis. 🙂
You might want to review the new functions in SQL...
January 10, 2013 at 2:57 pm
dwain.c (1/9/2013)
Steven - Those FUNCTIONs look like nice work. I've saved them off for future analysis. 🙂
You might want to review the new functions in SQL 2012 dealing with...
January 10, 2013 at 1:51 pm
Bhuvnesh (1/9/2013)
ScottPletcher (1/9/2013)
the cursor should be optimized with FAST_FORWARD:Any article reference for this ?
Books Online.
January 10, 2013 at 8:29 am
Jeff Moden (1/9/2013)
ScottPletcher (1/9/2013)
Don't automatically assume the PK makes the best, or even a good, clustered index, in particular if the PK is an identity column.
Considering that the IDENTITY column...
January 10, 2013 at 8:28 am
GilaMonster (1/7/2013)
ScottPletcher (1/7/2013)
Fewest rows? The number of rows that match all the criteria will be the same regardless of the index used, right?
Match all criteria, yes. What I was...
January 9, 2013 at 4:13 pm
If you start your procedure name with "sp_", put it in the master db, and mark it as a system object, it can execute in the context of the current...
January 9, 2013 at 4:01 pm
If you just want to run the proc for a single db at a time, you don't need dynamic SQL at all, so I suggest avoiding it. The code's...
January 9, 2013 at 3:33 pm
I, too, don't have a problem with a cursor per se here; it could be done w/o one, but it's not a big deal for such a limited number of...
January 9, 2013 at 3:18 pm
Btw, it's always frustrated me that SQL Server can't seem to read only the non-leaf pages of a clustered index. If SQL needs only key column(s), why does it...
January 9, 2013 at 2:36 pm
Don't automatically assume the PK makes the best, or even a good, clustered index, in particular if the PK is an identity column.
You need to review the existing index usage,...
January 9, 2013 at 2:36 pm
GSquared (1/7/2013)
paul.j.kemna (1/7/2013)
But in this case, we are assuming that I...
January 8, 2013 at 8:31 am
CELKO (1/4/2013)
Think about what a confused mess this statement is in the SQL model.
SELECT f(c2) AS c1, f(c1) AS c2 FROM Foobar;
That is why such nonsense is illegal syntax.
Your...
January 7, 2013 at 5:10 pm
If all the columns are from a single table, you definitely should created a computed column that has the computation: that way, the definition is in only one place. ...
January 7, 2013 at 5:06 pm
🙂
GilaMonster (1/7/2013)
What is the basis for you claim that if only 1% of rows in the table match that SQL will almost certainly do a table scan? If the...
January 7, 2013 at 3:45 pm
Viewing 15 posts - 6,736 through 6,750 (of 7,418 total)