Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and ...
Jul 3, 2024 · Learn how to work with dates and calculate particular dates or elapsed time periods with some of the functions available in SQL Server.
Microsoft Community
Microsoft Community
How to Decipher sysschedules – SQLServerCentral
Jan 2, 2012 · Take the mystery out of sysschedules and interpret the data into a plain text format.
SQL Server Management Studio 18.0 is available now.
Apr 29, 2019 · SSMS 18.0 is available for download now.Microsoft has released the new version of SSMS, the free client tool from Microsoft to manage to the SQL Server infrastructure from SQL...
8 Ways to Export SQL Results To a Text File - SQLServerCentral
Jul 18, 2011 · This tip will show eight ways to export the results of a query to a text file.
TABLOCKX vs TABLOCK + XLOCK – SQLServerCentral Forums
Dec 14, 2017 · Thank you Evgeny, but does it mean that applying WITH (TABLOCKX) is exactly the same as WITH (TABLOCK, XLOCK) ?
Check health and status of Availability Group using DMVs
Feb 13, 2009 · -- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members -- …
SQL Server 2008 R2 feature pack – SQLServerCentral
Feb 13, 2009 · Microsoft, has published things that can be very useful, in this case for the SQL Server users. They announced the feature pack for SQL Server 2008 R2, where you can find a lot of stuff …
Replication Error – SQLServerCentral Forums
Mar 5, 2014 · Replication Error Forum – Learn more on SQLServerCentral
Extracting Logins From SQL Server – SQLServerCentral
Jan 7, 2010 · This script will help you transfer logins between one instance of SQL and another.