Adventures in Database Administration

Friday, February 14, 2014

SESSION: Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Ki...

Posted by Kevin at 4:42 PM

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Subscribe To

Posts

Posts

Comments

Comments

Popular Posts

Dynamic Connection Strings in SSIS

If you need the ability to change connection strings in your SSIS packages without opening each one and hard coding a string, then dynamic c...
OT: Recharging a defective Craftsman 19.2 battery

Several years ago, I received a Craftsman 19.2v cordless drill set as a gift. It came with 2 batteries and, over the years, the drill and th...
The database owner SID recorded in the master database differs from the database owner SID recorded in database

The database owner SID recorded in the master database differs from the database owner SID recorded in database '<Database>'. ...
Setting up aliases on a SQL Server with multiple instances

This article will explain how to set up multiple aliases for a SQL Server running multiple instances. Aliases can be an important part of a ...
Adding a table (article) to transactional replication without regenerating (recreating) the entire snapshot.

I’m using transactional replication to move data off of a production server and on to a reporting server to keep the load off production wh...
Extracting a Query Execution Plan from the Procedure Cache

From SQL Server 2005 forward, it has been possible to view the execution plan of a query that has been executed by someone other than yourse...
Remove an Article from Transactional Replication without dropping the Subscription

While using Transactional Replication, there may come a time when you need to drop an article from a publication, a publication th...
Starting a SQL Agent job with Powershell and Windows Scheduled Tasks

In the past, I’ve needed to start SQL Agent jobs using Windows Scheduled Tasks. Using Powershell, this is now easier than ever. First, let...
How to check if Replication components are installed on your SQL Server instance

If you need to check as to whether or not SQL Replication components are installed on a specific instance of your SQL Server, executing the ...
Using Powershell to Manipulate TFS Get Latest, Check In, and Merge

In our environment, changes made in the Test branch have to travel through the Main branch and into the Release branch to be deployed into p...

Blog Archive

► 2017 (5)
- ► May (1)
- ► March (1)
- ► February (3)

► 2016 (4)
- ► November (1)
- ► February (1)
- ► January (2)

► 2015 (9)
- ► December (3)
- ► October (1)
- ► September (4)
- ► August (1)

▼ 2014 (5)
- ► September (1)
- ▼ February (1)
  - SESSION: Skewed Data, Poor Cardinality Estimates, ...
- ► January (3)

► 2013 (5)
- ► December (2)
- ► August (1)
- ► June (1)
- ► May (1)

► 2012 (9)
- ► November (1)
- ► July (2)
- ► May (1)
- ► April (1)
- ► March (1)
- ► January (3)

► 2011 (30)
- ► November (2)
- ► October (1)
- ► September (3)
- ► August (6)
- ► April (4)
- ► March (9)
- ► February (5)

Labels

Simple theme. Powered by Blogger.

About Me

Kevin: Western Arkansas, United States; As a data professional, I get the opportunity to work with multiple technologies day in and day out in an effort to support business initiatives. My formal title is Database Administrator with my primary focus centered on Microsoft SQL Server and IBM DB2. Although there are many facets of SQL Server, I tend to focus on performance tuning and database design in addition to the daily administration that comes with being a DBA. Since I also have a background in applications programming, I’ve been able take on additional responsibilities including Cognos administration and report writing, SQL Server Integration Services (SSIS) programming, Visual Studio Database Projects, and Great Plains (GP) Dynamics.

View my complete profile