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
SQLCMD tool window.

SQL SERVER – The Story of a Lesser Known Startup Parameter in SQL Server – Guest Post by Balmukund Lakhani

June 10, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Balmukund Lakhani turns his popular SQL Bangalore UG session into a guest post: the story of the -m startup parameter and a lesser known way to use it.

Read More
A fluting iron shaping one pleat while the other pleats remain untouched

Rebuilding One Partition Online Instead of the Whole Index

June 9, 2013
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Server, Table Partitioning

A big partitioned table does not need a full index rebuild every night. Here is how to rebuild one partition safely.

Read More
A cat with a red collar passes through a cat flap while a stray waits outside.

Enforcing Object Naming Rules With a DDL Trigger

June 8, 2013
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Server, SQL Trigger

Enforce procedure and index names with a DDL trigger, inspect EVENTDATA, audit rejected attempts, and list existing violations.

Read More
SQL SERVER - QUOTED_IDENTIFIER ON/OFF Explanation and Example - Question on Real World Usage

SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage

June 7, 2013
Pinal Dave
SQL Tips and Tricks

Six years after my first post, a follow up on QUOTED_IDENTIFIER ON/OFF with a quick example of double quotes in identifiers and a real world question.

Read More
Three small cleanly cut wooden joints side by side on a workshop bench, with a curl of wood shaving beside them.

Building a Portfolio as a Data Professional

June 6, 2013
Pinal Dave
SQL Tips and Tricks
Career Advice, DBA, Developer, Professional Development

A data professional portfolio should show a few complete projects, clear write-ups, and runnable code that explains decisions and tradeoffs.

Read More
camera

SQL SERVER – SQL in Sixty Seconds – Need Your Opinion

June 5, 2013
Pinal Dave
SQL Video
SQL in Sixty Seconds

Though this may look very simple to you it is very crucial to me and I would like to know your opinion about it. I have included the latest video.

Read More
Image of database table.

SQL SERVER – Script to Update a Specific Column in Entire Database

June 4, 2013
Pinal Dave
SQL Tips and Tricks
SQL Joins

A reader added a ModifiedDate column to every table and left it NULL. Here is a script to update a specific column in the entire database at once.

Read More
A fresh photo print of a runner at the finish hanging to dry by a red clip in a darkroom

The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice

June 3, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL DMV, SQL Server, SQL Server 2019

Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.

Read More
A private path through a hedge to a red side gate, the front door shut

Connecting to SQL Server From Home Without Exposing Port 1433

June 2, 2013
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Server, SQL Server Encryption, SQL Server Security

Keep port 1433 off the public internet by checking external reachability and using VPN, a jump host, Bastion, and trusted encryption.

Read More
A glass vase of beans in colored layers, a scoop from the top holding only red beans.

TABLESAMPLE Samples Pages, Not Rows: Sampling a Large Table Right

June 1, 2013
Pinal Dave
SQL Tips and Tricks
SQL Random, SQL Scripts, SQL Server

Compare TABLESAMPLE page sampling with NEWID sorting and CHECKSUM filters by row count, reads, spread, and repeatability.

Read More
Previous 1 … 338 339 340 341 342 343 344 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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