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
932 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,729 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,036 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,747 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
710 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,431 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,109 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
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Was the index created or not?
Hi everyone I am getting an error when I create the index but I...
Question of the Day
Estimated Rows
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers