vadimmu@gmail.com


Technical Article

Statistic of SQL-Server - Daily Version

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 […]

You rated this post out of 5. Change rating

2003-03-13

1,047 reads

Technical Article

NEW and DELETED Database REPORT

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.  

You rated this post out of 5. Change rating

2003-02-20

163 reads

Blogs

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Advice I Like: Focus on what’s important

By

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...

India-US Tariff War: Is the Indian IT Sector at Risk?

By

How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...

Read the latest Blogs

Forums

OpenQuery with Application Intent specified runs on primary node.

By kailash.kanaya

I have an Open query that runs on an Always On server via a...

What is a Failed Deployment?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is a Failed Deployment?

Generating a Series I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Generating a Series I

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022?

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers