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,046 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

A DevOps Workshop Tomorrow in Atlanta

By

Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...

Stop Wasting Time Rebuilding Indexes Every Night

By

Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....

SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries

By

If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...

Read the latest Blogs

Forums

Question on SQL Query with NOT condition

By mcfarlandparkway

I have a record, in those the three columns where firstname / last name...

Execution Plan Operators

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Execution Plan Operators

Merge spans with Dates Logic

By dhanekulakalyan

--for a given member if the startdate and endate is continous we need to...

Visit the forum

Question of the Day

Execution Plan Operators

When looking at an execution plan in SSMS, what types of operators are shown?

See possible answers