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 fabric pouches and their zipper pulls preserve different open and closed positions

Disabling All Agent Jobs During a Freeze and Restoring Their State

January 4, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Monitoring, SQL Server Agent

Enable-all after a freeze wakes up jobs that were off on purpose. Save the starting state and put back exactly that.

Read More
A hand tapping an old barometer on a farmhouse hallway wall, a field and changing sky through the open door.

Reading DBCC SHOW_STATISTICS Step by Step

January 3, 2014
Pinal Dave
SQL Performance
Execution Plan, SQL Server, SQL Server DBCC, SQL Statistics

Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.

Read More
Server Name Messages Name Dsid Status Statusdate Cudate Reserved CMPS.

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009

January 2, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

John Sterrett shows how Central Management Server lets a DBA run the same query on many SQL Server instances at once, a handy tool for proactive DBAs.

Read More
An egg carton with some empty cups kept in place and one red painted egg

Counting Rows per Month With Zero-Filled Gaps

January 1, 2014
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Joins, SQL Reports, SQL Server

Build monthly counts with zero-filled gaps, generate a complete month range, and retain empty categories through a reporting scaffold.

Read More
A single swallow on a fence wire above a frosty field in early spring, the rest of the wire empty

Ranking Items by Rating Fairly With a Bayesian Average

December 31, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Ranking Functions, SQL Server

Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.

Read More
SQL SERVER - MySQL - LIMIT and OFFSET - Skip and Return Only Next Few Rows - Paging Solution

SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution

December 30, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts, SQL Server

Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.

Read More
SQL SERVER - MySQL - PostgreSQL - How to Concat Strings?

SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?

December 29, 2013
Pinal Dave
SQL Tips and Tricks
MySQL, PostgreSQL, SQL Function, SQL Scripts, SQL Server

How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.

Read More
Black glasses with the joke: Why do Java developers wear glasses? Because they don't C#.

Developer – 10 Phrases Developer Use Too Often

December 28, 2013
Pinal Dave
SQL Tips and Tricks
Professional Development, SQL Server

I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.

Read More
SQL Server delimiter action window.

MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL

December 27, 2013
Pinal Dave
SQL Tips and Tricks
MySQL

Copied a SQL Server script with GO into MySQL and got an error? Here is how to change delimiter in MySQL so it accepts GO as a statement terminator.

Read More
An open doctor's bag on a hall table with a blood pressure cuff and a red reflex hammer inside

SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health

December 26, 2013
Pinal Dave
SQL Tips and Tricks
Notes from the Field

How did Notes from the Field start? Here is the story behind the series and a roundup of the 2013 episodes on performance tuning and database health.

Read More
Previous 1 … 316 317 318 319 320 321 322 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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