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 No comments:

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

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

Subscribe To

Posts

Atom

Posts

All Comments

Atom

All Comments

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

.net
19.2v
2005
2008
2008 R2
alert
alias
Analysis Services
Annotation
ansi_padding sql ansi padding SSMS
availability group
backup
battery
BIDS
books
build list
CDC
Change Data Capture
classifier function
cluster
CNAME
command
ConfigurationInfo
connect
Connection String
cordless
Craftsman
cursor
DBA
defective
diable trigger replication table permission
dmv
DNS
drill
drop subscription
Dynamic
Dynamic SQL
Entity Framework
Epictetus
error
error log
event log
Execution Plan
ExecutionLog3
ExecutionLogDaysKept
extended events
Great Plains Dynamics SQL 2005
HA
Indexes
Insufficient Permission
LINQ
long running query
microsoft
mirroring
msdb
msdb sql agent server sysjobs
network
parameterization
password
powershell
Procedure Cache
progress
Query
RDP
recharge
recovery
remote desktop
replication
replication sql 2008 2008 add table article tranactional snapshot
replication sql server data validation
resource governor sql 2008 enterprise
resource pool
restore
review
SAN EMC Clariion SQL Server 2008 Windows Cluster Partition_Offset Stript_Unit_Size File_Allocation_Unit_Size Dell Microsoft
script
security
server
severity 16
SID SQL Server restore database alter authorization SA
snapshot
space
SQL
SQL 2005. cluster
sql 2008
sql agent
sql log file shrink DBCC SHRINKFILE
SQL Profiler 2008 2005 Upgrade Advisor
SQL Reporting Services
sql server
SQL Server access permissions stored procedures system tables database_permissions database_principals
SQL04151 visual studio database projects 2010
SQLCMD
SSAS
SSIS
SSMS SQL Server Management Studio Error Registry 2008 2005 Backup Path
SSRS
stoicism
storage
stored procedure
Stored Procedures
subsystem
sys.dm_exec_sql_text
sysmessages
system objects
table value function
tables
TCP/IP
TFS
Tips
transaction logs
transactional
transactional replication msrepl_tran_version sql column
TSQL
Usage
variant
visual studio
VMWare
windows
workload group
XML
XMLA
xp_cmdshell

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