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 - 2008 - Introduction to Online Indexing Operation

SQL SERVER – 2008 – Introduction to Online Indexing Operation

August 15, 2008
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server

An introduction to online indexing in SQL Server, which lets you create or rebuild an index while the table stays available to your app.

Read More
A hand cutting a sugarcane stalk at its natural joints on a chopping block, the cut sections lying in a row beside it.

Splitting a URL Into Host, Path and Query String in T-SQL

August 13, 2008
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

Practice splitting a URL into host, path, and query values with T-SQL string functions, SQL Server 2025 regex, and ordered parameter rows.

Read More
Gouache painting: two wooden fermenting vats stand on a cellar floor, one narrow and one wide

ABS: Widen an Integer Before Taking Its Magnitude

August 10, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Function, SQL Scripts, SQL Server

ABS can overflow even when the negative input fits its signed integer type. I widen the input before asking for its magnitude. Casting the output afterward would be too late to protect the calculation.

Read More
SQL SERVER - EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle

August 7, 2008
Pinal Dave
SQL Performance
SQL Joins, SQL Scripts

Is there a MINUS clause in SQL Server like in Oracle? Yes, EXCEPT returns the rows of the first query that are not in the second. Example included.

Read More
SQL Query2' results and messages window.

SQL SERVER – Query to Find Column From All Tables of Database

August 6, 2008
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Scripts, SQL Stored Procedure, SQL System Table

How many AdventureWorks tables have an EmployeeID column? My query on sys.tables and sys.columns finds any column from all tables, with schema names.

Read More
SQL SERVER - 2005 - Get Field Name and Type of Database Table

SQL SERVER – 2005 – Get Field Name and Type of Database Table

August 5, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table

How do you get the field name and type of a table in SQL Server 2005? Imran Mohammed answers with sp_help and an INFORMATION_SCHEMA.COLUMNS query.

Read More
Gouache painting of a wooden board with five round wooden knobs on a cream wall, a blank vermilion tag hanging from the middle knob

Who Changed a Server Setting in SQL Server? How to Find Out

August 4, 2008
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Log, SQL Scripts, SQL Server Configuration

Who changed a server setting in SQL Server? The error log records what changed and when, and the default trace adds the login, the computer and the program. Tested with one harmless change that is put back at the end.

Read More
Previous 1 … 304 305 306 307 308 309 310 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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