Tags » Database Administrator

Import Text file in a Table

As we know there are many options to import TEXT file data in a SQL Server Database table like using Import/Export Wizard, SSIS, BULK Insert command or OPENROWSET method, apart from these we can also use xp_cmdshell to import text file in a Table as, 42 more words

Database Administrator

Customizing ORDER BY clause

As we know ORDER BY clause used to sort result as per specified order – where it may be ASC or DESC. Its sort the result set by specified columns. 130 more words

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