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
Gouache painting: in a foundry workshop, an open wooden casting flask holds pressed sand with three clean, differently shaped impressions: round, long oval and square

Describe a Result Set Without Executing Its Query

October 13, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL DMV, SQL Scripts

Describe a result set without running the query. Check column names, data types, nullability and declared parameters.

Read More
SQL SERVER - Pre-Code Review Tips - Tips For Enforcing Coding Standards

SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards

October 12, 2007
Pinal Dave
SQL Tips and Tricks
Database, DBA, SQL Coding Standards, SQL Scripts

Pre-code review tips for DBAs: why I check stored procedures on our development server every day for coding standards, with a link to my full article.

Read More
SQL SERVER - T-SQL Script to Add Clustered Primary Key

SQL SERVER – T-SQL Script to Add Clustered Primary Key

October 11, 2007
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

A Jr. DBA asked me three times in one day how to create a clustered primary key, so I gave him this ALTER TABLE example. He never asked again.

Read More
Three blue stones in a pale shallow bowl, an empty bowl and one separate blue stone.

Multiset Difference: Remove Only Matching Duplicate Occurrences

October 10, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Joins, SQL Scripts, SQL Server

Multiset difference removes matching occurrences while keeping any extra copies from the left input. I assign occurrence numbers before pairing rows. A value’s presence on the right should not automatically remove every left copy.

Read More
Sql server query results window.

SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE

October 9, 2007
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Function, SQL Scripts

SQL Server 2005 has four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. I explain what each returns and show a sample example of all four.

Read More
SQL SERVER - Executing Remote Stored Procedure - Calling Stored Procedure on Linked Server

SQL SERVER – Executing Remote Stored Procedure – Calling Stored Procedure on Linked Server

October 6, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Two ways to call a remote stored procedure on a linked server: a four part name with EXEC, or the OPENQUERY distributed query function.

Read More
SQL SERVER - 2005 - Open SSMS From Command Prompt - sqlwb.exe Example

SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example

October 5, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility

Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.

Read More
Previous 1 … 328 329 330 331 332 333 334 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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