Viewing 15 posts - 42,076 through 42,090 (of 49,562 total)
From an initial read, without a backup there's no way of fixing this without a lot of data loss.
I'm no expert on SQL 7, I've never worked with SQL...
December 30, 2008 at 1:36 pm
Check the SQL error log. Normally that message means that you've hit an error with a severity of 20 or higher (very, very severe) and the connection has been closed...
December 30, 2008 at 1:34 pm
Those are table variables. I would guess they are used quite often.
Don't worry about them. SQL 2005 has a caching mechanism for temp tables. If it knows the temp table...
December 30, 2008 at 1:32 pm
I think that query will benefit from a nonclustered index on the Store table. Try this for starters
CREATE INDEX idx_Store_CancelDateStoreID ON Store (StoreID, CancelDate, InDate, OutDate, NumberofParts)
It's wider than I...
December 30, 2008 at 1:28 pm
homebrew01 (12/30/2008)
"isn't SQL doing 55 million seeks"I meant to say: Isn't SQL reading 55 million rows instead of reading 422,000 rows ?
Take a mid-sized computer book with a comprehensive index...
December 30, 2008 at 1:23 pm
bang725 (12/30/2008)
Hi,Following query is taking 1 min to execute. Please suggest improvements?
Please post table and index definitions.
December 30, 2008 at 10:28 am
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
Viewing 15 posts - 42,076 through 42,090 (of 49,562 total)