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
934 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,731 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,721 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,082 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,349 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,759 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
711 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,435 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,110 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,323 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers