June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Scripts, SQL Stored Procedure
In my organization we rename the database on development server when are refreshing the development server with live data. We save the old database with new name and restore the database from live with same name. If developer/Jr. DBA have not saved the SQL Script from development server, he/she can…
Read More

SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Data Warehousing, Database, SQL White Papers
White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services. This architecture provides the following improvements Improves the utilization of disk resources Optimizes cube processing operations Supports dedicated snapshots for specific users at different points…
Read More

SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL System Table
Following script are very useful to know all the constraint in the database. I use this many times to check the foreign key and primary key constraint in database. This is simple but useful script from my personal archive. USE AdventureWorks; GO SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint, SCHEMA_NAME(schema_id) AS SchemaName, OBJECT_NAME(parent_object_id)…
Read More