Viewing 15 posts - 42,076 through 42,090 (of 49,571 total)
Not an exhaustive compilation. Just a couple that bug me.
http://sqlinthewild.co.za/index.php/2008/05/20/common-t-sql-mistakes/
December 30, 2008 at 2:35 pm
Off hand, no idea. Is the pk on the identity? It could be that the identity seed is messed up.
Won't be due to master's problem. primary keys aren't kept in...
December 30, 2008 at 2:34 pm
branovuk (12/30/2008)
I am doing full backup, if I understand well, that means log file backup too?
No.
Full backup means just that. Full database backup. It does not back the log up,...
December 30, 2008 at 2:30 pm
homebrew01 (12/30/2008)
That was part of my original poorly worded question.... Why would SQL read 55 million rcds when there is an index that allows it to read only 422,000.
Because the...
December 30, 2008 at 2:16 pm
RBarryYoung (12/30/2008)
GilaMonster (12/30/2008)
DECLARE @SomeVar TABLE (id int)They appear in tempDB's system tables as something like #08EA5793
OMG, I cannot believe some of the stuff that you know Gail! How on...
December 30, 2008 at 2:11 pm
The_SQL_DBA (12/30/2008)
Gail: The last checkDB has some errors with indexes on the test database attachment 3(CheckDb after DatalossRepair.txt), what's up with that?
Repair is rather brute force. It just deallocates data...
December 30, 2008 at 2:11 pm
Warren Peace (12/30/2008)
I checked the db properties and the physical size of the tempdb.mdf.
Doesn't mean the tables are using 30GB. It just means that at some time the total...
December 30, 2008 at 1:58 pm
Warren Peace (12/30/2008)
"table variables"?
DECLARE @SomeVar TABLE (id int)
They appear in tempDB's system tables as something like #08EA5793
These tables are taking 30GB of space for the tempdb.mdf. Will SQL eventually delete...
December 30, 2008 at 1:43 pm
branovuk (12/30/2008)
I have one problem with production database. Transaction log is growing fast. I have daily backup. And it worked if I backup log file only, two times, than shrink...
December 30, 2008 at 1:39 pm
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
Viewing 15 posts - 42,076 through 42,090 (of 49,571 total)