I think this is usually a Listener type issue. But AlwaysOn is COMPLEX and there is no telling what is messed up on your system. Did you test failover before...

mdsantos (5/13/2015)

---

Hi thank you for the replies.

What I meant with dinamic query is that part of the SQL code is passed to the stored procedure as a parameters. EXample:

exec SP_SELECT_ROWS_K2_CLAIMS_WF...

mdsantos (5/13/2015)

---

Hi to all,

In my company we are dealing with a very strange problem in the last couple of week in a SQL 2012 server. And maybe you could give...

1) There are no shared files on AG - they exist on local storage on separate servers, at least to my knowledge (and unless you are combining a SQL Server...

1) What you have works fine. You can build it dynamically if you have the words in your app too (guarding against SQL Injection obviously).

2) You cannot do what you...

IIRC there was a recent bug fix for a dbcc checkdb snapshot error. Do a search for that and see if it applies to your issue.

You sound like you don't have experience here. I can tell you that there are MANY caveats, limitations, provisos and gotchas with Always On that will be VERY LIKELY to...

goldberg.yoni (5/7/2015)

---

Hi,

I'm tasked to develop a gaming web application system with relatively large database - it should hold the data about 300 million players, the orders/payment of each player -...

You can do a simple analysis of how many rows per hour to see if that metric makes sense.

My thoughts too. 86400 seconds in...

sql-lover (5/3/2015)

---

TheSQLGuru (5/1/2015)

---

sql-lover (5/1/2015)

---

TheSQLGuru (5/1/2015)

---

I didn't read deeply (TL;DR) :), but the first thing I would do is put the query into a sproc on the remote side and call...

sql-lover (5/1/2015)

---

TheSQLGuru (5/1/2015)

---

I didn't read deeply (TL;DR) :), but the first thing I would do is put the query into a sproc on the remote side and call that from...

I didn't read deeply (TL;DR) :), but the first thing I would do is put the query into a sproc on the remote side and call that from local box.

pseudocode

update currentlist

set active = 0

from currentlist cl

where not exists (select * from dailyload dl where cl.phonenumber = dl.phonenumber)

Charles Kincaid (4/30/2015)

---

Right after adding the indexes you saw no improvement. Not too surprising as the procedure was using the old execution plan that was cached when the procedure...