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...

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...

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...

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,...

Storage Checklist FAQ

In a new data centre build, storage system or new equipment, the DBA should have an input into the architecture...

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...

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...

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....

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...

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...