Viewing 15 posts - 7,396 through 7,410 (of 49,552 total)
I'd recommend you set up some VMs (VMWare Player is free for non-commercial usage iirc), set up clustering, set up Availability Groups, set up Mirroring (one at a time) and...
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 28, 2014 at 2:31 am
Sean Lange (10/27/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
October 27, 2014 at 8:17 am
Statements and execution plans?
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 27, 2014 at 6:51 am
And prod needs to be read-write and to accept schema and data changes? If so, those data changes need to sync back to dev?
Mirroring wouldn't have worked anyway, the mirror...
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 27, 2014 at 6:50 am
Edit: ...
You're moving the prod database somewhere else and want something to automatically redirect requests made to dev to go to prod instead?
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 27, 2014 at 5:52 am
http://www.sqlservercentral.com/articles/Indexing/68636/
That should answer most of your questions.
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 27, 2014 at 4:49 am
Create two temp tables. Insert the results of SP1 into one of them, insert the results of SP2 into the second, then write a query that joins them on whatever...
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 27, 2014 at 4:45 am
Never tried SQL Server with the Windows Live logins, I configured my win 8 box to use a local machine login instead.
Can you find the latest errorlog file and look...
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 27, 2014 at 4:34 am
Look at the last 5 lines of what you posted. You're calling the procedure itself there. There's no check for how many times it calls itself (nor any obvious 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 27, 2014 at 4:02 am
Is the service running?
What error do you get?
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 27, 2014 at 4:00 am
Without seeing the procedure, hard to say anything specific. You're getting the error because the procedure is calling itself (recursive). SQL limits recursive calls to 32 levels deep.
Take a look...
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 27, 2014 at 3:31 am
Section 2: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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 27, 2014 at 2:56 am
Find the latest SQL error log. Post it here (all of it)
Ref: https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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 27, 2014 at 2:44 am
CASE WHEN office_id ('1126','1127','1128','9999') THEN 'Yes' ELSE 'No END as ID_Exists
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 27, 2014 at 2:41 am
Shouldn't be related to CheckDB, it makes no changes to the DB and you're not backing up the snapshot, you're backing up the source DB
Did you have long-running uncommitted transactions...
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 27, 2014 at 2:40 am
Viewing 15 posts - 7,396 through 7,410 (of 49,552 total)