Viewing 15 posts - 42,061 through 42,075 (of 49,562 total)
ananda.murugesan (12/30/2008)
can anybody suggestion me, is there any alternative way how do resolve the database suspect condition?
It completely depends on what caused the suspect condition in the first place. The...
December 31, 2008 at 12:30 am
roy.neelanjana (12/30/2008)
·I have worked on SSRS, and SSAS but not in SSIS. In the first test I have got 517. what is the passing percentage for this exam?
You should probably...
December 31, 2008 at 12:29 am
ta.bu.shi.da.yu (12/31/2008)
Surely this would be useful in certain situations? Anyone have any idea why they removed...
December 31, 2008 at 12:26 am
This is all-around some of the worst advice I've seen recently regarding transaction logs in quite a while.
Paresh Prajapati (12/30/2008)
December 31, 2008 at 12:23 am
MANU (12/30/2008)
In which table you find it eventually as I can't see any entries for temp variable in syscacheobjects.
You won't see them in syscacheobjects. That's for execution plans.
select name from...
December 31, 2008 at 12:05 am
DBCC CheckIdent should. I don't know if it's on SQL 7 though. You can use it to check what the current identity seed is, and change if necessary.
December 31, 2008 at 12:01 am
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
Viewing 15 posts - 42,061 through 42,075 (of 49,562 total)