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
Hands fitting a new wider slat into an old park bench, the old slat leaning beside it

Changing an Index In Place With CREATE INDEX and DROP_EXISTING

May 20, 2012
Pinal Dave
SQL Performance
Clustered Index, DBA, SQL Index, SQL Server

Use DROP_EXISTING to change an index definition in one operation, inspect its columns, and check online availability and dependencies.

Read More
Highlighted datetime2 value.

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST

May 19, 2012
Pinal Dave
SQL Puzzle
SQL DateTime

A Saturday fun puzzle with DATETIME2 and CAST in SQL Server 2012. Run each script one at a time, guess the output, and learn something new.

Read More
Gouache painting of a new rowing boat with wide oarlocks and two old oars against the wall, one painted red

Deprecated Features and Breaking Changes: Plan Your Upgrade

May 18, 2012
Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Deprecated Feature, SQL Upgrade

Breaking Changes are only one of four kinds of change that an upgrade brings. This guest post by Nakul Vachhrajani explains the four kinds, how to find deprecated feature use with Extended Events and the Deprecated Features counters, and a checklist for planning the upgrade.

Read More
A finished stone bridge beside an old wooden bridge over a river, workers placing the last span to meet the road

Upgrading With Log Shipping for a Short Cutover

May 17, 2012
Pinal Dave
SQL Tips and Tricks
DBA, Log Shipping, SQL Backup and Restore, SQL Upgrade

Upgrading with log shipping stages a newer secondary with NORECOVERY, applies logs in order, and leaves a short, rehearsed final cutover.

Read More
Five lesson rows with their results: error 2627 caught and thrown again, a procedure that returned 11,200.00 while a direct SELECT failed with 229, tea found on slips 1 and 3, the breadcrumb Library > Garden > Herbs > Basil, and a hint that cut reads from 5,740 to 318

SQL Server Lessons: Five Short Scripts You Can Run in a Minute

May 16, 2012
Pinal Dave
SQL Tips and Tricks
CTE, Query Hint, SQL Server Security, SQL XML

SQL Server lessons stick when you can run them in a minute. This page covers errors, security, XML, hierarchies and query hints. Each lesson asks one question and answers it with a short script. Every result comes from SQL Server 2025.

Read More
SQL SERVER - Get Schema Name from Object ID using OBJECT_SCHEMA_NAME

SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME

May 15, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

Many people join sys.tables and sys.schemas to get a schema name from an object ID. The OBJECT_SCHEMA_NAME function does it in one simple call.

Read More
SQL SERVER - Columnstore Index and sys.dm_db_index_usage_stats

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats

May 14, 2012
Pinal Dave
SQL Performance
ColumnStore Index, SQL DMV, SQL Index, SQL Scripts, SQL Server

My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.

Read More
Glazed tiles sorted into tall single-color stacks in a workshop, a hand lifting the whole blue stack from the row.

Columnstore Indexes for Reporting Tables

May 13, 2012
Pinal Dave
SQL Performance
ColumnStore Index, Data Warehousing, SQL Index, SQL Performance, SQL Server

Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.

Read More
An adjustable curtain rod aligns repeated mounting holes before the curtains are fitted

Filling Template Parameters in SSMS With Ctrl+Shift+M

May 12, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Variable

Template parameters save you from typing one value in four places, but they only paste text. Here is what that means in practice.

Read More
A pottery rib shapes a clay vessel beside a trimmed clay strip and a newly attached clay handle

XML modify(): Inserting, Replacing and Deleting Nodes

May 11, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Table Operation, SQL Variable, SQL XML

The modify() method edits XML in place, but a path that matches nothing changes nothing and says nothing. Here is how to stay in control.

Read More
Previous 1 … 377 378 379 380 381 382 383 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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