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 – FIX – Error 3702, Level 16, State 3 - Cannot Drop Database "DB_Name" Because it is Currently in Use

SQL SERVER – FIX – Error 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use

June 5, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Error 3702 says you cannot drop the database because it is currently in use, and even speakers get stuck on it. Here are simple ways to get past it.

Read More
Database properties window.

SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083

June 4, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server Security, SQL Statistics

Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.

Read More
SQL SERVER - Finding Out Identity Column Without Using Column Name

SQL SERVER – Finding Out Identity Column Without Using Column Name

June 3, 2015
Pinal Dave
SQL Tips and Tricks
SQL Identity

Did you know SELECT $identity finds the identity column without using column name? Here is how it works, and how to check if a table has one.

Read More
SQL SERVER - Errors and Limitations of Working with SPARSE Columns in SQL Server

SQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server

June 2, 2015
Pinal Dave
SQL Tips and Tricks
SPARSE Columns, SQL Error Messages

What is the catch with SPARSE columns? After a question at SQLBangalore UG, here are the errors and limitations of working with SPARSE columns.

Read More
Error in SQL Server Management Studio.

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

June 1, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Restoring a SQL Server 2008 R2 backup failed with Specified cast is not valid (SqlManagerUI). Here is what we found after a few emails and screenshots.

Read More
Gouache painting of a small green sprout in a clay pot on a sunny windowsill, with a vermilion watering can and a few blank seed packets beside it.

Interview Question of the Week #022: How to Get Started with Big Data?

May 31, 2015
Pinal Dave
SQL Interview Questions and Answers
Career Advice, Data Warehousing, Database

When an interviewer asks how you would get started with big data, a list of tools is the weakest answer. This post gives a short model answer: start from SQL, learn the core ideas, run one engine on a laptop and build one small project end to end.

Read More
Error message dialog for SQL Server.

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

May 30, 2015
Pinal Dave
SQL Tips and Tricks
SPARSE Columns, SQL Error Messages, SQL Scripts

A reader got Msg 511 when adding a sparse column. Sparse columns reduce the maximum row size from 8060 to 8018 bytes. Here is what that means for you.

Read More
Edition property window.

SQL SERVER – Using 20 Logical Processors Based on SQL Server Licensing

May 29, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

A friend saw SQL Server use only 20 of 64 processors in Task Manager. Here is how SQL Server licensing explains the limit of 20 logical processors.

Read More
Gouache painting of a small wooden workshop seen from the front, its door firmly closed in a slate-blue wall, a sage-green garden around it and one blank vermilion tag hanging from the door handle

Deep Work Time: Book It Like a Server Maintenance Window

May 28, 2015
Pinal Dave
Personal
Career Advice, DBA, Professional Development, Self Help

Deep work time disappears unless you book it. This post treats your own focus like a server maintenance window: a named block, a runbook, an emergency rule and a short review. Try two 90-minute windows this week.

Read More
An empty extended bicycle repair stand takes more floor space than an identical folded stand

Deleting From a Heap: Why Empty Pages Stay Behind

May 27, 2015
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Delete, SQL Heap

The rows are gone but the table is the same size and scans are just as slow. Here is why, and two ways to fix it.

Read More
Previous 1 … 261 262 263 264 265 266 267 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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