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 garden path of alternating cream and blue slabs from a red slab at the gate, one slab missing by a tree root

A Schedule Table That Repeats Every Other Week

September 2, 2019
Pinal Dave
SQL Tips and Tricks
SQL System Table, SQL Table Operation, Table Partitioning, Temp Table

Build an every other week schedule in T-SQL, skip holiday dates, find the next occurrence, and check rota weeks from one anchor.

Read More
dynamic

SQL SERVER – Dynamic SQL and Temporary Tables

July 22, 2019
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Scripts, SQL Server, SQL Server Management Studio, SQL TempDB, Temp Table

Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.

Read More
Global Temporary Tables

SQL SERVER – Dynamic SQL and Global Temporary Tables

July 20, 2019
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Scripts, SQL Server, SQL Server Management Studio, SQL TempDB, Temp Table

During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.

Read More
Temp Tables

SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure

June 21, 2019
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Scripts, SQL Server, SQL TempDB, Temp Table

SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.

Read More
009/017 temporary tables created in sql server.

How Many Temporary Tables are Created So Far in SQL Server? – Interview Question of the Week #149

November 26, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, Temp Table

How many temporary tables are created so far in SQL Server? No DMV gives this directly, but here is an easy workaround to find the answer.

Read More
SQL SERVER - How to Create A Global Temporary Table?

SQL SERVER – How to Create A Global Temporary Table?

October 21, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB, Temp Table

Readers asked me to cover it after my temp table post. Here is how to create a Global Temporary Table and how it differs from a regular temporary table.

Read More
Table Variable Temporary Table.

SQL SERVER – How to Create Table Variable and Temporary Table?

October 18, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB, Temp Table

New to SQL Server? This simple tutorial shows how to create a Temporary Table and a table variable, how to query them, and how long each one lasts.

Read More
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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