How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?3 8317
What are the different ways of moving data/databases between servers and databases in SQL Server?1 2709
What is database replicaion? What are the different types of replication you can set up in SQL Server?3 3528
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?1 2410
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?1 2694
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
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?
What are the dis_advantages of stored procedures, triggers, indexes?
What is the difference between NOROW and LOCKROW?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
role of sql sever 2005 in database rather than any other database
How you trouble shoot when any job fails
Delete duplicate rows without using rowid.
How much memory that we are using in Logshipping Concept?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is RMS migrations?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
If we delete pack Spec what will be the status of pack Body ?