Maintenance and Management

Technical Article

Alter Index with online rebuild - SQL 2005

  • Script

This is an Alter Index script i made up from the one found in BOL and some other scripts we had. You need to create a table to hold the fragmentation data and it has a date column so you can track historical data. You can also add a db_mail part at the end to […]

5 (1)

You rated this post out of 5. Change rating

2007-08-10 (first published: )

2,122 reads

Technical Article

Database,Drive,Data file growth monitor

  • Script

This script is to monitor drive\database file space. There are variations of this script. The one posted has 2 parts. The frist is one that loops through the databases on a particular server calling the second which is the proc that gathers the information.

You rated this post out of 5. Change rating

2007-08-01 (first published: )

1,178 reads

Technical Article

FULL SERVER DOCUMENTATION -- HTML  and revised

  • Script

Revise note: 1. reformat the result into HTML page.2. added script to find sql server service account, sqlserver agent account.3. added script to find sql server authentication mode.4. added script to find sql server startup parameters5. added table of contents and hyperlinks.6. add DOS batch script to run the script on all servers.     TRY […]

5 (1)

You rated this post out of 5. Change rating

2007-02-20 (first published: )

1,432 reads

Technical Article

Show when all jobs were running

  • Script

This script returns a result set showing which jobs were running at what point during a given day.One column is returned for each Job, and one row for each discrete portion of the day (configured by @TimeGranuality). A value of 1 indicates that the job was running at that point in time, 0 otherwise.Particularly useful […]

4.5 (2)

You rated this post out of 5. Change rating

2007-07-26 (first published: )

532 reads

Technical Article

Remove Exec Permissions To Extended Stored Procs

  • Script

I created this script to simplify the process of restricting access to high risk extended stored procedures. It will find any user or role which has execute permissions on any of the stored procedures in the "#High_Risk_Stored_Procs" temp table and will generate the relevant revoke statements to remove those permissions.The current list of stored procedures […]

5 (1)

You rated this post out of 5. Change rating

2006-11-27 (first published: )

653 reads

Technical Article

LongestRunningQueries.vbs

  • Script

This SQL 2005-only VBS script will show the longest-running queries on a given server, complete with graphical .sqlplan when clicked. Results go to a web page, viewed from the local machines's temp directory.Each row of the resulting table has the session ID, the currently running statement of the batch, a link to a text file […]

5 (1)

You rated this post out of 5. Change rating

2007-07-24 (first published: )

369 reads

Technical Article

User Tables with Size  all DBs (SQL 2005 Only)

  • Script

Hope this is helpful to someone.  This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]

5 (1)

You rated this post out of 5. Change rating

2007-07-16 (first published: )

283 reads

Blogs

The Book of Redgate: Meetings

By

I think we might have forgotten this a bit, but on one of the...

New article: Automating SQL Server Builds

By

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Leading with Accountability: How Extreme Ownership Transforms Leadership

By

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Read the latest Blogs

Forums

Change Tracking Default Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Default Retention

ssrs subscription file share

By jshumaker

I am trying to create a subscription that posts to a one drive directory. ...

What is Delayed Durability in SQL Server — And Should You Turn It On?

By Chandan Shukla

Comments posted to this topic are about the item What is Delayed Durability in...

Visit the forum

Question of the Day

Change Tracking Default Retention

I run this command on my SQL Server 2022 database:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;
What is the default data retention period?

See possible answers