I am with Gail. Page files on SQL Servers should NEVER be used when things are set up correctly, and I advise my clients to make them just big enough...

This should be sent off to Itzik Ben-Gan as a puzzler to work out for an article on SQLMag.

I think you have a great plan, with a few conditions:

1) Are the rows in the original table just ADDED or are there also UPDATES and DELETES? If just the...

I don't think we can help you without create table scripts, representative data inserts and your actual and expected results from the statement execution.

1) Asking for all columns from every table.

2) We need additional info to really help. Table create scripts (with indexes), row counts, query plan.

3) Leading percent on the like....

PJ_SQL (7/29/2015)

---

What is the purpose of creating table variable and inserting data into it and selecting from table variable inside of stored proc?

Why can't the stored proc just have select...

Imran-Yasir (7/29/2015)

---

Hi,

Can anybody please tell me that how many databases are recomended to add in one AG in SQL Server 2012 AlwaysON to get better...

I am on the last day of a cruise vacation and pretty much brain-dead, but I think this does the trick, although I am not certain you want to use...

You provided the code change already....

Junglee_George (7/28/2015)

---

I have these SQL statements inside a WHILE loop :

SET @StartDate1 = (SELECT MIN(A.startdate) FROM #Activities2 AS A WHERE activityIncId = @ActId )

SET @EndDate1 = (SELECT MAX(A.enddate) FROM...

This should be able to be done with WINDOWING functions since you are on SQL 2012. I bet I could also do it very quickly and efficiently using DATEADD and...

1) You have what are almost certainly views in that query, so G-d only knows what the decompiled query looks like. I have seen queries like that net out to...

http://michaeljswart.com/2011/09/mythbusting-concurrent-updateinsert-solutions/

http://michaeljswart.com/2011/09/mythbusting-concurrent-updateinsert-solutions/

rmechaber (7/17/2015)

---

Another perspective: do you actually need to store the subtotal in the OrderHeader table?

This could be computed on-the-fly using views or stored procedures from the actual order details, right?...