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
927 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,724 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,718 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
8,857 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,663 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
703 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,417 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,105 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,320 reads
Blogs
SQL Server Performance – What IT Leaders Need to Know
By Kevin3NF
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping...
FREE Window Functions Course (This Month Only!)
Want to really level up your SQL game? I mean, go from good to great? This March...
Tally Table Alternatives: #SQLNewBlogger
By Steve Jones
We published an article recently at SQL Server Central on Tally Tables in Fabric...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Multiple Sequences
Comments posted to this topic are about the item Multiple Sequences
Using SQL Server Stored Procedures with the Django ORM
Comments posted to this topic are about the item Using SQL Server Stored Procedures...
Question of the Day
Multiple Sequences
In SQL Server 2022, I run this code:
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GO CREATE TABLE NewMonthSales (SaleID INT , SecondID int , saleyear INT , salemonth TINYINT , currSales NUMERIC(10, 2)); GO INSERT dbo.NewMonthSales (SaleID, SecondID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO SELECT * FROM dbo.NewMonthSales AS nmsAssume the dbo.MonthSales table exists. If I run this, what happens? See possible answers