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
Hands tipping a large milk churn over a small teacup, milk flooding the table, a tiny cream jug unused

SELECT * in Production Code: The Hidden Costs

April 18, 2011
Pinal Dave
SQL Performance
SQL Coding Standards, SQL Index, SQL Server, SQL View

See the real costs of SELECT * in production code: lost covering indexes, lookups, stale view metadata, broken inserts and wider results.

Read More
SQL SERVER - Applying NOLOCK Hint at Query Level - NOLOCK for whole Transaction

SQL SERVER – Applying NOLOCK Hint at Query Level – NOLOCK for whole Transaction

April 17, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Can you apply the NOLOCK hint to a whole query with OPTION (NOLOCK)? No, it fails with Msg 102. Here is how I use an isolation level instead.

Read More
An open ledger on a reading stand with a thin sheet of glass laid over the pages.

SQL SERVER – Making Database to Read Only – Changing Database to Read/Write

April 16, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

A reader attached a client database and it showed as Read Only. Two simple ALTER DATABASE scripts switch a database to READ_ONLY and back to READ_WRITE.

Read More
SQL SERVER - Finding Location of Log File when Primary Datafile is Crashed

SQL SERVER – Finding Location of Log File when Primary Datafile is Crashed

April 15, 2011
Pinal Dave
SQL Puzzle
SQL Scripts

Do you need the primary datafile to back up the log after a crash? Vinod Kumar asked, so I tried finding the location of the log file without it.

Read More
InMemory Table.

SQL SERVER – Transaction Log Impact Detection Using DMV – dm_tran_database_transactions

April 14, 2011
Pinal Dave
SQL Tips and Tricks

Which DMV shows the effect of a transaction on the transaction log file? My quick script uses dm_tran_database_transactions to show it per transaction.

Read More
SQL SERVER - FIX - ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)

April 13, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Server

Msg 3201, cannot open backup device, operating system error 5 (Access is denied). The SQL Server service account needed permission on the disk.

Read More
Recent queries list.

SQL SERVER – Query to Recent Query on Server with Execution Plan Function to Get SQL

April 12, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

For T-SQL Tuesday on the APPLY clause, I share the script I use to see each recent query on server along with its execution plan from the cache.

Read More
A goods receiving bench with an unopened crate on one side, sorted and labelled parts in the middle, and a filled storage rack behind

What Is ETL? Extract, Transform and Load Explained

April 11, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

ETL means extract, transform and load, and only the middle word is interesting. What each stage really does, why transform eats most of the schedule, and what changes when a team says ELT instead.

Read More
A finite ceramic reservoir supplies two vessels through separate connected spouts.

SQL SERVER – TempDB in RAM for Performance

April 10, 2011
Pinal Dave
SQL Performance
SQL Server, SQL TempDB

TempDB in RAM needs a review of capacity, support and memory pressure. I compare those costs with the bottleneck it would address.

Read More
SQL SERVER - Add New Column With Default Value

SQL SERVER – Add New Column With Default Value

April 9, 2011
Pinal Dave
SQL Tips and Tricks

A developer used three statements to add a column, fill it and make it NOT NULL. One ALTER TABLE can add a new column with default value in one step.

Read More
Previous 1 … 421 422 423 424 425 426 427 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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