SQL Server 2008 Data Compression Example
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,291 reads
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,291 reads
Since the release of SQL Server 2008, a slew of new books have been released, or are about to be...
2008-10-30
1,725 reads
Microsoft's free SQL Server Health & History tool (SQLH2) has had a minor update and can now be used with SQL...
2008-10-21
2,269 reads
As I travel and visit DBAs from around the United States, I am always surprised at the job titles DBA...
2008-10-16
638 reads
Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that...
2008-10-15
625 reads
A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server...
2008-10-11
561 reads
The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday....
2008-10-09
440 reads
I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA,...
2008-10-07
1,004 reads
If you have ever considered taking a leadership role in PASS, you should seriously consider becoming a SQL PASS board...
2008-10-07
415 reads
Just got back from attending IndyTechFest in Indianapolis, IN, which was held on Saturday, October 4, 2008, and had nearly...
2008-10-06
704 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