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 - Denali - Introduction to SEQUENCE - Simple Example of SEQUENCE

SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE

January 29, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A quick introduction to SEQUENCE in SQL Server Denali: create a sequence with start, increment and max values, then fetch numbers with NEXT VALUE FOR.

Read More
A receiving trough distributes small pieces through several separate channels into independent trays.

SQL SERVER – Reducing Page Contention on TempDB

January 26, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB

Page Contention on TempDB needs an identified allocation wait and server version. I check both before recommending legacy trace flags.

Read More
Gouache painting: a cream garment bag hangs from a wooden wardrobe rail, unzipped halfway so a slate-blue jacket shows clearly inside

FOR XML PATH: Decode Escaped Text Through TYPE

January 24, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL String

FOR XML PATH escapes reserved characters. Use TYPE and scalar extraction to recover text instead of manually replacing entity spellings.

Read More
SQL SERVER- Differences Between Left Join and Left Outer Join

SQL SERVER- Differences Between Left Join and Left Outer Join

January 22, 2011
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts

Is there any difference between LEFT JOIN and LEFT OUTER JOIN? A reader asked, and here is the short answer: none at all, they are the same.

Read More
SQL SERVER - Shrinking Database is Bad - Increases Fragmentation - Reduces Performance

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

January 19, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

Shrinking database is bad: it increases fragmentation and reduces performance. Here is a simple example with two tables that shows it step by step.

Read More
SQL SERVER - Quick Look at SQL Server Configuration for Performance Indications

SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

January 14, 2011
Pinal Dave
SQL Performance
SQL Scripts

Part two of my SQL Server Magazine series is a quick look at SQL Server configuration for performance and the settings I check first with new clients.

Read More
SQL SERVER - A Quick Note on DB_ID() and DB_NAME() - Get Current Database ID - Get Current Database Name

SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name

January 13, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A quick note on DB_ID() and DB_NAME(): how to get current database name and ID, and how to turn a database ID into a name and back again.

Read More
Previous 1 … 237 238 239 240 241 242 243 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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