SQL Server Aggregator

How to Enable RCSI for a Database with Database Mirroring

2010-03-16T21:36:00Z

Author: Sanjay Mishra Reviewers: Prem Mehra, Alexei Khalyako, Kun Cheng, Mike Ruthruff, Thomas Kejser, Sunil Agarwal To enable read committed snapshot isolation (RCSI) on a database, one needs to execute the following command: ALTER DATABASE <db_name> Read More......(read more)

Updated slide decks from SSMS presentation at SNESSUG

2010-03-16T01:55:00Z

Tonight I spoke at the SNESSUG user group meeting in Warwick, RI. You can download the slide deck here (this is a 3.5 MB PDF with presenter notes): http://sqlblog.com/files/folders/23423/download.aspx If you attended the talk, please feel free to provide...( Read More......(read more)

Yes, you can benefit from both data and backup compression

2010-03-15T20:18:00Z

Earlier today, MSSQLTips posted a backup compression tip by Thomas LaRock ( blog | twitter ). In that article, Tom states: "If you are already compressing data then you will not see much benefit from backup compression." I don't want to argue with a rock...( Read More......(read more)

OT: NCAA Pick'em Returns...

2010-03-14T19:28:00Z

Every year in March, the Men's College Basketball Championship Tourney Begins. For the past few years, I've put together a "League". This year is no different. The prize... Bragging Rights - that's it - nothing else.... Follow the link below to sign up!...( Read More......(read more)

Collaboration Nation Call to Action! Calling All SQL Server Bloggers and Twitterers

2010-03-13T01:18:00Z

Help build a brand new shiny centralized reference with a full compendium to everyone's blog & twitter hyperlinks who are active in the SQL Server space Read More......(read more)

ClearTrace Supports Statement Level Events

2010-03-12T13:26:42Z

One of the requests I get on a regular basis is to capture the performance of statement level events. The latest beta has this feature available. If you’re interested in this I’d like to get some feedback. I handle the SP:StmtCompleted and the SQL:StmtCompleted Read More......(read more)

There once was in Dublin a query

2010-03-11T17:00:00Z

For 6 months I’ve have been planning a secret trip to London in May as a surprise for my wife (of Irish heritage and accent) (I love how she says, "Aye laddie, kiss me I'm Irish." but that's for another blog.) The plan was to spend a week in London and...( Read More......(read more)

The ethics of aggregating other peoples' content

2010-03-10T22:20:00Z

Content theft Most of the recent - what I'll call - "discussions" about content aggregators have revolved around content theft. I'm not going to flip-flop on that topic: when you use someone else's work, you ask first, and if given the okay, you cite...( Read More......(read more)

Bad habits to kick : ignoring I/O

2010-03-09T01:14:00Z

In my last post in this series , I talked about problems associated with creating (and using) what I call the "uber-view." This time, in line with tomorrow's T-SQL Tuesday hosted by Mike Walsh , I wanted to talk about some I/O issues that tend to get...( Read More......(read more)

Queensland ICT Awards

2010-03-09T01:11:38Z

For the second year running WARDY IT Solutions has been nominated as a finalist for the ACS Queensland ICT Awards Read More......(read more)

T-SQL Tuesday - Query Cost

2010-03-09T00:03:00Z

In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL Tuesday , hosted by Mike Walsh who, like me, walks a straight path. In considering I/O – the movement of data generally Read More......(read more)

Bad habits to kick : creating the uber-view

2010-03-07T22:52:00Z

In my last post in this series , I talked about using ancient copies of Books Online, and why it can be important to keep your local documentation current. This time I wanted to touch on massive and wasteful views that are re-used a little too much. The...( Read More......(read more)

SQL Saturday #33 : slide deck, recap and shout-outs

2010-03-07T02:14:00Z

[Sorry I have been a little absent over the past couple of weeks. Returning from the Olympics just a little over a week ago meant some busy catch-up and a heavy lead-in to today's event.] Today I spoke at SQL Saturday #33 in Charlotte, NC. My presentation...( Read More......(read more)

Twitter will migrate from MySQL to Cassandra DB

2010-03-05T22:48:00Z

Since most of us are active on Twitter, I figured this would be of interest: http://www.dataprix.com/en/blogs/carlos/twitter-will-migrate-mysql-cassandra-db Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...( read Read More......(read more)

Enabling Partition Level Locking in SQL Server 2008

2010-03-03T23:54:00Z

Author: Thomas Kejser Reviewers: Juergen Thomas, Sanjay Mishra, Stuart Ozer, Lubor Kollar, Kevin Cox, Kun Cheng In this blog, we will provide additional details on a well-hidden feature in SQL Server 2008 – partition-level locking. But before we illustrate Read More......(read more)