The current SELECT statement currently...

sudhakara (7/28/2016)

---

Thank you.

Intent exclusive lock is placed on higher level (page, object) if exclusive lock (X) is placed on lower level of object (rid,key,page). But In my case i do...

jmlc1 (7/28/2016)

---

Thanks for the response. Say I have application A. I have chosen SQL Server (2012) as the DB backend, and I will write all my stored procs etc., in...

A web search for sql server intent lock gets this as the top result. It is very clear and helpful:

https://technet.microsoft.com/en-us/library/ms175519(v=sql.105).aspx

JayK (7/27/2016)

---

Hi,

We have a Dimension table in our SQL Server 2012 Datawarehouse that has over 6.5 billion records and sits currently at 1.5TB with 800GB of data and 700GB of...

Can you provide some more descriptive examples of what you are looking for? I am at a loss given your initial posting.

I am not sure I understand the problem. Did you check the schedules of the various jobs? That has been the thing that most of my clients don't understand.

If...

Stop using maintenance plans. Get Ola.Hallengren.com's free and amazing maintenance suite.

AlanB, can you please elaborate why you suggest an identity column on this table? That is what almost all of my clients do on, well, every single table and many...

sqld-_-ba (7/26/2016)

---

1. should have mentioned, we use Enterpise (have SA with M$)

2. oltp box, see cxpacket waits, maxdop was 2 before, wasn't giving up much performance gains anyways, so changed...

sqld-_-ba (7/26/2016)

---

SQL 2012 SP1 (11.0.5343), VM + SAN , 16 CPU cores, 96GB RAM, 16 tempdb files 2GB equally sized, TF 1118 set, MAXDOP 1, size of databases ~100GB

There is...

http://sqlperformance.com/2012/07/t-sql-queries/running-totals

http://sqlperformance.com/2014/01/t-sql-queries/grouped-running-totals

Note that Aaron does NOT do the Quirky Update correctly in his stuff. But with 2012 Windowing Functions are the way to go in any case, at least when done...

There is absolutely zero chance of us helping you size an application "for 300 users". There are a bajillion missing pieces of information, chief among them how many active concurrent...

1) Parameter sniffing happens by design for parameterized queries of various types as well as for stored procedures. It is often a very beneficial thing, sometimes a disastrously unfortuante thing.

2)...

Hopefully their new app won't do dumb things. 🙂