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 row of mugs on kitchen hooks, one mug per hook, except one hook holding two mugs together.

ROWS vs RANGE in Window Frames: Why Running Totals Differ

May 4, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Order By, SQL Scripts, SQL Server

Compare ROWS vs RANGE for running totals, handle tied sort values, write explicit frames, and check worktable reads on your server.

Read More
Gouache painting: in a sports room, two identical pegged racks hold the same four team bibs in cream, blue, sage and red

XML sql:column: Compare XML With a Relational Value

May 3, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

XML sql:column passes a typed relational value into XQuery. Keep node existence separate from a missing document and a scalar Boolean.

Read More
Execution Plan for SQL Query.

SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012

May 2, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

How fast are result sets in SQL Server 2012 compared with a temp table? I ran both methods and compared their execution plans to answer a reader.

Read More
A table top used as a template, traced in pencil onto a fresh sheet of plywood on trestles.

SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?

April 30, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Table Operation

CTAS stands for Create Table As Select. In SQL Server you do it with SELECT INTO, which creates the new table and fills it with data in one step.

Read More
SQL SERVER - 2012 - Executing Stored Procedure with Result Sets

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

April 28, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Denali lets you execute a stored procedure with result sets and rename its columns at run time, with no temp table needed. Here is a quick script.

Read More
Two similar cream ceramic vases stand in separate wooden compartments beside a small sage-green jar.

XQuery Node Identity: Equal Text Can Be Different Nodes

April 27, 2011
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

XQuery node identity compares source nodes, not their text. Use is beside text equality to distinguish repeated values from the same node.

Read More
SQL SERVER - How to ALTER CONSTRAINT

SQL SERVER – How to ALTER CONSTRAINT

April 24, 2011
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

Can you ALTER CONSTRAINT in SQL Server? No. The only way to change a constraint is to drop it and create it again, and here is the script for that.

Read More
Previous 1 … 230 231 232 233 234 235 236 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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