SQL Server Rounding Tips and Tricks
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
15,897 reads
Luis Cazares
Using Code Snippets in SSMS
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
2018-08-17 (first published: 2016-04-07)
7,594 reads
Wildcard Searches
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
16,711 reads
Introducing the Set-based Loop
Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.
2016-10-07 (first published: 2015-07-27)
21,724 reads
2015-11-18 (first published: 2015-10-29)
759 reads
Calculating Working Hours
Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.
2015-10-22 (first published: 2014-05-22)
3,623 reads
Blogs
Altering a Computed Column in a Temporal Table in Azure SQL
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...
Basic OFFSET–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Calgary Data User Group with Deborah Melkin and Andy Yun
Next week on Wednesday is the Calgary Data User Group’s second event for 2021,...
Forums
SQL2016 to Access2016 Linked server issue
Hi all We've got an issue with a linked server to an Access...
Future of SQL Server
I am becoming a little disconcerted by the lack of news about the next...
Changing Data Drive Allocation Unit Size on Existing Installation
I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup...
Ask SSC