Viewing 15 posts - 41,641 through 41,655 (of 49,571 total)
RBarryYoung (1/17/2009)
This being an ORDER BY on the outermost SELECT, it seems that it is guaranteed to be so sorted.
Ummm. This is an odd case. I chatted with one of...
January 18, 2009 at 2:35 am
Jeff Moden (1/17/2009)
Heh... first, you do realize that I was spoofing on him, right. 🙂 Just gotta make sure.
It was prettyn obvious
And I agree... correct answer for the...
January 18, 2009 at 2:23 am
kiransuram19 (1/17/2009)
January 18, 2009 at 2:22 am
Paresh Prajapati (1/17/2009)
Anywany if u want to talt log backup with truncation , Please take full backup of database after that..
I said that.
GilaMonster (1/17/2009)
January 18, 2009 at 2:09 am
Paresh Prajapati (1/17/2009)
That'y i said to take transaction log backup of current DB again and then apply it after that..
Except that, as Paul said, if the log's corrupt when you...
January 18, 2009 at 2:00 am
MichaelJasson (1/17/2009)
January 18, 2009 at 1:58 am
krypto69 (1/17/2009)
What am I missing?
An attached execution plan, along with the table definition, the index definitions and, if possible, an estimate of the number of rows in the table, the...
January 17, 2009 at 2:45 pm
Jeff Moden (1/17/2009)
Heh... I can just see the flame comments now.
😀
I'm writing an article on corruption at the moment and one of the things I've had to put...
January 17, 2009 at 2:23 pm
bhushanvinay (1/17/2009)
Look at issuing a nolock on the tables when do create the stored proc's this should help in getting the locks down.
Providing you don't mind the chance of incorrect...
January 17, 2009 at 2:12 pm
Jeff Moden (1/17/2009)
how can you possibly think he's wrong?
Well, it's not that he's wrong. That's a perfectly correct answer, just to a different question. It's the same as...
January 17, 2009 at 2:09 pm
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions. All this does is waste everyone's...
January 17, 2009 at 2:06 pm
Just databases that are currently attached to the instance. If it was very recent, check out the default trace. It should have info on dropped databases. You'll find the .trc...
January 17, 2009 at 1:57 pm
MichaelJasson (1/17/2009)
I wanted to understand where this backup is taken. I couldn't find the backup of the transaction log.
It's not. That's the whole point. TRUNCATE ONLY means don't write out...
January 17, 2009 at 1:53 pm
Jeff Moden (1/17/2009)
the thing is that Ranking can take care of that one because you're grouping by day.
No, I'm not. A group is any number of events that are...
January 17, 2009 at 1:51 pm
bravadortb (1/17/2009)
I'm wondering if there is a correct order in which the columns should appear in the WHERE clause?
Not at all. The order that you specify has nothing...
January 17, 2009 at 1:07 pm
Viewing 15 posts - 41,641 through 41,655 (of 49,571 total)