Alan.B: You have escaped the primary performance problem of chewing through unnecessary rows of each month on the date dim table with the filtered index. Well done. That was a...

APA0876 (5/11/2016)

---

Hi ,

We currently have a SQL Server Failover Cluster and they want implement Always On availability group. But getting rid of the SQL Server Failover Cluster. I'm aware that...

Drew.Allen: if you want to better test server performance on a given query that does lots of rows SELECT, just put the column(s) into variable(s). Voila - no more timing...

Bill Talada (5/11/2016)

---

Sure, the TOP clause accepts a parameter, just in case someone wants to make this a table valued function for returning 3, 12, or 300 dates. BTW, I...

There is no join criteria there

you need 3 queries as I mentioned

you need to handle nulls if either field you are comparing is nullable

Alan.B: a calendar table is a poor match here, and would perform significantly worse as well. What if it didn't have the proper date range available? What if it DID...

Standard queries will suffice here. Join the two columns on key field and add a where a <> a or b <> b or c <> c. Do make sure...

Eric M Russell (5/11/2016)

---

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it doesn't require a pre-existing...

Was this slowness repeatable and consistent? Was the database under load and/or did you NOLOCK your SELECT?

The most efficient methods I know of require a sequence from 1-12. You can call it dog if you...

etl2016 (5/11/2016)

---

thanks.

Sorry, missed one bit. I am willing to go for dual-monitor (27inch, 23 inch). From this context as well, do I or do I NOT need Graphics card...

Save your money. You don't need a spiffy graphics card. It will be fine to give up a bit for your mother-board-integrated video. What WILL matter is IO performance, so...

look up itzik ben-gan gaps and islands tsql and you should find some amazing solutions to this problem. You need to get the contiguous range of dates for each grouping...

This sure would be more efficient to do from the application (or a stored procedure) ...

onlo (5/10/2016)

---

Hello,

Unfortunately, we only use SQL Server 2014 Standard Edition, we can't use the memory optimized table feature.

Can I move just one table (it is a staging table) to a...