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.
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.
Windows 7 machines are unacceptably slow. - Microsoft Community
Dec 2, 2013 · I'm responsible for maintaining an assortment of Windows 7, 32 and 64 bit machines on a Domain with a Windows 2003 server (non-profit organization and there's no money for a server …
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) ?
How to Decipher sysschedules – SQLServerCentral
Jan 2, 2012 · Take the mystery out of sysschedules and interpret the data into a plain text format.
Extracting Logins From SQL Server – SQLServerCentral
Jan 7, 2010 · This script will help you transfer logins between one instance of SQL and another.
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 …
Microsoft Community
Microsoft Community
Covering Index vs Included Columns – SQLServerCentral Forums
May 30, 2008 · Covering Index vs Included Columns Forum – Learn more on SQLServerCentral