Miscellaneous

Technical Article

Pass several sets of parameters to run stored proc

  • Script

    This procedure will let you execute existing stored procedure with several sets of multiple parameters    like: exec _ParamSplit_SP 'ColorSP', "258,'RED';367,'BLUE';125,'GREEN'",";"    it will be the same as    exec ColorSP 258,'RED'    exec ColorSP 367,'BLUE'    exec ColorSP 125,'GREEN'Created for SQL 7

You rated this post out of 5. Change rating

2002-04-03

858 reads

Technical Article

spAuditPasswords

  • Script

This script is actually part of an article written about performing a simple password audit on SQL Server logins when you start to administor a new SQL Environment. The script will scan the sysxlogins table located in the master database for SQL Server logins with no passwords, passwords that are the same as the login […]

You rated this post out of 5. Change rating

2002-03-27

1,554 reads

Technical Article

Use DELETE On Many Tables With Foreign Keys

  • Script

When deleting data from many tables, foreign key constraints can force you to specifically order your DELETE commands. This can take tons of time, especially if you have many tables.  Here's a technique I use to delete data in the correct order during the restaging of test databases.It makes use of the system stored procedure […]

You rated this post out of 5. Change rating

2002-03-22

1,610 reads

Technical Article

Compare the structure & code of 2 databases

  • Script

We often make changes in the test databases. But failure in making even the smallest change in the production database may lead to unwanted situations.This utility compares 2 databases.Parameters to be passed   @DB1  Database 1 (SysName)  @DB2  Databse 2 (SysName)  @ShowDifferentOnly see later (Bit)       Parameters 1, 2 may include server name as  well. […]

You rated this post out of 5. Change rating

2002-03-22

510 reads

Blogs

Unused Indexes in SQL Server: Find them, vet them, and drop them safely

By

 Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...

T-SQL Tuesday #191 Round Up

By

I hosted this month, late as it turns out, but we still had a...

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Managing unused indexes

By JasonO

While doing some housekeeping activity on several old but large production databases, I come...

Cloud Performance Considerations

By MichaelT

How important to SQL Server is the speed of the SSD and network latency?...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers