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 - Add Column With Default Column Constraint to Table

SQL SERVER – Add Column With Default Column Constraint to Table

March 19, 2008
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Constraint and Keys, SQL Scripts, SQL Server

Add a NOT NULL column with a named default Column Constraint in one ALTER TABLE statement. I always name constraints instead of letting SQL Server pick one.

Read More
Gouache painting: beside it, the same ring hovers above an empty saucer and closes on nothing, so no match is made

Simple CASE and NULL: Use a Searched Condition

March 18, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

Simple CASE and NULL do not match through equality. Use a searched IS NULL branch, preserve empty text, and make the result type explicit.

Read More
SQL SERVER - 2005 - Retrieve Any User Defined Object Details Using sys objects Database

SQL SERVER – 2005 – Retrieve Any User Defined Object Details Using sys objects Database

March 16, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL System Table, SQL Utility

The sys.objects catalog view has a row for every schema-scoped object, so you can retrieve any user defined object details, like foreign keys, by object type.

Read More
SQL SERVER - 2005 - Retrieve Processes Using Specified Database

SQL SERVER – 2005 – Retrieve Processes Using Specified Database

March 15, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

Jim Sz shared a quick script to retrieve processes that use a specific database from sys.sysprocesses, with spid, status, host name and login.

Read More
SQL SERVER - FIX : Error : 3702 Cannot drop database because it is currently in use - Part 2

SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2

March 13, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

Still see Error 3702, cannot drop database because it is currently in use? Why closing Management Studio works and how to find the connection.

Read More
SQL SERVER - 2005 - Find Nth Highest Record from Database Table - Using Ranking Function ROW_NUMBER

SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER

March 12, 2008
Pinal Dave
SQL Performance
MVP, SQL Function, SQL Joins, SQL Scripts

Nicholas Paldino shared a neat way to find the Nth Highest Record from a table in SQL Server 2005 using the ranking function ROW_NUMBER. Here is his query.

Read More
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL - Part 3

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3

March 11, 2008
Pinal Dave
SQL Performance
SQL Function, SQL Joins, SQL Scripts

Part 3 on how to retrieve TOP and BOTTOM rows together: Dave Arthur’s solution uses UNION ALL instead of an OR clause, and it is quite good.

Read More
Previous 1 … 316 317 318 319 320 321 322 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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