List Where SQL Server Files
This SP checks the path where SQL Server is installed, and then lists all the .mdf and .ldf files. Also list the quantity of tables, views, sp, xp and users on the given database.
2001-09-10
2,802 reads
Scripts
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. […]
2001-09-07
1,245 reads
List Only User Tables
A simple stored procedure that only shows the user tables. It is like sp_tables but fixed to give a simpler vision of the tables.
2001-09-07
1,673 reads
Backup Transaction Logs on all Databases
Here we go again. This is the last in my backup series that I use to do backups of the databases. As far as I know this should only kick out errors when there really is one. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP […]
2001-09-06
870 reads
Differential Backups of all Databases
This is the SP I schedule to do diff backups on the DB's that I can. I still need to add errorchecking to see if there is a full available before I do a diff. I'll add that when I get time. This stored procedure is designed to take 4 parameters @bksrv : This is […]
2001-09-06
1,542 reads
Display Identity Values and Other Info
Displays identity values, number of rows in the table, and the difference between the two. The difference can indicate the amount of deletions that could be going on.
2001-09-06
351 reads
Display X Type Locking Users
This script creates a stored procedure that shows you a list of all the users that are locking objects on the database with mode X. It shows a full and detailed description on the user and object locked.
2001-09-06
1,465 reads
Stored Procedure to Backup all Databases
This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user […]
2001-09-06
4,596 reads
Recompile Compiled Objects
This stored procedure, updates the schema version of user table(s), which in turn marks the Stored Procedures and Triggers for recompile.
2001-09-05
1,407 reads
Display Stored Procedure Parameters
Display any stored procedures using input and output parameters. I took the view, PARAMETERS that ships with SQL 2000 and cleaned it up a bit.
2001-09-04
1,250 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCU GALAXY Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa Timur...
BCA KCU KEDIRI Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
BCA KCU MALANG Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers