Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
495 reads
DateFirst
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
7,216 reads
Blogs
Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2
By MUTHUKKUMARAN KALIYAMOORTHY
How to read execution plan to improve poorly... [[ This is a content summary only....
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Forums
Azure Stretch Database, Part I: Getting Going
Comments posted to this topic are about the item Azure Stretch Database, Part I:...
Minimalistic SELECT
Comments posted to this topic are about the item Minimalistic SELECT
business intelligence development studio(Bids)
Hello, I have a SQL 2017 and I want to use business intelligence development...
Ask SSC