you can use dmv

sys.dm_db_log_space_usage will give the log file usgae.you will be getting similar information when you retrive the data using DBCC SQLPERF('logspace').However this dbcc command will give you...

N i c e Q u e s t i o n

In order to resolve the issue, please refer to the following steps:

1. Login to the MSSQL Server Management Studio with Windows Authentication.

2. In SQL Server Management Studio Object Explorer,...

you can configure through LiteSpeed.Lite Speed Provide

Compresses backups up to 85% more than competing full backup solutions

Analyzes for the best compression options for databases

Provides automatic recovery from I/O issues

Performs...

ya you can setup principle servers in one instan e and mirror dabases in one instane

.NET connection string

"Data Source=ServerA;Failover Partner=ServerB;Initial

Catalog=AdventureWorks;Integrated Security=True;"

Truncate

Delete

TRUNCATE is a DDL command

DELETE is a DML command

TRUNCATE TABLE always locks the table and page but not each row

DELETE statement is executed using a row...

select * from sys.procedures

Activity Monitor,Audit, Backup Compression, Central Management Servers,Data Collector and Management Data Warehouse, Policy-Based Management, Predictable Performance and Concurrency, Resource Governor, Transparent Data Encryption (TDE)

LOCKING occurs when connection needs access to a piece of data in database and it’s necessary for SQL Server when managing multiple connections

BLOCKING occurs when two connections need access to...

1.DBCC CHECKALLOC

DBCC CHECKALLOC checks page usage and allocation in the database. Use this command if allocation errors are found for the database. If you run DBCC CHECKDB, you do not...

by using this we can see the drives space EXEC xp_fixeddrives

sp_helpdb 'DatabaseName' By using we can see the datbase sie

check the frgamnetion of the table after that if fragmentation of table is more than 40% you need to go for the rebuild the index .

we can using perfmon and any other way to check

A)Database Mirroring

B)Log-shipping

A1)Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server...