Return of Index Analysis Part 1
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-05
951 reads
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-05
951 reads
There has been a slight change to this weeks SQL Lunch meeting. Our scheduled speaker cannot present this week, therefore...
2010-10-05
411 reads
It's official! I am presenting a mini session for SQL Saturday in Orlando. My topic and some details are below:
Delivery...
2010-10-05
453 reads
Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...
2010-10-05
543 reads
I wrote the editorial about great service after noticing a couple small but interesting customer service experiences during two trips....
2010-10-05
430 reads
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up. On October 20-22, you can attend a conference from...
2010-10-05
696 reads
Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…
OVER
OVER allows you...
2010-10-05
2,639 reads
The CPUID website has a screenshot of CPU-Z 1.55.2, showing its support for the upcoming 32nm Sandy Bridge processor, which...
2010-10-04
584 reads
Patrick Is the lead Singer
Sirens. Their sweet songs lured sailors to their deaths in tales of yore. Alas, I too...
2010-10-04
681 reads
Back in 2007 when we started SQLSaturday we had the good luck to leverage an existing relationship between Seminole Community...
2010-10-04
752 reads
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Hi, ssms is free here. I can think of other reasons to do this...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
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