(Rajendra Gupta) SQL Server 2012 has many new features and the Indirect Checkpoints feature is an interesting option to allow you to control the recovery time for a database. In this tip we will explore the use of this new feature and the steps to configure this option.

(Shivprasad koirala) SQL Server is a massive RDBMS software.Even after so many years when I see, I always see something new. I wonder how many hidden gems still exist unexplored inside this huge giant.

(Tibor Nagy) I heard that outdated statistics can cause SQL performance degradation. I am new to SQL Server and have not experienced this problem yet. Could you please show me an example?

(Ted Krueger) In a merge replicating world, laptops are typically the majority of the subscribing machines. With laptops and any other user controlled computer, changes can come up – upgrades are needed or new hardware rollouts. These all cause the need for a new or rebuilt laptop / desktop to be

(Rohatash Kumar) Today, I have provided an article showing how to utilize the new data type conversion functions in SQL Server 2012. These are the three functions:

(ke4vtw) The original tip avoided the use of cursors, but in exchange, used table row modifications inside of a transaction. This leads to its own share of problems.

(Glenn Berry) In Part One of this series, I covered the initial steps that were necessary in order to prepare a new server before installing an instance of SQL Server 2012. In this installment, I will discuss the next steps that are required when you actually install SQL Server 2012, assuming that y

(Pinal Dave) Earlier I wrote a blog post about how to resolve the error with database diagram. Today I faced the same error when I was dealing with a database which is upgraded from SQL Server 2005 to SQL Server 2008 R2.

(Daniel Calbimonte) Many people have stayed away from using SQL Server Analysis Services, because it takes a lot of time to understand the basics to get started. You need to understand the concepts of Dimensions, Measures, Hierarchies, Fact Tables and a lot of other new items that don’t translate ea

(Thomas LaRock) You’re doing it wrong. You didn’t mean to be that way, I know. But the truth is things happen. When they do I am brought in to find out what is happening, what has gone wrong.