GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
Storing Percentages: 0.15 or 15, and How to Tell Them Apart
Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.
SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training
We are launching public SQL Server 2005/2008 Query Optimization and Performance Tuning Training in Hyderabad, which I will lead, with a computer for everyone.
SQL SERVER – Attach mdf file without ldf file in Database
A friend sent me only his mdf file instead of a backup of the database. Here is how to attach mdf file without ldf file and let SQL Server build a new log.
Installing SQL Server Silently From the Command Line
Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.
SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online
A reader asked how to bring a database back online. This short T-SQL script will take database offline with ROLLBACK IMMEDIATE and then online again.
SQL SERVER – Update Statistics are Sampled By Default
A reader asked if statistics are sampled by default. They are, and a one million row test table proves it. You can set the rate up to 100%.
SQL SERVER – Create Primary Key with Specific Name when Creating Table
How do you create a primary key with specific name while creating the table itself? One CREATE TABLE statement can define and name the constraint.
When Are Statistics Updated? What Triggers an Automatic Update
Statistics updated automatically need two things: enough changed rows, and a query that uses the statistic. This post explains the old 500 plus 20 percent rule and the newer square root threshold, then shows a million-row demo where last_updated changes only after a query compiles. It also covers FULLSCAN, asynchronous updates and when to update by hand.
SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit
Does doubling the CPUs double the worker threads? No. Use sys.dm_os_sys_info to find Max Worker Count, and see the formula for 32 bit and 64 bit.










