Viewing 15 posts - 42,091 through 42,105 (of 49,571 total)
homebrew01 (12/30/2008)
Thanks, but I don't quite get it yet. Sorry for the "newbie" questions, but why does select * affect the use of an index ?
* means all...
December 30, 2008 at 10:18 am
homebrew01 (12/30/2008)
Does SQL think that a table scan is better for the larger result set ?
Yes. Because you're doing a select * , the index is...
December 30, 2008 at 7:25 am
raj acharya (12/30/2008)
if it returns 90 than that means it compatible for 2005 and if it returns 80 than it will compatible...
December 30, 2008 at 6:42 am
mathewspsimon (12/30/2008)
December 30, 2008 at 5:30 am
Jeff Moden (12/30/2008)
December 30, 2008 at 5:23 am
sunandas (12/30/2008)
Around 30000000 records are there in the table.
And you want to remove all of them?
I cant use TRUNCATE as its index will also removed(though I can recreate it again).
Truncate...
December 30, 2008 at 3:09 am
Jeff Moden (12/30/2008)
December 30, 2008 at 1:38 am
Jeff Moden (12/30/2008)
Seems like the intent of Microsoft was to make things easier for folks that don't know how to do it in T-SQL...
I don't agree with that. SSIS...
December 30, 2008 at 1:36 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic627035-146-1.aspx
December 30, 2008 at 12:59 am
Jeffrey Williams (12/30/2008)
The question I have is what else could cause a database to not have a current backup. Is this a bug that existed in an earlier version?
That's...
December 30, 2008 at 12:54 am
GilaMonster (12/29/2008)
How many rows do you need to delete, how many rows are you keeping?
December 30, 2008 at 12:47 am
I found the bug that I was thinking about, but it's 2005 RTM, fixed by SP2
http://support.microsoft.com/kb/921106
If the diff succeeds on the sat, but fails on the sunday, I think you're...
December 30, 2008 at 12:38 am
biniyb (12/30/2008)
It seems that you tested an error message pertaining to the log backup...i'm having an issue with the DIFF backup. Unless i completely misunderstood your explanation.
The test was for...
December 30, 2008 at 12:23 am
Bini, I seem to recall there's a bug in one version of SQL regarding the diff backups. Perhaps a google search of support.microsoft.com would turn something up
Jeffrey : I setup...
December 30, 2008 at 12:07 am
How many rows do you need to delete, how many rows are you keeping?
December 29, 2008 at 11:59 pm
Viewing 15 posts - 42,091 through 42,105 (of 49,571 total)