This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - GUID vs INT - Your Opinion

SQL SERVER – GUID vs INT – Your Opinion

April 28, 2010
Pinal Dave
SQL Performance
SQL Constraint and Keys, SQL Data Storage

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.

Read More
Rich still life with two differently sized glasses partly filled with sage liquid, an ivory pitcher and slate tray.

Storing Percentages: 0.15 or 15, and How to Tell Them Apart

April 27, 2010
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Constraint and Keys, SQL Datatype, SQL Server

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.

Read More
A lecture hall of empty wooden fold-down seats facing a freshly washed blackboard.

SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training

April 26, 2010
Pinal Dave
SQLAuthority News
SQL Server, SQL 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.

Read More
SQL SERVER – Attach mdf file without ldf file in Database

SQL SERVER – Attach mdf file without ldf file in Database

April 26, 2010
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts

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.

Read More
A pottery kiln working on its own in an empty studio at night

Installing SQL Server Silently From the Command Line

April 25, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, DBA, PowerShell, SQL Server Installation, SQL Setup

Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.

Read More
SQL SERVER - T-SQL Script to Take Database Offline - Take Database Online

SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online

April 24, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts

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.

Read More
SQL SERVER - Update Statistics are Sampled By Default

SQL SERVER – Update Statistics are Sampled By Default

April 23, 2010
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Statistics

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

Read More
SQL SERVER - Create Primary Key with Specific Name when Creating Table

SQL SERVER – Create Primary Key with Specific Name when Creating Table

April 22, 2010
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

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.

Read More
Gouache painting of a balance scale with apples and a small red basket collecting the apples that changed

When Are Statistics Updated? What Triggers an Automatic Update

April 21, 2010
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Statistics

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.

Read More
Max worker threads window.

SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit

April 20, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table

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.

Read More
Previous 1 … 458 459 460 461 462 463 464 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com