Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are...
2011-11-01
734 reads
SQL RNNR
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up...
2011-11-01
11 reads
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about...
2011-10-31
1,918 reads
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about it, I wanted to try to better understand if...
2011-10-31
2 reads
October 2011 LV UG Meeting Update
This is a republish due to a last minute change!!!
We had to reschedule the October meeting due to unforeseen circumstances....
2011-10-18
504 reads
October 2011 LV UG Meeting Update
This is a republish due to a last minute change!!! We had to reschedule the October meeting due to unforeseen circumstances. The only change is the date of the...
2011-10-18
5 reads
Reach for the Select *s
Do you have your head in the clouds?
Have you wanted to take flight?
Have you been called “Space Case”
If you are...
2011-10-12
724 reads
Reach for the Select *s
Do you have your head in the clouds? Have you wanted to take flight? Have you been called “Space Case” If you are a DB Professional, then all of...
2011-10-12
5 reads
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it...
2011-10-12
646 reads
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it was somewhat peculiar, I decided I would share the...
2011-10-12
4 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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