I think I may have missed the server's actual physical RAM, but if it is 64GB then 60GB for max memory for SQL Server is definitely too high.

The worst...

See Books Online for information on creating an INSERT trigger. I strongly recommend you do NOT use a Scalar UDF to calculate whatever you need. Try your best to do...

SQL_Surfer (4/24/2016)

---

Anyway, why my non-column store index is not performing well as it should? I'm querying a 5 million row table. I've attached a query plan. Any tips to speed...

Lynn Pettis (4/22/2016)

---

TheSQLGuru (4/22/2016)

---

Great thinking for autoclose being a cause of the repeated long initial run times! Actually it is hard to think of a situation where autoclose should be...

Great thinking for autoclose being a cause of the repeated long initial run times! Actually it is hard to think of a situation where autoclose should be turned on for...

My initial statement when I read the heading was the typical "it is the time it takes your IO system to load the data into memory, then it is fast...

MadAdmin (4/22/2016)

---

Check to see if the indexes are being used, or if they are duplicated, or if you can create better indexes, i.e. consolidate.

It would be horrible to rebuild 800GB...

THIS!! -->>

Chris-475469 (4/21/2016)

---

I've already isolated a few of the UPDATE statements that are performing badly and made some changes which has had an impact. I think I'm going to have...

1) Have you done a file IO stall analysis or wait stats analysis while the code is running to see why it is slow? sp_whoisactive has a differential parameter

2) You...

kiran.patel07 (4/21/2016)

---

Thanks a lot Kevin for you suggestion.

Hardware perspective, we can't do anything. we have New hardware and SQL 2014 for other products but this one is old.

Moreover, some...

As someone pointed out, LAG/LEAD are not available on 2008. So you need to use ROW_NUMBER() OVER () to get a sequence based on some valid ordering that ensures you...

kiran.patel07 (4/21/2016)

---

Hello,

I need to rebuild Index on below Huge tables for our two databases

1. 1.4 TB table ( Replication is setup on that database)(8 non-clustered indexes, biggest index size is...

nari.koud (4/20/2016)

---

Hey Kevin,

Last server restart is 2016-01-04 23:32:30.253

I have no ability to Edit any code, ( i wish i was using Sp's)

I Tried creating dropping modifying indexes - no...

nari.koud (4/20/2016)

---

Hey Kevin..Thanks for the tips.

A. we have a plan to add more memory soon

C. I said properly indexed only because , i made sure -No duplicate, No unused, no...

nari.koud (4/20/2016)

---

Hi, I am looking for some help on solving deadlock issues. Please see below scenario..

There are frequent SELECT, UPDATE, BULK INSERTS happening in DatabaseA- Tables and Heavy blocking is...