as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What do you mean by an execution plan? Why is it used?
How many index can be created for single table
4 Answers CarrizalSoft Technologies, Verizon,
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
How to encrypt Strored Procedure in SQL SERVER?
What is primary key, unique key, and foreign key?
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What are the different types of replication are there in sql server 2000?
What are the properties and different types of sub-queries?
What number aggregate functions are accessible there in sql?