SQL Server 2012 brings a new feature called Indirect Checkpoint. You can read more about it here: http://msdn.microsoft.com/en-us/library/ms189573.aspx. With Indirect Checkpoint, you get smaller and too many I/Os Checkpoint...

2013-03-19

18 reads

The end of the Internet, data and the PC

by administrator

The Future Computing Appliances and SQL Server

The Big Data revolution will be more important than the PC or the Internet. While there were many...

2013-03-04

10 reads

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

by administrator

SQLFeatures

2012-10-13

7 reads

Presenting PowerShell: Automating SQL Stats Collection

by administrator

SQLFeatures

2012-10-05

5 reads

All authors

PASS SQLSaturday - speaking on -Streamlining SQL Server Implementations across organization-

Presentation DAC SQL Server Implementation Framework From Dev to Prod

SQL Server Implementation Frameworks From Dev to Prod

Presentation DAC -AlwaysOn Multisite Cluster Implementation In The Cloud-

Presenting AlwaysOn Multisite Cluster Implementation In The Cloud

9 resources not to be Skeptic about Big Data

SQL Server 2012: Indirect Checkpoint (Target Recovery Time), get the real scoop

The end of the Internet, data and the PC

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

Presenting PowerShell: Automating SQL Stats Collection

Blogs

T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?

Optimizing Redshift Performance by Configuring WLM Queues

PowerShell Strikes Back: Return of the Loop

Forums

Dealing with huge heap tables

Merge Replication failing with Error converting data type nvarchar to numeric

Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit

Question of the Day

Distance Metric Algorithms