How much storage do you have available? If you do a backup, restore, and delete, unless you shrink the database, the DB in the test environment will still be 500...

Great thanks.

Unfortunately, the issue I run into is a request to provide numbers for performance enhancement. i.e. "If you do this, how much faster will our system be?" That's very...

Grant Fritchey (2/25/2014)

---

Yeah, but it'll hit CPU and memory, not IO.

The question is, are all the queries the same, but varying by some parameter value? If so, then optimize for...

Doesn't the execution of thousands of ad-hoc queries bloat the procedure cache? I though that would cause some performance degradation.

Thanks to both of you. I'm going to start testing log shipping.

george sibbald (1/6/2014)

---

Some white papers comparing the various HA techniques

http://msdn.microsoft.com/en-us/library/ms190202(v=sql.100).aspx

http://technet.microsoft.com/library/Cc917680

Do you have standard or enterprise edition? To make the secondary databases readable with mirroring you need enterprise edition so you...

Thank you both for the responses.

My concern has to do with contact backups on the primary database, transmissions...

Unfortunately, it's none of those issues. However, I did notice something new.

I removed the stored procedure from my original large procedure as it's not necessarily needed, but it does fix...

I was able to grab the specific code that's causing the problem, here you go,

USE [ARCHIVE]

GO

/****** Object: StoredProcedure [dbo].[SP_Archive_Cleanup] Script Date: 09/20/2013 22:54:57 ******/

SET ANSI_NULLS ON

GO

SET...

Sean Lange (8/7/2013)

---

JoshDBGuy (8/7/2013)

---

Within the loop there are multiple transaction statements. Because these are all very dependent on one another i'd like the loop to stop completely and not insert...

Can you send me your results for the initial cast? Inserted...

Within the loop there are multiple transaction statements. Because these are all very dependent on one another i'd like the loop to stop completely and not insert or delete any...

Sean Lange (8/7/2013)

---

JoshDBGuy (8/7/2013)

---

Hello All,

I have a question behind the logic of Try and Catch. I'm using Try Catch in a complex statement with a While Loop. If I put...

Remove the @ from @AccountNumber

Do you care how you extract the account number? If you just need the account number you could simply use a substring.