Viewing 15 posts - 42,046 through 42,060 (of 49,552 total)
ananda.murugesan (12/31/2008)
Hi Gail,error log we can found that what exact problem for database suspet mode.
Sorry, I don't understand what you're saying
could you tell me, any other...
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 31, 2008 at 7:44 am
Paresh Prajapati (12/31/2008)
I have talk about oldest activate transactions which are remain to close or rollback/committ.
"Remain to close"?
Regardless of how long the transaction has been running, you don't...
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 31, 2008 at 7:41 am
What patches did you install? (kb numbers if possible)
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 31, 2008 at 12:46 am
venkatesh.kuppili (12/30/2008)
i dont know how secured "DecryptByPassphrase" is.. can you please help on this..
Have you read through the section on that function and encryption in general in books Online?
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 31, 2008 at 12:36 am
Be sure to rebuild all of your indexes afterwards. Shrink badly fragments indexes.
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 31, 2008 at 12:33 am
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...
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 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...
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 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...
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 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)
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 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...
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 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.
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 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/
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: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...
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: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,...
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: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...
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:16 pm
Viewing 15 posts - 42,046 through 42,060 (of 49,552 total)