How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
2,618 reads
Tips and tricks
SQL Server Performance Tuning with Hypothetical Indexes
Daniel Farina demonstrates how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command.
2014-06-13
3,858 reads
Blogs
Daily Coping 10 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
T-SQL Tuesday 153: The conference that changed everything
This month’s T-SQL Tuesday is hosted by my dear friend Kevin Kline (b | t) . Kevin’s call...
T-SQL Tuesday #153: The Thing That Changed Everything for Me – SQLFamily
Kevin Kline (b | t) is hosting T-SQL Tuesday this month and it is to “Tell...
Forums
CASE statement with multiple conditions (trimming & detecting spaces in between)
Hello everyone, I am trying to create CASE statement that will do three different...
Retrieve username for report?
We have a "report" that executes a stored procedure to perform updates. For these...
Transactional Replication to Azure getting "too many arguments" error on MSins
I'm running a 2019 (15.0.4102.2) Server with Transactional Replication out to a SQL Azure...
Ask SSC