what is the main difference between constraints(like primary key etc..)& joins?2 3715
What are the types of backup and tell me the difference between full and differential backup?4 9316
Wht is Stuff in sql ser2 2550
how to get 25th row in any table in sqlserver can u tell me syntax8 6760
How to find the last update record in SQL Server?4 13038
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...7 5841
how many no of arguments can be passed in procedures and functions
your distribution database is full what will u do
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
how to take backup bcp out for a column in table in sql server?
How do use Having,Group by,Group function in SQL?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
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 are the dis_advantages of stored procedures, triggers, indexes?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
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 ?
Tell about MOM Tool(Microsoft Operator Manager)?
If we delete pack Spec what will be the status of pack Body ?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?