Poor Little Misunderstood Views
Some people love ‘em, some people hate ‘em. But, one thing I have found to be nearly universal is that...
2010-07-29
59,928 reads
Implicit Data Conversion: The "HHidden" Bottleneck
Have you ever written a query that just seems to take forever? You have looked it over time and time...
2010-07-13
976 reads
WHERE to begin
Many people, once they start getting comfortable writing SQL, begin asking the same questions. One such common question is “Does...
2010-07-07
1,303 reads
Indexes are best utilized in WHERE, not JOIN
A pervasive oversight in database indexing by newer database users is relying solely on indexes used for joining tables together...
2010-07-01
3,736 reads
Function Calls are Evil Incarnate
The following queries look extremely innocent. However, they are all application killers once the target table grows to more than...
2010-06-28
1,352 reads
My SELECT statement has hung!
One of the first roadblocks many developers run into when using SQL Server for the first time is firing off...
2010-06-24
2,578 reads
The Power of Indexes
Time and time again I have run into the scenario where a developer who is moving into using databases is...
2010-06-22
710 reads
Killer I/O
Here’s a big statement
WHEN WRITING DATABASE QUERIES, 95% OF THE TIME THE BOTTLENECK IS IN THE I/O, not the CPU,...
2010-06-10
967 reads
A Guitar is Just a Piece of Wood
In my real-life I play guitar. Being an analytical sort-of-fella I found myself inhaling all the books, videos, advice, etc....
2010-06-08
660 reads
The Nature of the Database-Driven Developer
Bear with me as I wax philosophical for two sentences. Our societies are becoming more polarized with each passing day. ...
2010-06-03
681 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers