SQL SERVER SPECIALIST

This Blog provide you the knowledge regarding DBMS and RDBMS.Specially for SQL SERVER and Oracle. Thanks A Lot .......for your cooperation and support.

Friday, 22 March 2013

Property-junction

Posted by Surender Kundu at 00:45 No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

Blog Archive

▼ 13 (1)
- ▼ March (1)
  - Property-junction

► 12 (2)
- ► January (2)

► 11 (72)
- ► August (10)
- ► July (17)
- ► June (45)

Popular Posts

How to Rebuild Sql Server Data base log file ?

DBCC REBUILD_LOG command can be run in SQL to rebuild the log file from the actual database. The first issue with the DBCC REBUILD_LOG comm...
Sql Server Physical Architecture

Introduction SQL Server 2005 is a set of components that work together to meet the data storage and analysis needs of the largest Web sites ...
Step by Step Transction Replication in Sql Server 2005

MSSQL Server 2005 Replication Step by Step 收藏 MSSQL2005 Replication For distributed databases, SQL Server 2005 provides comprehensi...
How to configure mail in sql server 2000/2005/2008.

You can configure sql server mail with out configure the mail profile in sql server by using below : Please follow the given below steps : ...
How to fine out last DML operation on table in oracle

SELECT * FROM DBA_TAB_MODIFICATIONS WHERE TABLE_OWNER='schemaname' AND TABLE_NAME='tablename'
Sql Server DBA Interview questions

Please complete all below questions series after that attend any interview for Sql DBA 1).what is the default Recovery model of a newly c...
SQL Server I/O Bottlenecks ?

I/O Bottlenecks SQL Server performance depends heavily on the I/O subsystem. Unless your database fits into physical memory, SQL Server co...
Property-junction
Check how much space used by Data file in Sql Server

select a.FILEID, NAME = left(a.NAME,15), [FILE_SIZE_MB] = convert(decimal(12,2),round(a.size/128.000,2)), [SPACE_USED_MB] = con...
DB Link creation in Oracle

1 TYPES OF DATABASE LINKS The type of database links that oracle lets you create are private, public, and global database l...