Session complete status and estimated completion time
A small retake on the popular percent complete script which tell how much more time an executing command will take.
2012-03-21 (first published: 2012-03-07)
1,577 reads
Scripts
Select the last error in the job selected
The job will send an HTML email with the latest error at specific job.
2012-03-15 (first published: 2012-03-05)
887 reads
Fix SSRS Subscription Owners
Stored procedure to update SSRS Subscription owners to avoid email errors.
2012-03-13 (first published: 2012-02-28)
1,401 reads
Server-Side Trace Pack
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-12 (first published: 2012-02-21)
1,088 reads
Get Top Queries Taxing SQL Server CPUs
Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.
2012-03-10
2,866 reads
Generate INSERT for table with IDENTITY column
Generate a "INSERT INTO...SELECT FROM" script for a table with an identity column.
2012-03-09 (first published: 2008-01-07)
4,152 reads
Testing all procs before upgrading to Compatibility Level 90
You can use this script to check if any procs will break under compatibility level 90.
2012-03-08 (first published: 2008-01-29)
4,286 reads
Check Table Size and DB Size
Two simple scripts to check table and database sizes. The scripts use temporary tables and the sp_msforeachdb/sp_msforeachtable stored procedures to present the output neatly.
2012-03-07 (first published: 2012-02-19)
2,678 reads
Shrink all databases
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
2012-03-07 (first published: 2008-01-14)
3,892 reads
Sending Job Failed Information Through E-Mail Using T-SQL
Sending Job Failed Information Through E-Mail Using T-SQL.
2012-03-06 (first published: 2012-02-13)
2,315 reads
Blogs
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
Forums
clean up accounts
EXEC sp_validatelogins <- Can we use this as a start to identify accounts in...
Exploring SQL Learning Resources for Aspiring Study Abroad Students in Jaipur
Hello Everyone! 👨💻👩💻 Are you preparing to study abroad and considering a career in...
(Alone) #call #girl In 0562088713 downtown Dubai
(Alone) #call #girl In 0562088713 Downtown Dubai (Alone) #call #girl In 0562088713 Downtown Dubai
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers