Pretty common scenario actually, and some very nasty things can happen as a result of SET differences (much worse than recompilations). Check the settings the sprocs were compiled under...

Here you will find a session I did on SQL Server 2012 Windowing Functions. Should get you what you need. There are two other great sessions from me...

In my experience the majority of the queries that need to be tuned are ones that run against active data, not against stuff that must first be pulled up from...

OP: Please don't take this the wrong way, but given some of the statements and questions in your post I fear that you would not be able to either a)...

1) I...

GilaMonster (5/7/2014)

---

I'm not willing to...

GilaMonster (5/7/2014)

---

Corruption is 99.99% IO subsystem problem. Not necessarily the disks, could be anything anywhere in the IO stack.

Since you mentioned an uncontrolled shutdown, I'd check and make sure all...

Try here and associated links from this page: http://msdn.microsoft.com/en-us/library/hh710053.aspx

Also, SQL Server 2012 Books Online is your friend!!

Some of the worst performance messes I have ever had to untangle at clients were due to the use of DTA by unqualified individuals. 2 clients made their systems...

Seems quite silly (and unscalable) to me to read all the data just to read all the data iteratively. 🙂

PHXHoward (5/2/2014)

---

Hi everyone, I'm seeing some really high average write stalls. As I have read, anything greater than 20ms is considered bad. With numbers like ~6400ms on writes and ~150ms...

Lutz is correct, as usual. You cannot command SQL Server to "keep this table in memory all the time" like you want. However, it WILL stay in memory...

isuckatsql (5/1/2014)

---

select top 15 count(*) as cnt, state from table

group by state

order by cnt desc

select top 15 count(*) as cnt, city from table

group by city

order by cnt desc

select top...

Since you have given us no table schemas, indexing, query plans, sample data, examples how the 2 queries differ in their output I can only say that when faced with...

I think you can support multiple VMs without having a "killer laptop", especially if you have an SSD attached (or even a fast USB3 flash drive, like my Patriot 128GB...