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
SQL SERVER - Create Primary Key with Specific Name when Creating Table

SQL SERVER – Create Primary Key with Specific Name when Creating Table

April 22, 2010
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

How do you create a primary key with specific name while creating the table itself? One CREATE TABLE statement can define and name the constraint.

Read More
Max worker threads window.

SQL SERVER – Find Max Worker Count using DMV – 32 Bit and 64 Bit

April 20, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table

Does doubling the CPUs double the worker threads? No. Use sys.dm_os_sys_info to find Max Worker Count, and see the formula for 32 bit and 64 bit.

Read More
A small stack of plain closed books beside one open blank notebook in soft window light.

Keeping Up With SQL Server Without Drowning

April 18, 2010
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Make keeping up SQL Server knowledge manageable with release-note reviews, one deep topic each quarter, and a small record of relevant changes.

Read More
A pilot seen from behind walking around a small propeller plane at dawn, a red streamer on one wing

A Daily DBA Checklist You Can Run as One Script

April 16, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Monitoring, SQL Scripts, SQL Server Agent

Run a daily DBA checklist that reports stale backups, failed jobs, offline databases, recent errors, low volume space and current blocking.

Read More
Gouache painting: in a railway yard, a long straight track runs left to right

geometry STCrosses: Crossing Depends on the Intersection Dimension

April 14, 2010
Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server

geometry STCrosses uses the dimension and interior position of the intersection to define crossing. I compare it with endpoint contact and collinear overlap. A shared point or segment does not automatically satisfy that definition.

Read More
SQL SERVER - Difference Between GRANT and WITH GRANT

SQL SERVER – Difference Between GRANT and WITH GRANT OPTION

April 3, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Security

What is the difference between GRANT and WITH GRANT? Only WITH GRANT OPTION lets a user pass the same permission on to other users.

Read More
Gouache painting: on a joiner's bench, a stout beam end has one dovetail-shaped socket

ISJSON Type Constraints: Validate the Top-Level Value

April 2, 2010
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

ISJSON type constraints distinguish JSON shapes. Compare VALUE and SCALAR, Boolean literals, JSON null and SQL NULL on SQL Server 2022.

Read More
Previous 1 … 260 261 262 263 264 265 266 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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