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
SQL SERVER - Not Possible - Delete From Multiple Table - Update Multiple Table in Single Statement

SQL SERVER – Not Possible – Delete From Multiple Table – Update Multiple Table in Single Statement

September 27, 2012
Pinal Dave
SQL Tips and Tricks
SQL Joins

Can you delete from multiple table or update multiple tables in a single statement? No, and you should not try. Here is why, and what a reader pointed out.

Read More
Gouache painting of a row of potted herbs on two greenhouse shelves with the lead pot painted red

Copy Column Headers From SSMS Results to Excel

September 26, 2012
Pinal Dave
SQL Tips and Tricks
Excel, SQL Server Management Studio, SQL Shortcut, SQL Utility

To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.

Read More
Gouache painting of four nested bowls on a kitchen counter with the smallest center bowl painted red

Order of Operations in SQL Server: How PEMDAS Works in T-SQL

September 25, 2012
Pinal Dave
SQL Tips and Tricks
Mathematics, SQL Operator, SQL Scripts, SQL Server

The order of operations in SQL Server follows PEMDAS, so 6/2*(1+2) returns 9. This post walks through the precedence rules with tested queries. It also covers integer division, the negative number trap and AND before OR.

Read More
SQL SERVER - Excel Losing Decimal Values When Value Pasted from SSMS ResultSet

SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet

September 24, 2012
Pinal Dave
SQL Tips and Tricks
Excel, SQL Server, SQL Server Management Studio, SQL Utility

I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset. 

Read More
A model ship floats in a long indoor water tank as small waves roll toward it from the far end.

Keeping a Patch Test Environment Honest

September 23, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Patch, SQL Server, SQL Server Configuration, Testing

A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.

Read More
Several separate cabinets expose their fittings for inspection beside a plain marker and lens.

SQL SERVER – Validating Unique Column Name Across Whole Database

September 22, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL System Table

A Unique Column Name check lists existing matches across visible database metadata. I use it as an inspection, not an enforcement guarantee.

Read More
SQL SERVER - Replace a Column Name in Multiple Stored Procedure All Together

SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together

September 21, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Stored Procedure

A beginner on a development server asked how to replace a column name in Multiple Stored Procedure code all together. Here is the quick way I suggest.

Read More
A tall boot beside a small open shoebox that holds only a small red paper star instead of the boot.

Why CAST to a Short VARCHAR Returns a Star Instead of an Error

September 20, 2012
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Server, SQL String

Understand why a short VARCHAR returns a star for an integer, compare Unicode errors and string truncation, and size conversions safely.

Read More
Gouache painting of two trays of buttons, one mixed together and one sorted by size, with one large red button

Effect of Collation on Result Sets in SQL Server

September 19, 2012
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Group By, SQL Order By, SQL Scripts

The effect of collation on result sets is easy to see once you run the same query against two collations. This post builds a small demo and shows how sorting, comparing and grouping change. It also explains collation conflicts, including the one temp tables cause.

Read More
SQL Server query designer top 100 percent.

SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer

September 18, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL View

Why does Query Designer in SSMS keep adding TOP (100) PERCENT when you create a view? A forum question, the full scenario, and what is going on.

Read More
Previous 1 … 364 365 366 367 368 369 370 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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