What Would You Like to See in a New Book on Indexing?
I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...
2010-01-20
418 reads
I am currently in the early stages of writing an outline for a new book on indexing, targeted towards novice...
2010-01-20
418 reads
My new eBook, Brad’ Sure Guide to SQL Server Maintenance Plans is now available as a free, 269 page PDF...
2010-01-14
1,777 reads
Not every DBA has the time to sit down and spend a couple of hours learning about some new topic...
2010-01-14
438 reads
When you create a SQL Server Maintenance Plan using the Maintenance Plan Wizard or the Maintenance Plan Designer, the SQL...
2010-01-13
1,593 reads
The PASS SQL Server Standard has published a new article called “Busting 6 SQL Server Failover Clustering Myths”, by Kathi...
2010-01-13
379 reads
Reprinted from my editorial in Database Weekly.
In the course of my job, I get to give a lot of presentations,...
2010-01-11
366 reads
The SSMS maintenance plan wizard is shunned by many DBAs, but Brad McGehee has come to view it as a perfectly valid and viable tool, especially for part-time or accidental DBAs, or those just finding their feet in the role.
2010-01-11
248 reads
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008.
I think most of us are...
2010-01-05
1,908 reads
Since I wrote the first part of this blog series, SQLServerCentral.com (SSC) SQL Servers have been upgraded, and performance is...
2010-01-03
893 reads
I have always liked information presented to me in lists. Lists are simple, straight-forward, and to the point. If you...
2009-12-23
626 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers