Harsh_Chawla
Harsh_Chawla
-
Why to look at "Wait Statistics" to troubleshoot SQL PerformanceJun 18, 2012 at 6:25 AM
1
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
Presented By: - Sakthivel Chidambaram,SE,Microsoft...
-
SQL server 2008 FilestreamJun 18, 2012 at 6:23 AM 0
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...
-
Troubleshooting SQL server High CPU : Part 2Jun 11, 2012 at 6:45 AM 1
In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it.
Possible causes that can lead to high CPU usage by SQL server:-
1.Inefficient Query Plans
2. Intra- query Parallelism
3. Excessive Cache look up time
Presented By: - Niraj...
-
Troubleshooting SQL server High CPU : Part 1Jun 11, 2012 at 6:44 AM 0
In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it.
Possible causes that can lead to high CPU usage by SQL server:-
1.Inefficient Query Plans
2. Intra- query Parallelism
3. Excessive Cache look up time
Presented By: - Niraj...
-
Sparse ColumnsJun 11, 2012 at 6:41 AM 0
In this video blog we would walk you through a feature introduced from SQL server 2008 i.e. Sparse Columns.
Sparse columns are just an ordinary columns that have an optimized storage for null values.
It reduces the space requirements for null values at the cost of more overhead...
-
Product Update Feature in SQL Server 2012Jun 11, 2012 at 6:38 AM 0
A new feature introduced in SQL Server 2012 setup is "Product Update".
Product Update searches for the latest product updates and integrates it with the main product installation.It can search for the latest or applicable updates in Microsoft Update,Windows Server Update Services (WSUS), a local...
-
High Availability for SQL Server Replication using Database MirroringJun 07, 2012 at 10:02 AM 1
Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using Database Mirroring :
Highlights of this video blog :-1. Transactional Replication Overview.
2. Database Mirroring Overview
3. Replication with Database Mirroring.
4. Mirroring the Publication database
5. Effect...
-
Missing MSI's/MSP's error during SQL Server PatchingMay 08, 2012 at 2:52 AM 1
In this video blog, we would walk you through some tips and methods to troubleshoot Missing MSI's/MSP's error during SQL Server Patching or installation.
Highlights of this video blog :-
1. What are MSI's/MSP's
2. Location of Setup logs and log file names
3. Fixing missing MSI's and MSP's...
-
SQL Server ReplicationMar 22, 2012 at 11:51 PM 0
Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an overview of the "Replication in SQL server".
Highlights of the blog:-
What is replication?
Why we should use Replication?
What is replication Model?
Replication TypesAnd much more, also check out our...
-
Table partitioning concepts with sliding window exampleFeb 24, 2012 at 10:12 AM 0
Highlights of this video blog :-
1. What are Partitioned tables & benefits
2. Building Blocks of Partitioning
3. Partitioned Table Operations
4. Demo
5. Best PracticesPresented By : - Niraj P Mehta,SSE,Microsoft GTSC
...
Staff
Here is a list of Channel 9 staff members.
