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 pressing clay into a wooden brick mold beside a row of identical fresh bricks drying

Keeping Admin Scripts One Click Away in SSMS Template Explorer

August 18, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility

Organize SSMS Template Explorer scripts, fill reusable parameters, review a copy-only backup, and preserve custom templates on disk.

Read More
A tall metal garden gate with a key hanging on a red tassel beside it, and a quiet courtyard of doors beyond.

Logins and Users in SQL Server: Who Gets In and What They Can Do

August 16, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Login, SQL Scripts, SQL Server Security

Logins and users are two different things in SQL Server. A login gets a person or an application into the server, and a user gets them into one database. This post explains Windows and SQL authentication, how a login maps to a user, and how to check the mapping with a query.

Read More
Two wall shelves of glass jars, each jar holding a different grain, lentil or bean, one jar with a red lid.

What Are Filegroups in SQL Server and When to Use Them

August 15, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Data Storage, SQL Scripts, SQL Server Architecture

What are filegroups in SQL Server? A filegroup is a named container for data files, and an ordinary table or index lives in exactly one. This post builds a small demo, shows where a table lands, and gives honest advice on when extra filegroups help and when they only add work.

Read More
A small metal press with a red handle beside a row of leaf shapes cut from clay, one leaf colored red.

SQL Code Generators: Let SSMS Write the Script for You

August 12, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server Management Studio, SQL Table Operation

SQL Code Generators in SSMS turn clicks into T-SQL. This post shows the Script button on dialogs, the Generate Scripts wizard and Select Top 1000 Rows, plus the checks I run before I trust a generated script.

Read More
An open wooden toolbox on a bench with a pair of pliers inside and a small blank paper tag tied on with red string.

SQL Code Comments: Notes Your Future Self Can Read

August 9, 2013
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Scripts, SQL Server Management Studio, Starting SQL

SQL Code Comments are the notes SQL Server skips and your teammates read. This post shows the two comment styles, what is worth writing in them, a header block for scripts and procedures, and how to stop a comment from lying after the code changes.

Read More
Two small wooden blocks are joined by one simple brass latch on an oak table.

Keeping ACID Across More Than One Server

August 8, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Understand a distributed transaction through two-phase commit, uncertain outcomes, coordinator recovery, and alternative business guarantees.

Read More
A pale jigsaw puzzle with one red piece fitting into the gap and two loose gray pieces lying to the side.

Joining Tables in SQL Server: INNER, LEFT and FULL Joins

August 8, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Joins, SQL NULL, SQL Scripts, SQL Table Operation

Joining Tables lets one query combine rows from two tables that share a value. This post uses small Customers and Orders tables to show what INNER, LEFT and FULL OUTER joins return, how many rows each one gives, and how to read the rows that have no match.

Read More
Previous 1 … 183 184 185 186 187 188 189 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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