If there is failure during updation of certain rows, what will be the state?2 8525
What is the difference between Userdefined function and stored procedure? Explain and give the example also5 6546
how to dispaly a particular row details from a given table2 3903
What is a transaction and what are ACID properties?3 4869
Explain different isolation levels?4 7684
What's the maximum size of a row?4 7781
Explain Active/Active and Active/Passive cluster configurations?1 3140
What is lock escalation?1 5434
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?9 13017
Explain the storage models of OLAP?1 5653
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1228
What are constraints? Explain different types of constraints?26 118553
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?2 7988
what operator performs pattern matching?2 8804
How much memory that we are using in Logshipping Concept?
last function used in MS Access to convert sql what function will use in sql
Scalability, Availability, Integration with internet, etc.)?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
on line cluster can we make if yes tell me the procedure
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is Lock table in SQL?
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?
If the job running very slow what is the action you do
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Delete duplicate rows without using rowid.
If we delete pack Spec what will be the status of pack Body ?
what are the Prerequisites for Replication?