Why to look at "Wait Statistics" to troubleshoot SQL Performance

Here we will discuss on Waits in the context of SQL Server: Highlights of this video blog :- 1. What is wait and why we need to focus on wait? 2. Lifecycle of a session 3. Analogy to explain waits 4. Types of Waits. 5. Where to see waits in SQL Server 6. Demo To…

4

SQL server 2008 Filestream

Filestream is a  new feature in SQL server 2008, that allows storage and efficient access to BLOB data, using combination of SQL Server 2008 and NTFS file system. It provides  an easy way of handling BLOB data with database transactional consistency, integrated management, security and excellent streaming performance. It basically maintains transactional consistency between the…

2