SQL Server test data generation testing tools
Question: How do I generate test data for SQL Server ? I don’t want to buy a benchmarking tool, but I...
2011-09-02
930 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
Mobile Commerce and SQL Performance Tuning
I was reading through Gartners Top Predictions and one prediction captured my attention:
“By 2014, over 3 billion of the world's...
2011-08-31
1,727 reads
Datawarehouse Trends – In-memory
What does the emergence and growth of In-memory databases mean for Datawarehouse?
1) In-Memory database server systems are fast. Consideration should be given to...
2011-08-30
1,719 reads
TRUNCATE_ONLY is not a recognized BACKUP option
Executing the code below in SQL Server 2008 will throw an error message:
BACKUP LOG ‘MyDatabase’ WITH TRUNCATE_ONLY
Msg 155, Level 15,...
2011-08-30
9,028 reads
Storage Checklist FAQ
In a new data centre build, storage system or new equipment, the DBA should have an input into the architecture...
2011-08-27
1,348 reads
Index Disabled and Index Rebuild
I received the following message from a Developer. The message was on a Test SQL Server
“NC_myIndex " on table "VeryLargeTable" (specified...
2011-08-25
1,740 reads
Correctness and stress test
Stress test SQL Server for new hardware
Download SQLIOSim from http://download.microsoft.com and install on server.
When detailing the file location , use the...
2011-08-24
709 reads
Disk IO performance and SQLIO
Performance testing a new disk subsystem from a SQL Server perspective is one of the fun aspects of DBA work....
2011-08-23
3,428 reads
Define IOPs for all database servers
Purpose
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me...
2011-08-22
2,107 reads
Attach database without log file and rename database
Assuming the database was detached successfully , this t-sql code will attach a mdf file without a log file . It will also...
2011-08-19
1,322 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
Forums
Compatibility levels on database changing them and impacts.
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers