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
Generate primary and foreign keys.

SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key

July 23, 2009
Pinal Dave
SQL Puzzle
SQL Constraint and Keys, SQL Scripts

A puzzle from a migration project: SSMS cannot script every Primary Key and Foreign Key at once. Can you write a script that generates them all?

Read More
Gouache painting: on a greenhouse bench a rectangular pane of glass lies beside an empty wooden frame of the same outer size, its four rails joined with open air inside

geometry STBoundary: A Polygon Edge Is a Different Shape

July 21, 2009
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STBoundary returns the edge of a shape as another geometry instance. I inspect that result independently from the source. A polygon’s boundary is not another filled polygon with the same area.

Read More
SQL Server Management Studio Query Results Window.

SQL SERVER – Get Last Running Query Based on SPID

July 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server DBCC, SQL System Table

How to see the last running query of another session based on its SPID, using @@SPID to find session IDs and DBCC INPUTBUFFER to read the query.

Read More
SQL SERVER - Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database

SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database

July 17, 2009
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server

There are two different methods to retrieve the list of Primary Keys and Foreign Keys from the database.

Read More
Database Recovery Model Window.

SQL SERVER – Four Different Ways to Find Recovery Model for Database

July 16, 2009
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts

Four ways to find the recovery model of a database: database properties, Object Explorer Details, sys.databases and DATABASEPROPERTYEX.

Read More
SQL Server backup overview diagram.

SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY

July 15, 2009
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts, SQL Server

What is the difference between NORECOVERY and RECOVERY when restoring a database, and what is the right restore sequence? A plain explanation of both.

Read More
Unmarked wooden blocks in natural cream and slate tones stand in a row beside a red end block on textured off-white paper.

Decimal Multiplication: Precision Can Reduce the Result Scale

July 12, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

Decimal Multiplication derives a result type from its operand types, and the precision limit can reduce the scale. I inspect three small products. A small numeric value does not necessarily imply a narrowly declared arithmetic result.

Read More
Previous 1 … 278 279 280 281 282 283 284 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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