Introduction to Memory configuration
Introduction to Memory configuration Yesterday I was discussion with one of my friend on memory management and internals to expertise in...
2010-05-16
689 reads
Vinay Thakur
Audio Webcast – Whats News
Yesterday I though of doing an audio webcast what all I blog. So started audio webcast, its a series of...
2010-05-12
702 reads
Performance Tunning -Checklist
continue with performace tunning stuff, I would like to make a checklist (kind of) for general performance tunning or dba...
2010-05-06
1,122 reads
TempDB Internals
TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...
2010-05-01
1,860 reads
New Blog Location
Hi Friends.Thanx for your support. for this year onwords I will be bloging on my own website....Hope to see you...
2010-01-08
527 reads
2010-01-04
4,257 reads
2009-12-29
2,799 reads
Error Log:
Following steps happened when sql server starts… we can see that in error log::
1. Build of sql server and...
2009-12-25
665 reads
Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,463 reads
Transactional Replication Conversations –Must read
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,146 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