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 - What are Actions in SSAS and How to Make a Reporting Action

SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action

June 6, 2014
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services

SSAS actions let users open a report, a web page or drill through from cube data. Here is what actions are and how to build a Reporting Action step by step.

Read More
SQL SERVER - Planned and Unplanned Availablity Group Failovers - Notes from the Field #031

SQL SERVER – Planned and Unplanned Availability Group Failovers – Notes from the Field #031

June 5, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL High Availability, SQL Scripts, SQL Server

In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.

Read More
Gouache painting of a wooden library card catalog with one long drawer pulled open, its cards standing in neat order, one tab in vermilion

Explain a SQL Server Index in Sixty Seconds, Then Prove It

June 4, 2014
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts

How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.

Read More
A hand taking one plate from a spare boxed set to fill the single empty slot in a kitchen plate rack.

Restoring One Table: Restore a Copy and Move the Rows Back

June 3, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Scripts, SQL Server

Learn restoring one table by restoring a separate database copy, choosing a recovery point, and safely moving reviewed rows back.

Read More
Slim bicycle beside its detached bulky canvas pannier

Vertical Partitioning: Moving Rarely Used Columns Off a Hot Table

June 2, 2014
Pinal Dave
SQL Tips and Tricks
Normalization, SQL Data Storage, SQL Performance

Moving rarely used columns to a side table can cut reads, or change nothing. Here is how to measure it and what it costs your writes.

Read More
Matching cultivator bars hold three teeth and two teeth, with one mounting position empty

Casting JSON Arrays to the vector Type for Embeddings

June 2, 2014
Pinal Dave
SQL Tips and Tricks
JSON, SQL Datatype, SQL Server

A cast checks the count of numbers, not the model they came from. Here is a simple staging pattern that loads good rows and reports the rest.

Read More
Bronze oarlock supporting an oar beside a loose metal ring

NT SERVICE Accounts in sysadmin: What They Are For

June 1, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Agent, SQL Server Security, SQL Server Services

A security scan wants those service logins gone. Here is how to see what each one is for before you click Delete.

Read More
MySQL - Introduction to User Defined Variables

MySQL – Introduction to User Defined Variables

May 31, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

MySQL user defined variables let you store a value and use it later in your query, with no data type to declare. Here is how to set and read them.

Read More
SQL SERVER - Merge Two Columns into a Single Column

SQL SERVER – Merge Two Columns into a Single Column

May 30, 2014
Pinal Dave
SQL Tips and Tricks

A reader wanted to merge two columns into a single column that lists all values from both. Here is the simple query I suggested for the task.

Read More
SSIS Catalog Message Window.

SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030

May 29, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SQL Scripts, SSIS

The SSIS Catalog captures a lot of cool information by default. Andy Leonard shares the query he uses for parsing SSIS Catalog messages in SSISDB.

Read More
Previous 1 … 300 301 302 303 304 305 306 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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