Viewing 15 posts - 17,131 through 17,145 (of 22,209 total)
suhas.wadadekar (6/19/2009)
Dropping a database and creating a new one is an option. But, I was trying to avoid dropping the procedures and functions written for the...
June 19, 2009 at 9:13 am
dan (6/19/2009)
Sorry for my previous brief posts with bad spelling and grammer. Here is what I have found:
The optimiser deals better with a sub query look up rather than a...
June 19, 2009 at 8:47 am
Except for third party databases, all our databases are built from source, so we can drop the database and recreate it pretty much by pushing a button.
However, you could look...
June 19, 2009 at 8:42 am
Once you've established blocking, you need to understand why there is blocking. It could be poor performance requiring index or query tuning or it might be transaction management or contention...
June 19, 2009 at 8:37 am
An index that has all three columns, which makes it covering. It can also be covering if one or more (or all three) of the indexes is in the clustered...
June 19, 2009 at 8:00 am
hi_abhay78 (6/18/2009)
SELECT MIN(TicketId) FROM TicketActivity
The above 2 queries are different.
But you can also run the min query as below :
select top 1 ticketid from TicketActivity order...
June 19, 2009 at 7:52 am
What you've got are an ordering query, TOP, and an aggregate query, MIN. The ordering query must have an ORDER BY statement to work. You can't know what order things...
June 19, 2009 at 7:49 am
GilaMonster (6/19/2009)
One I asked once (in an interview for senior position) was how to repair a torn page without losing any data. Anyone want to guess the answer I got?
I'm...
June 19, 2009 at 7:29 am
Excellent article. Thanks for putting it up. I just wish you had posted it a few years ago. I'm going to print it out now & keep it handy as...
June 19, 2009 at 6:10 am
jason brimhall (6/18/2009)
I like to throw in some good code and bad code samples. You pick out which one works better and tell me why. Or I...
June 19, 2009 at 5:56 am
Matt Miller (6/18/2009)
"What is...
June 19, 2009 at 5:51 am
Have you tried querying the dynamic management view sys.dm_exec_query_text yet? Any inline queries will be visible there, for the time that they're in cache.
June 19, 2009 at 5:49 am
mazzz (6/19/2009)
Has SSC ever had a thread like this?
That is a weird one isn't it? It doesn't look like Phil helped matters much.
I have to say, some of our discussions...
June 19, 2009 at 5:46 am
Sure, errors will cause gaps, deletions, anything that causes an incomplete transaction, implicit or explicit, can lead to gaps. If you need a perfectly flawless incrementally increasing number, with no...
June 19, 2009 at 5:43 am
Nope. Never mind. I was wrong (again). Showplan XML Statistics Profile does include the actual execution plan. Whew. I feel a little better now.
June 18, 2009 at 1:12 pm
Viewing 15 posts - 17,131 through 17,145 (of 22,209 total)