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 - 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
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
SQL SERVER - 2005 - Search Stored Procedure Code - Search Stored Procedure Text

SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text

September 3, 2007
Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Scripts, SQL Stored Procedure, SQL System Table

How to search stored procedure code in SQL Server 2005 for a table or column name, using sys.procedures and OBJECT_DEFINITION instead of sp_depends.

Read More
SQL SERVER - Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward

SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward

September 2, 2007
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

Msg 3117 means the log or differential backup cannot be restored because no files are ready to rollforward. Restore the full backup WITH NORECOVERY first.

Read More
Previous 1 … 332 333 334 335 336 337 338 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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