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
Illustrated cover: 5 Don'ts After Corruption

SQL SERVER – 5 Don’ts When Database Corruption is Detected

October 11, 2017
Pinal Dave
SQL Tips and Tricks
Database Corruption, SQL Backup and Restore, SQL Scripts, SQL Server

Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption. 

Read More
Two primary keys are each attached to a different physical index structure

How to Create Primary Key Without ANY Index? – Interview Question of the Week #143

October 8, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Constraint and Keys, SQL Scripts, SQL Server

Question: How to create primary key without ANY index? SQL Server builds a clustered or nonclustered index for every primary key, so here is the answer.

Read More
A plain measuring ruler beside two small wooden blocks and a blank notebook on a table.

Reading a Benchmark Somebody Else Published

October 6, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.

Read More
A compact folded fitting is compared with a larger assembly beside a constrained guide channel.

SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)

October 3, 2017
Pinal Dave
SQL Puzzle
SQL Function, SQL Scripts, SQL Server

This shortest code puzzle asks for 1000000000 without writing that literal or using arithmetic operators. The earlier zero puzzle brought roughly 700 valid answers.

Read More
A strong rope holds its weight while a weak rope has broken under the same test

How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142

October 1, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

SQL Server logins follow Windows password rules by default. If a login has it turned off, here is a simple script to Enforce Password Policy again.

Read More
Backups & Compression.

SQL SERVER – How to Enable Backup Compression On by Default

September 30, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

Tired of typing WITH COMPRESSION on every backup? Here is how to Enable Backup Compression on by default for the whole SQL Server instance.

Read More
Vacated clay recesses retain small traces beside a cleanup brush and an intact tray of finished tiles.

SQL SERVER – What Are Ghost Records and How to Clean Them Up?

September 28, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

Ghost Records are logically deleted index records waiting for physical cleanup. I investigate their context before recommending an intervention.

Read More
Previous 1 … 115 116 117 118 119 120 121 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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