A Procedure gather Server Statistic per day or per run this Procedure.Output: Table TBL_SERVERSTATISTICS. You can use the results to analyze SQL-Server performance problems. You can analyze what changed after install new hardware or software, add or remove Application/DB/File/Index/Table etc.Recommendations: Run a Procedure once every day.Warning: If sql-server restarted after last run a Procedurecurrent running […]
2003-03-13
1,046 reads
A procedure send message to all active SQL Server users(SQL Server Connections) on your Server.I use Win command NET SEND.
2003-02-25
524 reads
A Procedure send Alert by E-Mail about allfiles with option "Restrict File Growth" ifavailable space less then 10%.
2003-02-24
312 reads
When log_file bigger then data_file you will getReport by E-Mail.For ALL DB.
2003-02-20
164 reads
A Procedure build Report about NEW and Deleted DB.First time you must to run p_build_check_db.This procedure build table master..t_databases same asmaster..sysdatabases .Procedure p_check_db compare t_databases and sysdatabases and send a report to your@E-MailAddress.Best regards. Vadim.
2003-02-20
163 reads
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
I recently took and passed the DP-700 exam, which is required for the Microsoft...
As a Consultant, I would typically answer with – it depends! Then a typical...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item How to Download and Restore...
Comments posted to this topic are about the item Tracking Table Sizes
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers