Scripts

Technical Article

Script to Zip a Backup File

A handy dandy proc that can be used to zip up a backup file to location specified. Also called from a backup script to automate the compression of all backups using PKZip command line utility. Make sure pkzip is in the path and found by the shell prior to using this script.

1 (1)

You rated this post out of 5. Change rating

2001-08-20

3,714 reads

Technical Article

Script to Search SQL Error Log For a String

This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III

4 (1)

You rated this post out of 5. Change rating

2001-08-13

1,895 reads

Technical Article

Show Fragmentation Before and After Reindex

This will show the fragmentation and stats before and after a reindex of a specified table. Run in the context for the db that holds the table the proc will get passed and re-index. Complile in master since the master is checked first for any SP that is prefixed with SP_ and you can call […]

You rated this post out of 5. Change rating

2001-08-13

4,014 reads

Technical Article

SQL Server Current Activity SuperCheck

This gives a quick check of the current activity on a SQL Server. I developed this after getting continually frustrated with "Current Activity" in SQL/EM getting blocked by processes when I needed to see blocking issues on the server. It has been immensely valuable to me in quickly identifying production-stopping issues on the database. It […]

4.2 (5)

You rated this post out of 5. Change rating

2001-08-13

4,868 reads

Blogs

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Read the latest Blogs

Forums

create cluster fails Win2016.

By snomadj

I'm installing a cluster prior to my 2019 SQL build.   Failover Cluster tools...

Dependency Cycle in Database with Update Approvals

By ahlembreath

I'm struggling with a dependency cycle in my SQL database schema. Here's the situation:...

Query run from SQL agent, not returning same results as from query window

By aaron.reese

I am running SQL2012 (don't ask...) and my collation is Latin1_General_CI_AS and my language...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers