Tag: Microsoft SQL Server

COLLABORATE minus 3

Musings about COLLABORATE, the 9th version of which is happening in Las Vegas USA from April 7-11 2014.

Read More >

Tips on TempDB

Are you curious about TempDB? Allow me to help make your understanding of the subject permanent. TempDB is an interesting system database that doesn’t behave quite like the others. It’s kind of like a quirky friend that you’ve come to…

Read More >

Nothing to Blog About? Think Again!

Suggestions about how to proceed if you are just getting started with blogging or searching for topics to blog about.

Read More >

SQL Server Integrity Check – A Necessary Routine

Today I’ll be discussing Integrity Check on SQL Server – we have some very good info in the community, but I’d like to summarize my thoughts here. When a DBA talks about Integrity Check, the conversation is usually redirected to…

Read More >

SQL Server Statistics: Maintenance and Best Practices

What are Statistics? There are multiple paths a database can use to answer a query, some of them being faster and more efficient than others. It is the job of the query optimizer to evaluate and choose the best path,…

Read More >

Untold Secrets of SQL Server: What if?

It’s common practice for IT vendors to keep some of the commands and statements for their own use, and to avoid publishing or documenting these tools for two reasons: Some of these commands are unsafe for production environments and should…

Read More >

Merge Replication Identity Range Management – An Identity Disorder? Part 2

part 2 explores how transactions and batches can affect Merge replication identity range management. It shows a case where batch insert inside a transaction caused applications to fail and provides a resolution to the case.

Read More >

SQL Server versions – Should you upgrade to the next release?

Today there are five versions of SQL Servers serving at the hearts of business enterprises, and the sixth is coming soon. Current SQL Server versions are 2000, 2005, 2008, 2008R2, 2012 and the upcoming version SQL Server 2014. The question…

Read More >

How to Configure Transactional Replication-Mirroring Failover

Configure SQL Server Transactional Replication with Mirroring – this was one of the recent interesting and unusual projects that came our way. At first it looked really odd and intriguing at the same time. The question was, can it really…

Read More >

Merge Replication Identity Range Management – An Identity Disorder? Part 1

This blog will shed some light on identity range management and how it works. Part 2 will explore how batch inserts can affect the identity range management.

Read More >