If there is failure during updation of certain rows, what will be the state?2 8267
What is the difference between Userdefined function and stored procedure? Explain and give the example also5 6245
how to dispaly a particular row details from a given table2 3701
What is a transaction and what are ACID properties?3 4679
Explain different isolation levels?4 7369
What's the maximum size of a row?4 7497
Explain Active/Active and Active/Passive cluster configurations?1 2968
What is lock escalation?1 5262
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?9 12599
Explain the storage models of OLAP?1 5294
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1105
What are constraints? Explain different types of constraints?26 116197
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?2 7702
what operator performs pattern matching?2 8432
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
New concepts of sql server 2005 use in your project.
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
what exactly sql injuction.how to overcome.....
tell me the disaster recovery plan
what is package and it uses and how can u call a package
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 .
What are the dis_advantages of stored procedures, triggers, indexes?
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.
where the connection string store in the database
plss anybody specify tha constrian management system in dbms
How do you Implement SSIS Packages in your Project?
on line cluster can we make if yes tell me the procedure
ow to bring suspect mode datbase online from scratch