Why not both?

Stuff like this has to go:

INNER JOIN app.fund F

ON CAST(l.lipperid AS varchar(50))= CAST(f.AccountGr AS varchar(50))

You're going to have to work through this in really small pieces. There's no magic bullet...

I agree. Neither of those are on the deprecation list.

jasona.work (8/5/2015)

---

GilaMonster (8/5/2015)

---

jasona.work (8/5/2015)

---

GilaMonster (8/5/2015)

---

Snippets and a whole pile of script files saved in DropBox and on a creditcard-shaped flash drive (which I need to update).

And to get back on...

JaybeeSQL (8/5/2015)

---

Distributed Relay isn't available on 2k8 I'm advocating a move to 2012 or possibly 2014, but I want to capacity-plan this BEFORE we spend our budgets (which are...

Deprecated means it's going to be removed from a future version of the product. It's still there. But, if you build anything based on it, don't be surprised when you...

Well, Luis is right. It won't run and therefore will return zero rows. But that question is an extremely poor demonstration of SQL Server knowledge. However, the provided answers were...

Yeah, what Gail said.

It's not that we don't know the answer. It's that the question, as you have it phrased, can't be answered. There's no way to know how many...

If there isn't a service running, SSMS isn't going to be able to connect to anything. Further, at least from what you're showing, you don't have a SQL Server instance...

Based on this information, we can't answer it either. The question seems pretty suspect to me. I'd suggest following up with whoever provided it and see what they thought the...

You'll need to go to backups of those databases, and backups taken when they were still 2012. You can't simply downgrade the database. When you did the upgrade, they were...

Koen Verbeeck (8/5/2015)

---

I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the end of the...

I'd guess it's something on the code side of things. How it's connecting or how the call is being made. There's nothing on the SQL Server side that would limit...

Also, you know that a TOP without an ORDER BY is not guaranteed to get the same results each time, right?

If you can, I'd suggest capturing the current system behavior and then using Distributed Replay to simulate your load. It'll take some work, but you should be able to at...