A string of text. Each WHERE clause element can change with a different value for every query....

PHXHoward (5/19/2016)

---

We have a single select query with 32,663 single use plans in the plan cache. Apparently it is not reusing the plan ever. This is making a lot...

mortalic (5/18/2016)

---

If it looks like a duck.....

Since I posted this, I had the systems guy move them onto the same physical host and the TPM shot up to 75k.

It's for...

Patched up, so unless something is messed up with 2014 SP1 CU6 that build should be best.

41K seconds HADR_SYNC_COMMIT waits? Like I said - network bottleneck. That is the wait...

Read this if you are on older edition of SQL Server:

https://support.microsoft.com/en-us/kb/2723814

OK, that's a LOT more information to go on. In no particular order:

1) Observe how far behind the syncing gets during the async run. If it is way behind...

People chose async because they made a decision to allow losing data. Since you already made that decision before hand, there is no reason to now do a restore, right?

mortalic (5/17/2016)

---

This is a test environment for a future production environment.

I've got two Physical systems running 1 vmware guest each.

I'm using the HammerDB tpc-c tests for this.

My process is to...

People screwed up (in multiple ways). It is just a matter if finding the bottleneck and fixing it and repeating until performance it acceptable. There are quite a number of...

R.P.Rozema (5/13/2016)

---

and yet it is still lots better if you would get rid of the cursor. I know it is easy to stop now, but you should REALY do without...

aaron.reese (5/13/2016)

---

Another option would be to turn the query into dynamic SQL and append

'WHERE searchValue in (''' + @inParameterString +''')'

The @inParameterString is them passed in as "A", "B" or "A','B"

Which...

APA0876 (5/12/2016)

---

TheSQLGuru (5/12/2016)

---

PLEASE remember my initial statement about "qualified professional"!!! The company's very survivability is on the line here. And yes, I have seen companies...

PLEASE remember my initial statement about "qualified professional"!!! The company's very survivability is on the line here. And yes, I have seen companies go out...

I strongly disagree with the statements that having a DATA FILE on a RAM DISK with a table in it won't speed up work on that table. For reads, when...

Smendle (5/12/2016)

---

All of your answers you seek are available from Microsoft...

Taken from https://msdn.microsoft.com/en-us/library/ff877884.aspx

An availability group supports a failover environment for a discrete set of user databases, known as availability databases,...