March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – DBCC command to RESEED Table Identity Value – Reset Table Identity

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server DBCC, SQL Server Security
DBCC CHECKIDENT can reseed (reset) the identity value of the table. For example, YourTable has 25 rows with 25 as last identity. If we want next record to have identity as 35 we need to run following T SQL script in Query Analyzer. DBCC CHECKIDENT (yourtable, reseed, 34) If table…
Read More

SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Coding Standards, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server Security
The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components: Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML Analysis Services Integration Services Notification Services Reporting Services Replication The samples databases downloads include…
Read More

SQL SERVER – FIX : Error 15023: User already exists in current database.

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
DBA, SQL Cursor, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure
Error 15023: User already exists in current database. 1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login 'Report' GO Run following T-SQL Query in Query Analyzer…
Read More

SQL SERVER – Primary Key Constraints and Unique Key Constraints

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Download, SQL Error Messages, SQL Index, SQL Joins, SQL Scripts, SQL Server Security
Primary Key: Primary Key enforces uniqueness of the column on which they are defined. Primary Key creates a clustered index on the column. Primary Key does not allow Nulls. Create table with Primary Key: CREATE TABLE Authors ( AuthorID INT NOT NULL PRIMARY KEY, Name VARCHAR(100) NOT NULL ) GO…
Read More
Exit mobile version