A reader congratulated me on my 300th post with a funny image, a valid SQL error that fits right in with my posts about SQL Server errors.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel
Ben Nadel, my favorite ColdFusion blogger, wrote two clear articles on using a SQL JOIN in UPDATE and DELETE statements. Both are worth a read.
SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
A script to find tables with primary key constraint in a SQL Server 2005 database, listing the index name, table name and column name from sys.indexes.
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
Keys are critical to any database. This script finds every table with a foreign key constraint in SQL Server 2005, with its column and the referenced table.
SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
How to search stored procedure code in SQL Server 2005 for a table or column name, using sys.procedures and OBJECT_DEFINITION instead of sp_depends.
SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.
SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX
Find database status such as ONLINE, OFFLINE, RESTORING or SUSPECT using sys.databases or DATABASEPROPERTYEX, and learn what each status means.
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.