Sorry - not sure how to help with this one, at least not via a forum thread. 🙁

Did you make the secondary readable? If so, redo the AG without that and see if it makes a diff.

Do you have static IPs or DHCP?

It is almost always better to use a temp table or dynamic sql for this than to try to do something else. Both of those will/should get you the...

Lots of possible issues here:

1) The SORT isn't because of UNION. You are doing a UNION ALL, which does NOT do the SORT/DISTINCT that a UNION alone does. ...

kst 61502 (9/23/2014)

---

I have a server with 8 SSD Intel DC3500 in 2 arrays and 2 * Intel Xeon CPU E5-2620 0 @ 2.00GHz, 192 GN RAM, Windows 2012...

I'm not sure why you think Captcha or similar won't help/stop the attacks. Unless someone has come up with a way for the images to be properly recognized, that...

1) are the plans the same? even with 2012 I believe the optimizer and engine have limitations about index usage and good plan formulation.

2) have you tried pre-computing the areas...

Maybe someone changed the version level of the database? I think newer version(s) of SQL Server may require the WITH keyword??

TBIG (9/9/2014)

---

As you can see, this is a quick fix, stop gap bit of script. It's just something to patch us through until we do it right.

I've got a little...

Never, ever, EVER use the SSMS GUI to do DDL activities!!! It is FULL of issues/bugs. You could possibly use it to do what you think is right...

HowardW (9/3/2014)

---

Luis Cazares (9/3/2014)

---

If your function is a UDF, then it's bad (I'm not sure if deterministic UDFs will be bad as well). I've seen large improvements when changing UDFs...

Scalar (and multi-statement table valued) user defined functions can be DEVASTATINGLY BAD!!! There are multiple ways they can screw you. A short list includes:

1) prevent optimizer from getting/using...

river1 (9/2/2014)

---

Hi,

I have four databases one with 7 gbs and other 3 with 3 gbs each.

Can I use Express Edition ?

I read that the limit is about 10 GBs but...

If you Binoogle Itzik Ben-Gan gaps and islands TSQL all of the top hits are relevant to your need.

Pablo Campanini-336244 (8/28/2014)

---

Jim, thank you for your reply, the step by step link is a great help.

But, at this point lets not talk about Availability Groups, just one server in...