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
A tall hourglass on a windowsill, the upper bulb full of sand and a thin stream falling through the narrow neck.

Making SSIS Packages Faster

January 13, 2013
Pinal Dave
SQL Performance
ETL, SQL Performance, SQL Server, SSIS

Make SSIS packages faster by measuring each flow, using fast load, sizing buffers from row width, and replacing row-by-row work.

Read More
A screwdriver with a red bit in its handle beside an open case of spare bits.

SQLCMD Mode in SSMS: Variables, :CONNECT and :r Includes

January 12, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, sqlcmd

Use SQLCMD mode in SSMS for server and database variables, :CONNECT, :r include files, and an error-stop release script.

Read More
Execution plan showing SQL query and cost.

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 Part 3

January 11, 2013
Pinal Dave
SQL Tips and Tricks
SQL Index

Index on Col1, Col2 and index on Col1, Col2, Col3 Part 3: Jon and Mike ask if it is always best practice to drop redundant indexes. Here is a special case.

Read More
An open dishwasher of clean plates while a hand scrubs a red roasting pan

Maintaining SharePoint Content Databases: What the DBA Still Owns

January 10, 2013
Pinal Dave
SQL Tips and Tricks
DBA, SharePoint, SQL Backup and Restore, SQL Server DBCC

Review SharePoint content databases for CHECKDB, backup history, log growth, recovery model, and a tested site-collection restore.

Read More
Select query execution.

SQL SERVER – How to Hide Yourself from SQL Server? – Guest Post by Balmukund Lakhani

January 9, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Utility

Balmukund Lakhani of Microsoft India GTSC writes a guest post with a fun title and a useful trick: how to hide yourself from SQL Server, in his own words.

Read More
SQL Server - Using SSMS Command Line Parameters

SQL Server – Using SSMS Command Line Parameters

January 8, 2013
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Server, SQL Server Management Studio

My friend Vinod Kumar shows how SSMS Command Line parameters can save you a few clicks every time you open Management Studio and connect to a server.

Read More
A stone-lined irrigation channel with a small sluice gate and a red wheel across the water

Sharding by Customer: Routing Queries to the Right Database

January 8, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Dynamic SQL, SQL Server

Plan sharding by customer with a shard map, parameterized routing and synonyms, and account for reports, keys and customer moves.

Read More
Execution Plan with query and index options.

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 2

January 7, 2013
Pinal Dave
SQL Tips and Tricks
SQL Index

Is every redundant index safe to drop? In part 2 of this interesting case of redundant indexes, Jon shows Mike a demo where a redundant index should stay.

Read More
Two nearly identical brown leather gloves on a hall table, both for the left hand, a hand hovering above them.

Finding Duplicate Customers With T-SQL

January 6, 2013
Pinal Dave
SQL Tips and Tricks
Duplicate Records, SQL Function, SQL Server, SQL String

Find duplicate customers with T-SQL by normalizing names, reviewing fuzzy matches, and merging records only after ownership is settled.

Read More
A row of small snowmen along a snowy path, each wearing the same red scarf

Running a Command in Every Database Without sp_MSforeachdb

January 5, 2013
Pinal Dave
SQL Tips and Tricks
DBA, Dynamic SQL, SQL Scripts, SQL Server

Run a checked command in every database with a FAST_FORWARD cursor, AG role filter, QUOTENAME, and per-database error log.

Read More
Previous 1 … 353 354 355 356 357 358 359 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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