create index a on employee(dno) In this,which index was created?2 2653
How will u get 5 years back record?5 5696
What is a materialized view?3 5532
What is MSDE?2 2424
How can you see what type of locks used?1 2984
What is transcation?Plz give One example?2 2697
Plz tell about backup&recovery?3 2572
How to find the date and time of last updated table?3 14132
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...7 7668
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?1 2627
can you any body tell me why are go for the rebuild the master database.what is the reason?2 2323
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
how to use DTS package in 2000,2005,2008 in sql server
You are doing log shipping due to some reasons it is failing. How you will proceed from there
your distribution database is full what will u do
What is RMS migrations?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How we create SQL Server 2005 Reporting Services ? Give me Sample
role of sql sever 2005 in database rather than any other database
whats the maximum size of view state??
wat wil hapn if we give the both read and deny read permission to user?
Tell about MOM Tool(Microsoft Operator Manager)?
on line cluster can we make if yes tell me the procedure
Delete duplicate rows without using rowid.
Scalability, Availability, Integration with internet, etc.)?