Tags » Database Administrator

Re-Initiating LOG SHIPPING when Secondary Server does not exists

Today I faced an issue where one of secondary server box is now not available due to some circumstances, now I have to delete this secondary server Name and Database entry from primary server’s database. 101 more words

Database Administrator

SQL Server Error Messages - Msg 8101

Sometime SQL Server error msg 8101 occurred, when anyone is trying to insert a new record into a table that contains an identity column without specifying the columns in the INSERT statement and trying to assigning a value to the identity column instead of letting SQL Server assign the value. 80 more words

Database Administrator

T-SQL Script for user Databases Backup with timestamp

The below script will backup all user databases. Every database backup file will be generate as Database name with timestamp.

USE MASTER
GO

– Declaring a cursor named as DBName for all User database having DBID>4… 79 more words

Database Administrator

Finding AUTOGOWTH/MAXSIZE of Databases

Sometimes with SQL server a DBA or Developer might be faced an error saying “The transaction log for database is full” OR “Could not allocate space for object because the filegroup is full” OR may be as “Primary filegroup is full” There may be many reason for same but most probable error is related to Data/log file’s AUTOGROWTH option definition at the time of database creation. 132 more words

Database Administrator

Back to Basics

Click here to see PDF file  : Back to Basics

Save a Command’s Output to a File

The use of redirection operators, specifically > and >> operators are used to redirect the output of a command to a file, giving us a saved version of whatever data the command produced in the Command Prompt window. 1,106 more words

Database Administrator

Ranking Functions – ROW_NUMBER,RANK,DENSE_RANK,NTILE

Ranking Functions – ROW_NUMBER,RANK,DENSE_RANK,NTILE

SQL Server 2005 introduced four new ranking functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE. These functions allow you to analyze data and provide ranking values to result rows of a query. 626 more words

Database Administrator

Differences between the SET and SELECT statements when assigning variables in T-SQL

It’s many times observed, a SQL Server Developer commonly use SELECT for assigning values to variables. This was fine and a perfectly valid practice till SQL Server 6.5 But SQL Server 7.0 introduced the new SET statement for initializing and assigning values to variables and SQL Server 7.0 Books Online also stated: “ 177 more words

Database Administrator