code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what is the order of execution of where,having,group by in select stement6 15475
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person10 5208
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=315 7453
i want table name basis on column name.5 4398
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.3 5072
In clustered and non clustered indexes which one is faster while executing a query ?1 5885
How to create logins using windows Authentication mode?2 2288
write the query for taking database restore in sql?2 3033
how many no of arguments can be passed in procedures and functions
Issues related in upgrading SQL Server 2000 to 2005 / 2008
How to convert a table data in XML format in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Does any body please help me what question's have asked for SSRS in the interview?
Why do you want to join software field as you have done your BE in Electronics?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How do use Having,Group by,Group function in SQL?
How can we call UDF(User Define Function) using C# code in ASP.net ?
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?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
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?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Explain Capacity planning to create a database? and how to monitor it?