SQL Server 2012: Time Marches On
Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.
2013-02-13
3,844 reads
Date Manipulation
2012-11-27
2,188 reads
SQL Server Function to return a range of dates
A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.
2012-11-02
4,979 reads
2012-01-30 (first published: 2011-12-23)
884 reads
2012-01-20 (first published: 2011-12-16)
1,022 reads
2011-06-22 (first published: 2011-06-14)
1,894 reads
Find Last Day of the Month
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
2011-05-10 (first published: 2011-04-29)
2,426 reads
2011-04-27 (first published: 2011-04-21)
2,745 reads
2010-11-26 (first published: 2010-11-04)
585 reads
A Flexible Day Of Week Function
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,401 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers