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
An open key cabinet on the stone wall of a mountain hut, a brass key on its hook above a coiled rope and lantern.

Doing Remote DBA Work Well

September 10, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Consulting, DBA, SQL Monitoring

Remote DBA work succeeds with controlled access, current runbooks, agreed change windows, and communication that makes every action visible.

Read More
SQL Server Command Prompt.

SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt

September 9, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility

Start, stop or restart SQL Server from the command prompt with net start mssqlserver and net stop mssqlserver. A batch file can run both together.

Read More
SQL SERVER - UDF - User Defined Function - Get Number of Days in Month

SQL SERVER – UDF – User Defined Function – Get Number of Days in Month

September 8, 2007
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

A simple user defined function that returns the number of days in month for any date, with the leap year rule for February built in.

Read More
SQL SERVER - Correlated and Noncorrelated - SubQuery Introduction, Explanation and Example

SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example

September 7, 2007
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts, SQL Sub Query

What is the difference between correlated and noncorrelated subqueries? I explain both kinds with simple AdventureWorks examples.

Read More
Sqlcmd command prompt window.

SQL SERVER – 2005 – Introduction and Explanation to sqlcmd

September 6, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility, sqlcmd

An introduction to sqlcmd, the SQL Server 2005 command prompt utility that runs ad hoc T-SQL statements and scripts, and how it improves on isql and osql.

Read More
A cook seen from behind tastes from a small trial saucepan while a large covered pot waits beside it.

Testing a Cumulative Update Before Production

September 6, 2007
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Backup and Restore, SQL Patch, SQL Server, Testing

Testing a Cumulative Update means restoring real data, replaying key jobs, comparing plans and timings, and signing off before production.

Read More
A wooden mannequin fallen off its chair laughing at a long paper printout

Funny SQL Server Error Messages and What They Really Mean

September 5, 2007
Pinal Dave
SQL Tips and Tricks
Deadlock, SQL Error Messages, SQL Humor, SQL Server

Some real SQL Server error messages read like jokes. Here are my favorite funny SQL Server error messages and what each one is really telling you.

Read More
Gouache painting: on a market counter a pink grapefruit has had one thin wedge cut from it, and the wedge lies on a small saucer

RADIANS: Cast Integer Degrees Before Conversion

September 5, 2007
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

RADIANS changes degrees into radians, but its input type affects the result. The example contrasts integer and float arguments while keeping the original degree values.

Read More
SQL SERVER - 2005 - Find Tables With Primary Key Constraint in Database

SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database

September 4, 2007
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL System Table

A script to find tables with primary key constraint in a SQL Server 2005 database, listing the index name, table name and column name from sys.indexes.

Read More
A gouache terraced garden links smaller planting modules to a larger supporting terrace through visible fittings.

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database

September 4, 2007
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server, SQL System Table

A foreign key inventory needs both the constraint and its column pairings. I include schema names to identify each table clearly.

Read More
Previous 1 … 560 561 562 563 564 565 566 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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