In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;5 17303
What are Sql Reporting Services and analysis services? Can u Explain1 8162
what is differece between union and union all6 5640
Is trigger fired implicitely?2 3244
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.2 4135
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?8 14907
How to convert a table data in XML format in sql server?
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.
How to restore performance issues and how to check?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
tell me the disaster recovery plan
Call by value and call by reference in procedure and function, with NOCOPY.
what is checksum in sql server.........???
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How to trouble shoot if unable to connect SQL Server
OPTIMIZATION OF SP,CURSOR,TRIGGERS
how many no of arguments can be passed in procedures and functions
Scalability, Availability, Integration with internet, etc.)?