Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lijo Cheeran Joseph
Posting Yak Master
123 Posts |
 Posted - 2010-11-12 : 05:40:05
|
| Hi Team,I am trying to list out the powerful underused features of SQL Server. Can you please contribute with details?Powerful underused features of SQL Server1) OVER for aggregate operations (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=152867)2) MERGE for multiple operations3)4)ThanksLijo |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-11-12 : 06:11:10
|
| Undersused by whom ?PBUH |
 |
|
|
Lijo Cheeran Joseph
Posting Yak Master
123 Posts |
Posted - 2010-11-12 : 06:15:35
|
| by newbie developers |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2010-11-12 : 10:55:26
|
| Here are a few that I have observed:- With statement in Select- READ_COMMITTED_SNAPSHOT- sys.dm_exec_query_stats |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Powerful underused features of SQL Server