In an earlier column,
I suggested that one way to speed up your application was to reduce the
trips you make to your database, specifically by avoiding calling a
stored procedure multiple times. To enable that, I showed how to pass a
stored procedure multiple parameter values in a single call and then,
inside the stored procedure, load the parameters into a table where they
could be integrated with other SQL statements.
همانطور که اطلاع دارید نسخه آزمایشی SQL Server 2016 قرار از تابستان امسال (2015) در دسترس باشد. قابلیتهای جدیدی به این محصول اضافه شده است. تعدادی از آنها عبارتند از
1- امکان استفاده از Clustered Column Store Index در جداول Memory Optmized
2- َAlways Encrypted
3- پشتیبانی از JSON
4- پشتیبانی از زبان R در SQL Server
و ...
بخاطر کمبود مستندات برای SqlServer.ScriptDom مایکروسافت، آقای موریس چند پست وبلاگی در این باره نوشته و یه مخزن github هم در این رابطه ایجاد کرده که برای شروع یادگیری مناسبه.
A few of the customer-requested updates in Microsoft SQL Server 2014 SP1 are:
- Column store performance is improved when batch mode operators spill over to disk. A new XEvent provides insights into column store inserts.
- Several issues in buffer pool extension SSD configuration are addressed, including the ability to do instant initialization of the buffer pool extension file.
- Certain queries compile faster when using new cardinality estimator, and other cardinality estimation query plans are more efficient when using TF-4199.
- The scalability benefits of two trace flags (TF-1236, TF-9024) are applied automatically.
- Backup header information retrieval works better with encrypted backups.