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
Aug11

SQL SERVER – UDF – Validate Integer Function

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts
8 Comments

ISNUMERIC() returns 1 for plus, minus and currency signs, so it is not a safe check. I share the UDF I use to validate integer values instead.

Continue Reading
Aug10

SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL System Table
100 Comments

A simple script on sys.objects that shows the stored procedure create date and modified date, handy for audits and for watching changes to your objects.

Continue Reading
Aug9

SQL SERVER – 2005 – List All The Column With Specific Data Types

Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Scripts, SQL System Table
65 Comments

A handy script to list all columns with specific data types in a database. We used it to find TEXT columns and change them to VARCHAR(MAX) in SQL Server 2005.

Continue Reading
Aug8

SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property

Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Server Management Studio, SQL Utility
11 Comments

How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.

Continue Reading
Aug7

SQL SERVER – 2005 – List Tables in Database Without Primary Key

Pinal Dave
SQL Tips and Tricks
Database, SQL Constraint and Keys, SQL Scripts, SQL System Table
28 Comments

A simple script to list tables in database without primary key, using sys.tables and OBJECTPROPERTY TableHasPrimaryKey in SQL Server 2005.

Continue Reading
Aug6

SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server DBCC
4 Comments

Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.

Continue Reading
Aug5

SQL SERVER – Stop SQL Server Immediately Using T-SQL

Pinal Dave
SQL Tips and Tricks
SQL Scripts
7 Comments

Need to stop SQL Server immediately? Run SHUTDOWN, or SHUTDOWN WITH NOWAIT to skip checkpoints. I also note which roles have permission to run it.

Continue Reading
Previous 1 … 798 799 800 801 802 803 804 … 839 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 120 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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