TPC-E Benchmark Analysis by CPU Type
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,280 reads
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,280 reads
Since it is almost January 2011, I thought I would post the January 2011 versions of the SQL Server 2005...
2010-12-29
2,278 reads
This is a subject I have written about a couple of times before, here and in much more depth here. ...
2010-12-29
1,151 reads
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction...
2010-12-28
2,921 reads
Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the...
2010-12-27
558 reads
If you are in the market to buy or build a new laptop or desktop computer, you might want to...
2010-12-22
713 reads
Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday,...
2010-12-22
852 reads
Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as...
2010-12-22
1,918 reads
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 5 (CU5), which is Build 1753. I count 40 separate...
2010-12-21
888 reads
Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 (SP4) for SQL Server...
2010-12-20
796 reads
Next Monday, March 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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