Rodrigo Acosta

For SQL 2000.Scan all indexes for fragmentation

This script creates an error message with a valid error number, and alert associated with the error message. (everything when it doesn't exists). Then captures all the user indexes in the database and executes DBCC ShowContig for each one. It calculates the % of fragmentation on leaf level and fires the alert when is fragmented.Then […]

5 (1)


2,272 reads

Show valuable info from sysindexes

This sp (sp_sysindexes) captures important columns from the table sysindexes and translates the numeric values into text. It shows the owner.object, the filegroup which it belongs to, the type of index, the total number of pages for tables/clustered indexes and non clustered indexes. It also shows the status, the indid and the type of object.You […]

3.5 (2)


3,605 reads

SP to import to a file

Is a SP that imports a table to a file. You just put the table name, the path and the sa password and then you have it. It is important that it parse the table inserted (pubs.dbo.sales for example) and checks that the db, the table with the owner exists


1,656 reads

Automatic Backups

Creates the backup devices where sql server is installed, creates an error message above 50001, an alert, and an adittional job in case the scripts fails. In the first time backups all databases and then backups the logs until two days past from the last full backup. Then backups the databases again and so on. […]

2 (1)


1,179 reads


Who needs data access? Not You!


With a little planning and care, we can find various ways to fulfill user...

Azure Synapse Analytics & Power BI performance


With two new relational database features (Result-set caching and Materialized Views) just GA’d in...

Session Evaluations from “SQL Server Security from the Ground Up”


I was recently given the opportunity to speak at Pass Summit. As always (this...

Read the latest Blogs


Session timeout vs Execution timeout difference

By sqlfriend

I am using report service 2017.  Trying to figure out how to set the...

Moving a Default Schema

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving a Default Schema

Using the Lightweight Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using the Lightweight Tools, which...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers