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
Two wooden metronomes side by side on a shelf, their pendulums swinging at different tempos

Scheduling Recurring Events: Every Second Tuesday in T-SQL

February 12, 2019
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Generate recurring events with stable weekday arithmetic, monthly ranking, and anchored fourteen-day rules instead of endless date rows.

Read More
Two alternative measuring jigs remain beside a held joint for a temporary comparison.

SQL SERVER – Enabling Older Legacy Cardinality Estimation

February 9, 2019
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration, SQL Statistics

Legacy Cardinality Estimation temporarily stabilized one customer memory-grant problem. A query waited on RESOURCE_SEMAPHORE while the instance became unresponsive.

Read More
Gouache painting of three hats on stands with the chosen one painted vermilion

Current Language of a SQL Server Session: How to Check It

February 8, 2019
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

To find the current language of a SQL Server session, read @@LANGUAGE or @@LANGID, or query sys.dm_exec_sessions. This post tests each one, switches the session to German and British, and shows how the language changes month names and how text turns into dates.

Read More
SQL SERVER - Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?

SQL SERVER – Availability Group Seen in SSMS but missing in Cluster Manager. What’s Wrong?

February 6, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Management Studio

A client’s availability group showed in SSMS, but no role appeared in Failover Cluster Manager. Here is the sequence of steps that causes this and what to do.

Read More
Four sorting channels deliver different-sized walnut heaps into separate compartments

Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211

February 3, 2019
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, Parallel, SQL Scripts, SQL Server, SQL Statistics

Do parallel threads process equal rows? Usually no, and a simple AdventureWorks query with its actual execution plan proves it in a few seconds.

Read More
Deployment Target Version.

SQL Server Integration Services (SSIS) – There Was an Exception While Loading Script Task from XML

January 29, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL XML, SSIS

An SSIS package ran fine in Visual Studio but failed as a SQL Agent job: There was an exception while loading Script Task from XML. Here is why and the fix.

Read More
Two sealed envelopes on a tray illustrate why verification matters

What is Trusted Constraint in SQL Server? – Interview Question of the Week #210

January 27, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL Performance, SQL Scripts, SQL Server

What is a trusted constraint in SQL Server? Many experts do not know, so instead of a definition I explain it with a simple check constraint example.

Read More
Previous 1 … 79 80 81 82 83 84 85 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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