The Date for Monday and Friday of the current week can be determined as illustrated below.
SELECT GETDATE() + (2 – DATEPART(WEEKDAY, GETDATE())) AS MONDAY,
The Date for Monday and Friday of the current week can be determined as illustrated below.
SELECT GETDATE() + (2 – DATEPART(WEEKDAY, GETDATE())) AS MONDAY,
After a long wait the final build of SQL Server 2005 was released to manufacture (RTM) last Friday (28th October 2005).
Everytime a SQL Server Backup (or restore) is performed SQL Server writes a message both to the SQL Server Errorlog and the Windows Eventlog.
The installation path for SQL Server 2000 can be determined using the undocumented sp_msget_setup_paths Stored Procedure.
Below is an example of how to use a Trigger to audit who updated, deleted or inserted data. The trigger also captures the old and new values when an update is performed:
The September edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The SQL Script below can be used to remove non-printable characters from a string such as CRLF etc.
The SQL Server 2005 September CTP has been released and is available for download from BetaPlace and MSDN.
In order to determine the datetime that the statistics of an index where last updated the STATS_DATE function can be used.
If you are using or looking to use SQL Server Analysis Services to measure Key Perfromance Indicators then Microsoft Business Score Card Manager may be worth a look.