Bottom line:

1. Be consistent in aliasing, and develop a style/standards guide.

2. Not exists is very useful in:

A. Proving the "many" side...

....and I thought my wife asked the toughest questions. My brain came to a screeching halt on this one :w00t:

I think the bottom line is that SQL Optimizer will return rows in the best order it sees fit based on execution plan. There are definitely cases, especially with...

+1. I also try to add these spackles to my SSMS templates.....

If your output requirements are driven by business intelligence or analytic needs, you can always use a lookup table (date dimension) as well. If you are interested, let me...

So not my area of expertise. Can't believe I got it right.

Agree. PowerView is a DAX client. DAX is a query language for business/power users coming from an Excel background. There is also a DAX to SQL translator...

Great question. It reinforces some concepts I forgot 🙂

Being a business intelligence guy, I try to avoid indexed views unless the client is so large, I have no choice...

http://www.jamesserra.com/archive/2013/03/visual-studio-2012-now-supports-bi/

If I am not mistaken, using one execute package task (EPT) within a loop would execute the packages serially, right? Parallel EPT execution would require multiple EPTs that were...

https://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=15

What is the final verdict? How did you eventually meet the customer requirement? Custom security table.....security trigger.....etc?

Can SQL_Enthusiast's issue be solved with a WMI task or data reader? I have not used it in ages, nor am I a WQL expert 🙁

Although not the ideal tool, one can also view the results of a cube in SSMS. Back in the 2005 day it was very convenient for someone wearing a...

Not sure if this helps, but I have this in my toolbox for the datetime portion--something similar I had to do a few years back. In my database the...