Viewing 15 posts - 6,991 through 7,005 (of 49,552 total)
If it worked previously, then you weren't trying to nest INSERT ... EXEC as they cannot be nested under any circumstances. You're going to have to figure out an alternative...
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 22, 2014 at 7:13 am
John Mitchell-245523 (12/20/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
December 22, 2014 at 6:45 am
You can invalidate the subscription and re-snapshot, but I don't think that's what you want.
Easiest thing here would probably to put a delay in the export process. Transactional replication inherently...
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 22, 2014 at 6:43 am
Why don't you focus on the problem rather than adding more complexity?
Your problem is slow recovery on restart. If you're not careful, adding HA could make things worse. Do some...
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 22, 2014 at 6:39 am
HanShi (12/22/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
December 22, 2014 at 6:30 am
Well, there you have it. INSERT .. EXEC cannot be nested.
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 22, 2014 at 6:26 am
simon.letts (12/22/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
December 22, 2014 at 4:52 am
Have you checked that the job is doing what it's supposed to do? If say someone changed it to just run CheckDB on master, then it will execute with success,...
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 22, 2014 at 4:51 am
Look at what conditions would cause the RAISERROR line to be executed.
Open up the proc, go to line 724 and work out, from the code, what it does and what...
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 22, 2014 at 2:37 am
No.
If any developer came to me with tables with a generic 'RecordID', they'd be changing their design. Unless the table was the Records table.
You need a primary key. It is...
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 22, 2014 at 1:28 am
If that login is the owner of a database, you won't be able to remove it. First change the owner of the database to another login, then try again.
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 22, 2014 at 1:25 am
Just wow.
I'm sure said engineer can point at the kb articles and/or connect items detailing said bug? Didn't think so.
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 19, 2014 at 8:42 am
jasona.work (12/19/2014)
(I think some of the L2 and L1 cache, various other bits and bobs)
Each core has it's own L1, at least with the Intel processors. L2 is 'shared' (kinda,...
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 19, 2014 at 6:28 am
No, a core is a measure of cores. The number of processing cores on a single physical processor.
My desktop at home has an Intel i7 quad-core processor. If I 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
December 19, 2014 at 5:28 am
Per processor is the old SQL 2008 and before licensing. Two physical processors - two processor licenses. Done.
Per core is SQL 2012 and later licensing. Two quad core processors -...
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 19, 2014 at 4:48 am
Viewing 15 posts - 6,991 through 7,005 (of 49,552 total)