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
A full storage chest beside an empty chest

Interview Question of the Week #006 – Is Shrinking Database Good or Bad?

February 8, 2015
Pinal Dave
SQL Interview Questions and Answers
Shrinking Database

Decide whether shrinking database good or bad advice fits your case, inspect fragmentation, and use low-priority shrink cautiously.

Read More
SQL SERVER - What are the Different Ways to Script Procedure with T-SQL

SQL SERVER – What are the Different Ways to Script Procedure with T-SQL

February 7, 2015
Pinal Dave
SQL Tips and Tricks
SQL Stored Procedure

What are the different ways to script procedure code with T-SQL? There are four, including sp_helptext and INFORMATION_SCHEMA.ROUTINES. Here is each one.

Read More
A letter slot seen from inside a front door, with a fine metal cage fitted behind it.

SQL SERVER – One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?

February 6, 2015
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts, SQL Server, SQL Server Security

SQL Injection is not a SQL Server problem, it comes from coding habits. Here is one trick of handling dynamic SQL to avoid SQL injection attack on a search page.

Read More
SQL SERVER - Invoking a Stored Procedure from Azure Mobile Services - Notes from the Field #066

SQL SERVER – Invoking a Stored Procedure from Azure Mobile Services – Notes from the Field #066

February 5, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, SQL Server Security

Can you call a SQL stored procedure from Azure Mobile Services? In Notes from the Field #066, Kevin Hazzard shows how, with a bit of humor along the way.

Read More
Request_max_memory_grant_percent.

SQL SERVER – How to fix the SQL Server Error 8657 or 8658?

February 4, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Error 8657 and 8658 appear when a query or columnstore index build needs more memory than its Resource Governor workload group allows. Here is the fix.

Read More
Table showing database names, start times, etc. for sqlauth.

SQL SERVER – Script – When/Who did Auto Grow for the Database?

February 3, 2015
Pinal Dave
SQL Tips and Tricks

A reader saw the database file grow every day with very few users. Here is a script to find when auto grow happened for a database and who triggered it.

Read More
Illustration for this post

SQL SERVER – How Can Deadlock Happen on Same Table?

February 2, 2015
Pinal Dave
SQL Tips and Tricks

How can deadlock happen on same table? A World Chess Championship match inspired this post, where I walk through how two sessions can block each other.

Read More
Blue flower trays selected from many greenhouse trays

Interview Question of the Week #005 – List All the Tables with Name Containing Specific String

February 1, 2015
Pinal Dave
SQL Interview Questions and Answers

Find SQL Server tables whose names contain a specific string, handle literal underscores, and include schemas without a date filter.

Read More
Soap slicing wire beside many thin bars and a few thick bars

Reads per Execution: Ranking Queries by Average I/O

January 31, 2015
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Monitoring, SQL Performance

The query with the most total reads is not always the one to tune first. Here is how to rank by cost per call and read the spread.

Read More
SQL SERVER - FIX - Error 3201 - Cannot open backup device. Operating system error 3

SQL SERVER – FIX – Error 3201 – Cannot open backup device. Operating system error 3

January 30, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

BACKUP DATABASE failed with Error 3201, cannot open backup device, operating system error 3. The cause was a missing default folder. Here is the fix.

Read More
Previous 1 … 273 274 275 276 277 278 279 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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