Viewing 15 posts - 42,061 through 42,075 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 30, 2008 at 6:42 am
mathewspsimon (12/30/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 30, 2008 at 5:30 am
Viewing 15 posts - 42,061 through 42,075 (of 49,552 total)