What are functions3 5766
how to get the automatic backup of the database in the sql server4 31246
What command do we use to rename a db?5 7933
Which command using Query Analyzer will give you the version of SQL server and operating system?3 11816
What is the STUFF function and how does it differ from the REPLACE function?2 16512
What is the purpose of UPDATE STATISTICS?2 9414
What is de-normalization and when do you do it?3 5120
Explain some DBCC commands?6 13364
What is the purpose of using COLLATE in a query?1 15775
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
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.
last function used in MS Access to convert sql what function will use in sql
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.
how can u get last observation in an unknown dataset ?
whats the maximum size of view state??
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is data modeling and Reterminal integrity?
If user is owning any SQL Objects, can we drop that user
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
tell me the disaster recovery plan
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Why we need to use secondry database file? though, we can do same work using primary database file also.