Use 100% Fill Factor on Insert Only Tables
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
798 reads
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
798 reads
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
336 reads
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
362 reads
Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.
2015-06-18
173 reads
A guest editorial from Andy Warren looks at the disagreements between teams in technology.
2015-06-17
203 reads
I’ll be driving up to speak to the Jacksonville SQL group on September 16, 2015 on database corruption. Meeting starts...
2015-06-17
365 reads
I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of...
2015-06-17
290 reads
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
460 reads
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
412 reads
Notes from the trip:
Made the trip down without stopping and without getting stuck in traffic – a first!Attended speaker dinner on...
2015-06-15
350 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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