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 - Generating Row Number Without Ordering Any Columns

SQL SERVER – Generating Row Number Without Ordering Any Columns

May 5, 2015
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

ROW_NUMBER needs an ORDER BY clause, but what if you do not want to sort by any column? Here is a simple trick to generate a row number without ordering.

Read More
A comb separates stray burs from a continuous string of blue beads

Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics

May 3, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts

Remove special characters with a corrected SQL Server loop and a 2025 regex expression, while defining ASCII and collation rules.

Read More
SQL Server 2012 Error Dialog.

SQL SERVER – Recovering from Snapshots – Notes from the Field #078

April 30, 2015
Pinal Dave
SQL Tips and Tricks
Notes from the Field, Snapshot, SQL Backup and Restore, SQL Scripts

Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.

Read More
SQL SERVER - Script: Knowing Data and Log Files Are On the Same Drive

SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive

April 29, 2015
Pinal Dave
SQL Tips and Tricks
GIDS, SQL Scripts, SQL Server, Transaction Log

At GIDS I talked about keeping data and log files on separate drives. Here is a script that shows which databases have data and Log Files on the same drive.

Read More
SQL SERVER - Finding Tables with Primary or Foreign Keys

SQL SERVER – Finding Tables with Primary or Foreign Keys

April 29, 2015
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

How do you find which tables have a primary key or foreign key? Here are simple queries for finding tables with primary or foreign keys in a database.

Read More
Gouache painting of two storehouses on a canal joined by a plank bridge with a red handcart crossing

How to Identify Cross-Database Transactions in SQL Server

April 22, 2015
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL Transactions

To find cross-database transactions, search the code for references to other databases, watch a live transaction with a DMV, or read special records in the transaction log. This post tests all three on two demo databases. It also shows why a popular log script flags a brand new database.

Read More
Sql sever split comma separated list.

SQL SERVER – Split Comma Separated List Without Using a Function

April 21, 2015
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

I have shown how to build a comma separated list many times. This time a reader wanted the reverse: split a comma separated list into rows without a function.

Read More
Previous 1 … 163 164 165 166 167 168 169 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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