Viewing 15 posts - 29,806 through 29,820 (of 49,552 total)
Automatic failover requires three instances. With only two you can only have manual failover.
The witness doesn't need to be a server. A cheap desktop PC is more than adequate. There's...
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
October 21, 2010 at 4:37 am
Reformatted to make that readable
DECLARE CURSOR_UPDATE_LIVE CURSOR
FOR
SELECT ACTUAL_LINE_ID, TEMP_LINE_ID, ATTRIBUTE1, ATTRIBUTE2,
CONVERT(VARCHAR(11), LTRIM(RTRIM(ATTRIBUTE3)), 106),
CONVERT(VARCHAR(11), LTRIM(RTRIM(ATTRIBUTE4)), 106), ATTRIBUTE5,
...
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
October 21, 2010 at 4:36 am
Not if you let SQL manage the identity column. You may get gaps (due to rollbacks), but not duplicates.
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
October 21, 2010 at 4:33 am
Can you clarify your question please?
Have you looked at the entry for SET TRANSACTION ISOLATION LEVEL in SQL 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
October 21, 2010 at 4:03 am
It can, depending which mode you run it 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
October 21, 2010 at 3:05 am
sys.server_principals and sys.database_principals. The joining column is SID.
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
October 21, 2010 at 2:31 am
User mapping? Can you be a bit more specific?
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
October 21, 2010 at 2:25 am
Database mirroring is what you want. Have a read through Books Online, there's a lot of info in there on Mirroring.
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
October 21, 2010 at 2:19 am
I'd also suggest that you do a detailed examination of your IO subsystem, check firmware versions, check and and all logs, look for anything out of place.
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
October 20, 2010 at 11:51 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1008107-145-1.aspx
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
October 20, 2010 at 11:44 pm
I had a chat with an expert on this. It's not good news.
If checkDB with repair allow data loss is not repairing these errors, it means that for some reason...
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
October 20, 2010 at 11:43 pm
More than half of the required exams for the MCDBA (which is a SQL 2000 cert) have been discontinued. You cannot get that cert any longer.
If you're after a 2005...
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
October 20, 2010 at 11:36 pm
Stats IO lies. The original udf would not have appeared at all in the IO stats. That may well explain why the difference looks so pronounced in terms of IO.
http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
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
October 20, 2010 at 11:29 pm
For the second one, check out the thread over at SQLTeam with the same question.
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
October 20, 2010 at 2:30 pm
Restore the databases alongside each other and use something like Redgate's SQLDataCompare.
The tran log won't tell you anything of use here. You restored over the DB that the changes...
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
October 20, 2010 at 2:11 pm
Viewing 15 posts - 29,806 through 29,820 (of 49,552 total)