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
A screenshot of a list of BAK files in a Windows File Explorer window.

SQL SERVER – 2008 – Introduction to New Feature of Backup Compression

July 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts

SQL Server 2008 adds Backup Compression. I back up AdventureWorks with and without compression, compare file sizes and show how to turn it on at server level.

Read More
SQL SERVER - 2008 - Insert Multiple Records Using One Insert Statement - Use of Row Constructor

SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor

July 2, 2008
Pinal Dave
SQL Performance
SQL Scripts

SQL Server 2008 lets you insert multiple records using one INSERT statement with a row constructor. I compare it with separate INSERTs and the UNION ALL method.

Read More
A sage ceramic jar and a dark glass ink bottle on folded cream cloth beside a brass magnifying glass and vermilion cord.

COLLATIONPROPERTY CodePage: Identify Text Encoding

June 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

COLLATIONPROPERTY CodePage reports varchar encoding metadata. Compare code pages 1252 and 65001 without confusing inspection with text conversion.

Read More
Matching blue bowls occupy the upper-left compartments of two wooden display frames.

DATEPART Quarter: Keep the Year Beside the Quarter

June 26, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Reports, SQL Scripts, SQL Server

DATEPART quarter identifies a calendar component. I keep its year when reporting separate periods. A cross-year January case shows how quarter-only grouping combines events.

Read More
One blank cream reference card beside a plain pencil and small paper clip on a wooden desk.

A One Page Reference for Everyday SQL Server Work

June 25, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.

Read More
SQL SERVER - Create Check Constraint on Column

SQL SERVER – Create Check Constraint on Column

June 22, 2008
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Error Messages, SQL Scripts

A junior developer wrote a trigger to block invalid data. A Check Constraint is simpler. My example limits PostalCode length in AdventureWorks and tests it.

Read More
SQL Server query for SQL Server2.

SQL SERVER – Find Current Identity of Table

June 20, 2008
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server DBCC

Many developers use MAX() to find the current identity of a table. I prefer DBCC CHECKIDENT, which reports the current identity value directly.

Read More
Previous 1 … 308 309 310 311 312 313 314 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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