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
93538 Same TransactionID.

SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions

April 11, 2009
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL System Table, SQL Transactions

sys.dm_tran_active_transactions and sys.dm_tran_current_transaction look alike, but one lists active transactions for the instance, the other only your session.

Read More
SQL SERVER - Fix Error 9803. Invalid data for type "numeric" - Data Type Mapping

SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping

April 9, 2009
Pinal Dave
SQL Tips and Tricks
Oracle, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.

Read More
SQL Server primary key error dialog.

SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit for index or statistics key column list is 16

April 8, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Index, SQL Scripts

What are the maximum columns per primary key? It is 16, and going past it raises Msg 1904. The same limit applies to foreign keys and index keys.

Read More
SQL SERVER - Mirrored Backup and Restore and Split File Backup

SQL SERVER – Mirrored Backup and Restore and Split File Backup

April 5, 2009
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Data Storage, SQL Scripts

From a real project: conventional backup and restore, split file backup when a disk runs short of space, mirror file backup, and the FORMAT clause.

Read More
Gouache painting: on a wooden floor, two open cloth sacks hold small square bean bags in red, blue, green and gray

EXCEPT: Compare Distinct Sets Including NULL

April 4, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

EXCEPT returns distinct left-side rows absent on the right. Compare direction, duplicates and NULL equality using complete small result sets.

Read More
A hand lifts the last dark log from an old firewood bay into a canvas bag already holding dark logs and one pale log.

FIFO Inventory Costing in T-SQL: Matching Sales to Purchase Lots

April 1, 2009
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Joins, SQL Scripts, Temp Table

Which purchase lot paid for which sale? Two running totals and one join answer it, with no cursor and no loop.

Read More
SQL SERVER - Fix : Error : Msg 2714, Level 16, State 6 - There is already an object named '#temp' in the database

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

March 29, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL TempDB

Msg 2714 says there is already an object named #temp in the database, even after an IF EXISTS check and DROP. A reader asked why, and here is the answer.

Read More
Previous 1 … 285 286 287 288 289 290 291 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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