Viewing 15 posts - 8,671 through 8,685 (of 49,552 total)
It's possible, it's not recommended. The witness is there to cast the deciding vote as to whether the principal is down or not, it's not going to be of much...
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
June 19, 2014 at 4:11 am
crazy_new (6/19/2014)
SET @CaseID = (
SELECT
bl.CASE_ID
FROM
Patricia.dbo.BUDGET_LINE bl
JOIN cat_transaction ct 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
June 19, 2014 at 3:43 am
The code you've posted can't throw that error, a SELECT MAX().. with no group by can't return multiple rows.
Are you sure that subquery is the cause, not an other subquery...
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
June 19, 2014 at 3:05 am
The problem, however, is that statistics IO lies any time there are scalar UDFs in use. The profiler trace doesn'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
June 19, 2014 at 2:54 am
I'm pretty sure I've linked these before:
Is this the 2005 server?
If it's critically important and must be done now, the best thing you can probably do is get someone 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
June 19, 2014 at 2:46 am
Offhand no, but I'm sure google will have several.
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
June 18, 2014 at 2:46 pm
Don't.
It's got a nasty corruption-causing regression bug in it. Wait for the next CU or post SP 2 hotfix, then apply it and the CU
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
June 18, 2014 at 2:31 pm
Koen Verbeeck (6/18/2014)
Sean Lange (6/18/2014)
Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of...
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
June 18, 2014 at 2:27 pm
Sean Lange (6/18/2014)
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
June 18, 2014 at 2:23 pm
Hema kumar-337490 (6/18/2014)
5.In case if any database rollback process takes forever.
Because it's better to have the rollback take forever with the DB unavailable than for the rollback to run while...
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
June 18, 2014 at 11:28 am
The trigger assumes there's only every 1 row in inserted. If you update multiple rows that will not be the case.
You need to change the trigger to handle any number...
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
June 18, 2014 at 10:06 am
You don't want to reboot it for no reason though. Sure, reboot for OS patches or stuff like that, but rebooting just for the sake of rebooting, no.
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
June 18, 2014 at 9:51 am
Reading material before you make this change.
1) http://www.sqlservercentral.com/articles/Administration/75461/
2) http://www.sqlservercentral.com/articles/Administration/64582/
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
June 18, 2014 at 9:48 am
Create a temp table, insert the results of the DBCC into there (use EXEC (DBCC...) ), then select from 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
June 18, 2014 at 7:54 am
jasona.work (6/18/2014)
Koen Verbeeck (6/18/2014)
jasona.work (6/18/2014)
Figured it was a glitch on our network here...It was a glitch in the matrix, Neo.
That explains the deja-vu when I saw the same person walk...
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
June 18, 2014 at 6:59 am
Viewing 15 posts - 8,671 through 8,685 (of 49,552 total)