How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?3 8380
What are the different ways of moving data/databases between servers and databases in SQL Server?1 2731
What is database replicaion? What are the different types of replication you can set up in SQL Server?3 3569
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 2455
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?1 2718
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?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
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?)
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
If a stored procedure is taking a table data type, how it looks?
how many no of arguments can be passed in procedures and functions
How do you Implement SSIS Packages in your Project?
application server is slow what may be the problem
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Call by value and call by reference in procedure and function, with NOCOPY.
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is the difference between NOROW and LOCKROW?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?