Please help us help you by providing create table statements and insert statements to set up your sample data. Then we can write a query based of those things and...

Eirikur Eiriksson (5/28/2016)

---

Very nice!

😎

The addition...

There is a good bit to a SQL Agent job's execution from a security standpoint, especially a backup one, which needs access to external resources such as a directory to...

Look up Index View in Books Online.

Alan.B (5/27/2016)

---

TheSQLGuru (5/27/2016)

---

I will jump through hoops to trade CPU ticks to avoid disastrously bad plans (and the...

David.Poole (5/27/2016)

---

Some time ago I saw an article where the author had noticed a problem with a query where the principle condition was WHERE OrderDate BETWEEN @StartDate AND @EndDate.

The problem...

I will jump through hoops to trade CPU ticks to avoid disastrously bad plans (and the horrible IO...

I don't have time to wade through all that code right now, but are you actually using the OFFSET clause?? Look it up in Books Online if not.

SIGN is one of the things used in the '60s to develop characteristic functions (the precursor to the modern CASE statement), which allowed incredibly powerful data processing in a single...

beaudamore (5/27/2016)

---

So, thanks to Michael L John and TheSQLGuru for actual helpful pertinent information that followed my question.

I have followed your pattern somewhat and gone with CTEs to gather the...

This could be quite a bit more efficient. That COUNT gets especially expensive as the number of matching rows goes up.

SELECT *,

CASE...

Thanks for the setup stuff. But in the future please make sure it works. 😀

Note I don't think this code will work correctly if a driver has more than 2...

A) If the report queries are finishing so quickly then NOTHING you do to "make them go faster" will help, right? That 7 minutes OUTSIDE SQL Server has to be...

Brandie Tarvin (5/26/2016)

---

I need a little help to be pointed in the correct direction. We have a report that has been doing poorly since our upgrade from SQL 2008 to...

I MUCH prefer to do my dynamic SQL this way. Now I don't have to worry about if it is 1, 2, 3, N stupid single quotes to make the...