A client’s DBA disabled every clustered index before a bulk insert, and the application stopped working. What happens when you disable clustered index?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
Storing Percentages: 0.15 or 15, and How to Tell Them Apart
Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.
SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training
We are launching public SQL Server 2005/2008 Query Optimization and Performance Tuning Training in Hyderabad, which I will lead, with a computer for everyone.
SQL SERVER – Attach mdf file without ldf file in Database
A friend sent me only his mdf file instead of a backup of the database. Here is how to attach mdf file without ldf file and let SQL Server build a new log.
Installing SQL Server Silently From the Command Line
Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.
SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online
A reader asked how to bring a database back online. This short T-SQL script will take database offline with ROLLBACK IMMEDIATE and then online again.
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.