Viewing 15 posts - 34,216 through 34,230 (of 49,552 total)
The Dixie Flatline (2/4/2010)
February 4, 2010 at 7:55 am
It is possible to configure indexes so that they can be used for Order By and Group By, it's difficult, it cannot always be done. It's something that I put...
February 4, 2010 at 7:51 am
Jack Corbett (2/4/2010)
February 4, 2010 at 7:47 am
They can try buying a data retrieval tool to 'undelete' the files, but the chances of recovering it is rather slim.
No backups at all?
February 4, 2010 at 6:25 am
Willem's will work, providing you run update usage first. Otherwise the rowcounts can be inaccurate (sysindexes' row count is not 100% accurate)
dbcc updateusage (0) with count_rows
February 4, 2010 at 5:58 am
You need a backup that was taken before whatever happened. You cannot take a backup after a crash to undo it.
Do you have a backup from before 12:41? Do you...
February 4, 2010 at 5:54 am
Please post new questions in a new thread. Thank you
February 4, 2010 at 5:49 am
Ville Lucander (2/4/2010)
should always be written as
Select * from table where some_attribute NOT IN (Select...
February 4, 2010 at 5:49 am
akshaycjoshi (2/4/2010)
U mean to say that n!=null returns unknown when n is null, right ?
If you want to be precise and formal, yes. I'll use null and interchangeably in logical...
February 4, 2010 at 2:51 am
The Dixie Flatline (2/3/2010)
Congratulations, Jack!!... and belated congratulations Saint Lynn!
Hi Bob. Where yea been?
February 4, 2010 at 2:26 am
Lynn Pettis (2/3/2010)
Jack Corbett (2/3/2010)
Lynn Pettis (2/3/2010)
Congrats Jack!! :w00t:I feel slighted, only 1 person even acknowledge when I hit 10,000. 🙁
And it probably wasn't me. Now I feel bad....
February 4, 2010 at 2:24 am
It comes down to the truth table for ANDs and ORs when nulls are involved. (It's in Books Online for anyone interested)
In the case of NOT in,
SELECT n FROM...
February 4, 2010 at 2:20 am
Paul Randal (2/3/2010)
Gail - you mean you don't have all the allocation bitmap page IDs and intervals burned into your brain? Lucky you 🙂
Not yet, I'm working on it though.
Can...
February 4, 2010 at 2:13 am
Lynn Pettis (2/3/2010)
Congrats Jack!! :w00t:I feel slighted, only 1 person even acknowledge when I hit 10,000. 🙁
Don't worry, same thing happened when I hit 15000. But then I only noticed...
February 4, 2010 at 2:12 am
Viewing 15 posts - 34,216 through 34,230 (of 49,552 total)