How we Resize table,temp table, database and log file size
in SQL Server 2005
Answer / amrish kumar
USE DataBaseName
GO
SELECT name,physical_name,size,max_size
FROM sys.master_files
WHERE database_id = DB_ID('DataBaseName');
go
Is This Answer Correct ? | 0 Yes | 6 No |
How can you set the threshold at which sql server will generate keysets asynchronously?
What is a trigger in sql server?
What is check constraint in sql server?
Can we take the full database backup in log shipping?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
Define self join in sql server joins?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
Define model database?
Explain the flow of creating a cube? : sql server analysis services, ssas
What is cdc in sql server?
Explain triggers in sql?