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
Table in SQL Server Management Studio.

SQL SERVER – What is Interim Table – Simple Definition of Interim Table

June 4, 2009
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

What is an interim table? A simple question started a long debate on a call with developers. Here is my simple definition of interim table.

Read More
Gouache painting: beside an open brick kiln, the whole firing is stacked in neat rows, each brick slightly different in shade and length

STDEV and STDEVP: Choose Sample or Population

June 3, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

STDEV and STDEVP report spread in the input’s units. Compare a sample, a full population, duplicates, NULL and a single observed value.

Read More
SQL server filegroups query.

SQL SERVER – List All Objects Created on All Filegroups in Database

June 1, 2009
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL System Table

A reader asked which object belongs to which filegroup. Here is how to list all objects created on all filegroups in a database, with a sample database.

Read More
SQL Server database properties settings.

SQL SERVER – Create Multiple Filegroup For Single Database

May 31, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio

How to create multiple filegroup for a single database, both for a new database and an existing one, using T-SQL as well as SSMS.

Read More
SQL SERVER - Difference Between Candidate Keys and Primary Key

SQL SERVER – Difference Between Candidate Keys and Primary Key

May 30, 2009
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Function, SQL Scripts

What is the difference between a candidate key and a primary key? A table can have many candidate keys, but only one of them becomes the primary key.

Read More
Gouache painting of a glass jar full of cream, slate blue and sage marbles on a wooden table, with a small wooden scoop and one loose marble in front

APPROX_COUNT_DISTINCT in SQL Server: Saves Memory, Not Time

May 29, 2009
Pinal Dave
SQL Performance
SQL Function, SQL Memory, SQL Performance, SQL Scripts

APPROX_COUNT_DISTINCT counts distinct values with almost no memory. Tested on 5 million rows, it was within 2.2 percent of the exact count and needed no memory grant, while COUNT(DISTINCT) asked for 436 MB. It was not faster.

Read More
SQL SERVER - Interesting Observation of Logon Trigger On All Servers

SQL SERVER – Interesting Observation of Logon Trigger On All Servers

May 27, 2009
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Scripts, SQL Server, SQL Trigger

I created a Logon Trigger to audit every successful login for a client, and one login was recorded several times on different threads. The script and what I saw.

Read More
Previous 1 … 281 282 283 284 285 286 287 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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