|
|
-
|
|
By this time everyone are aware that the next version of SQL Server i.e DENALI comes with ColumnStore Indexes which is a new concept in SQL Server. If you haven’t tried this feature yet then its about time to try it out on CTP3. I am pretty sure you will like it and this may be one of the few ......
|
|
-
|
|
Accessing remote data in SQL Server is inevitable sometimes and often people use linked servers for this task. Linked servers are a good option because they are easy to setup and the maintenance is relatively easy but they quickly realize the performance issues when accessing the remote data.
There......
|
|
-
|
|
Introduction
In the past week this topic came up in 3 different occasions and it seems there is lot of confusion around this topic. In this post I will try to delve into some details and a demo to show that it’s NOT true. The confusion here is, the operation has to touch each and every row of the t......
|
|
-
|
|
Introduction
This question came up in a recent twitter conversation and Paul Randal clarified it at that time. I will make an attempt to attest to that theory as a supportive evidence using a demo.
Most of the readers should already be familiar with this Trace Flag and if NOT take a moment to read......
|
|
-
|
|
CHECKPOINT is one of the most misunderstood topic among developers as well as DBAs. One of the misconception is that CHECKPOINT writes only the committed data and that is NOT true. Paul Randal wrote about this topic extensively (here) and busted this myth (here)
Today, I am going to bust this myth ......
|
|
-
|
|
Introduction
Everyone who works with Data warehouse data loads should be familiar with Minimal Logging. Minimal Logging helps tremendously in improving the performance of data loads as the amount of logging is reduced enormously by keeping track of only the extent allocations but not individual row......
|
|
-
|
|
A good DBA always monitors what’s written to the Error log and trying to make sense of what’s happening on the server or look for potential issues or look for any traces something other than ordinary is happening.
If you are using CTP1 of DENALI, the next version of SQL Server and using......
|
|
-
|
|
Service Broker was introduced in SQL Server 2005 but hasn’t been adopted as much as some of the other technologies that came in SQL Server. Although Service Broker is a solid and robust technology and is widely used by MySpace (one of the largest SQL Server installations), there are few reason......
|
|
-
|
|
Introduction
Locking in SQL Server is a very important aspect but misunderstood by many folks and there are many myths that go around this topic. SQL Server provides few knobs to control the behavior of locking to some degree but for the end user perspective it is completely opaque, how SQL Server ......
|
|
-
|
|
SQL Server Reporting Services (SSRS) has rich set of functionalities that can be used effectively to automate sending of reports. In large institutions with many departments interacting with other departments internally or with external folks, its is very important to customize the delivery of the r......
|
|