Can you give me some DBCC command options?(Database
consistency check) - DBCC CHECKDB - Ensures that tables in
the db and the indexes are correctly linked.and DBCC
CHECKALLOC - To check that all pages in a db are correctly
allocated. DBCC SQLPERF - It gives report on current usage
of transaction log in percentage. DBCC CHECKFILEGROUP -
Checks all tables file group for any damage.
If we shrink the Databse and Files, how much size is
decreased?
61
how can you attach more than 20 ldf files in sql server
100
what’s the difference between Covering Indexes and Clustered
Indexes ?
how to use clustered index small ?
139
whate is advantages of sql server 2000
163
Any one plz send me SQL Server Developer/DBA resume for 4
years experience
316
One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d e f
g h
53
what is difference between view and Dip.
140
How to Improve the performencs of SQL Server 2005 exclude
stored Procedure and Indexes?
141
A left outer join B
B right outer join A gives the same result then what is
the use of two?
33
if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition
hi,
how to link a text file and a .rpt file in my tables of sql
server and to retrieve those records for further use. reply
me as soon as possible.
49
Explain couple pf features of SQL server
265
A successfully created SSIS package in SQL Server 2005 runs
fine in MS BIDS and Integration Services. But gives error
when run through an SQL-Job. What are the possible reasons?
What is log shipping? Can we do logshipping with SQL Server
7.0 - Logshipping is a new feature of SQL Server 2000. We
should have two SQL Server - Enterprise Editions. From
Enterprise Manager we can configure the logshipping. In
logshipping the transactional log file from one server is
automatically updated into the backup database on the other
server. If one server fails, the other server will have the
same db and we can use this as the DR (disaster recovery) plan.
255
Which command executes the contents of a specified file?
To Refer this Site to Your Friends 
Site Map
