Are all updates split into delete-insert?
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,803 reads
Blog Posts
Data Compression in SQL Server
Do you know much about data compression? It seems that quite a few people I meet don’t really understand how...
2011-06-21
2,341 reads
Index Rebuild progress v2
I have actually written about this subject earlier on my Danish blog (http://www.performanceduo.com/post/Index-Rebuild-progress.aspx), but last week when working on a...
2011-06-21
18,075 reads
New York SQL Events - Upcoming Triple Play......
If you're in a New York State of Mind (song by Billy Joel), then you'll like the triple play of...
2011-06-21
1,336 reads
PASS DBA Virtual Chapter Tomorrow
Tomorrow is time for part two of my presentations this month on Extended Events for the PASS DBA Virtual Chapter. ...
2011-06-21
633 reads
PASSMN Meeting Later Today
Well folks, we’re already to the third Tuesday of June. Where’s the summer going to? That means that this afternoon...
2011-06-21
703 reads
Replaying workloads with the RML Utilities
In today's weblog posting I want to talk about replaying SQL Server workloads with
the RML Utilities. RML Utilities stands for...
2011-06-21
4,193 reads
Speaking At The 2011 PASS Summit
The official notices went out to speakers last week and I am privileged to have the opportunity to present two...
2011-06-21
475 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help...
2011-06-20
896 reads
Code Snippet for an SSIS DataFlow Performance Wiretap
I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help record execution timing inside the flow.
Decomposition Is Time...
2011-06-20
9 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers