Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?1300
Which institute is best for SQL Server 2005 Training?6 3071
How do we rollback the table data in SQL Server3 13816
where do you use Isolations?give me some exmpale?1 3226
In which year relase the 7.0& 2000 & 2005?1 1968
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply1 4219
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..4 4217
select empid empname from employee What is the result for the about query?4 3496
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
what is difference between view and Dip.
If the job running very slow what is the action you do
role of sql sever 2005 in database rather than any other database
where the connection string store in the database
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is the difference between online clustering and Offline clustering?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to convert a table data in XML format in sql server?
what exactly sql injuction.how to overcome.....
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
how many no of arguments can be passed in procedures and functions
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Which is the best place or learning center for MS SQL?????In Bangladesh?????