create index a on employee(dno) In this,which index was created?2 2750
How will u get 5 years back record?5 5890
What is a materialized view?3 5656
What is MSDE?2 2591
How can you see what type of locks used?1 3082
What is transcation?Plz give One example?2 2814
Plz tell about backup&recovery?3 2722
How to find the date and time of last updated table?3 14418
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 7979
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?1 2754
can you any body tell me why are go for the rebuild the master database.what is the reason?2 2451
How do you Implement SSIS Packages in your Project?
How to restore performance issues and how to check?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Comment,Datatypes are unlimited
How you trouble shoot when any job fails
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How can we call UDF(User Define Function) using C# code in ASP.net ?
If a stored procedure is taking a table data type, how it looks?
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.
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?