SELECT INTO copies most column attributes to a new table, but not all. Here is proof that the SPARSE property does not carry forward using SELECT INTO.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1
The SQL Server service would not start for a DBA fresh out of college. The cause was Error 5118, and here is how to read it and fix it.
Interview Question of the Week #024 – What is the Best Recovery Model?
Choose the best recovery model from your restore requirements, understand bulk-logged limits, and verify the backup chain and log reuse.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – How Many Line of Code Do You Have in Database?
After the first SQLSaturday in Sri Lanka, here is a question worth a script: how many lines of code do you have in your database? Here is a way to count them.
SQL SERVER – The Basics of the Execute Process Task – Notes from the Field #084
Andy Leonard explains the basics of the SSIS Execute Process Task, used to start a custom application or run an operating system command from a package.
Who Changed This Row? Auditing Data Changes
Auditing data changes requires choosing whether you need old values, new values, actor identity, or a change feed, then testing the cost.
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.