Can a temp table have indexes? Yes. In Part 2 of #TempTable vs @TempVariable, I explain how temporary table indexes live in TempDB and when they help.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER 2005 – Microsoft Will Release SP3 Soon
Is Microsoft going to release SP3 for SQL Server 2005? Yes, SP3 is coming very soon. The exact date is not announced yet, but the announcement is out.
SQL SERVER – Function Property – Deterministic or Non-Deterministic
How do you tell if a user defined function is deterministic or non-deterministic? One OBJECTPROPERTY call with IsDeterministic gives you the answer.
SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server
Roy Cheung hit Error 7311 running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server, and shared the fix.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
Joffery improved my script to find tables with foreign key constraint in a database, adding the ON UPDATE and ON DELETE rules and a little ordering.
SQL SERVER – Create Database Error in Windows Vista
A reader on Vista got a create database error, Msg 262 CREATE DATABASE permission denied in database master. The fix is the same one from my earlier post.
SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
My Vista Windows Authentication login failed with Error 18456 after installing SQL Server 2005, while sa worked. Adding my login as administrator fixed it.
SQL Server slow? Let's fix it together in about four hours.
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 18 SQL Server database 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.

