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 - Datetime Function TODATETIMEOFFSET Example

SQL SERVER – Datetime Function TODATETIMEOFFSET Example

July 16, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

A quick example of the datetime function TODATETIMEOFFSET in SQL Server, and how it differs from SWITCHOFFSET when offsets change.

Read More
SQL Server offset settings.

SQL SERVER – Datetime Function SWITCHOFFSET Example

July 15, 2010
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

SWITCHOFFSET changes a datetimeoffset value from its stored time zone offset to a new one. Here is a quick example of how it works in SQL Server 2008.

Read More
Gouache painting of an open parcel with a loose red ribbon and blank receipt, illustrating INSERT OUTPUT before commit.

SQL Server: Why INSERT OUTPUT Does Not Prove a Commit

July 9, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Transactions

INSERT OUTPUT can return an identifier before a transaction commits. These tested examples show a rollback after a returned row and a pattern that returns results after commit.

Read More
SQL SERVER - The Self Join - Inner Join and Outer Join

SQL SERVER – The Self Join – Inner Join and Outer Join

July 8, 2010
Pinal Dave
SQL Tips and Tricks
SQL Joins, SQL Scripts

Is a Self Join an inner join or an outer join? It can be either. I build a small new example that shows Self Join as inner join and outer join.

Read More
SQL SERVER - Upper Case Shortcut SQL Server Management Studio

SQL SERVER – Upper Case Shortcut SQL Server Management Studio

July 7, 2010
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio

Want an upper case shortcut in SSMS? Select a keyword and press CTRL+SHIFT+U to make it upper case, or CTRL+SHIFT+L to make it lower case.

Read More
PowerShell Version Info.

SQL SERVER – PowerShell Version Info

July 5, 2010
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts

Two commands show your PowerShell version: $PSVersionTable and $host. Only one worked on Version 1, so I ask PowerShell experts to explain why.

Read More
Clustered Index B-Tree

SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats

July 4, 2010
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Index, SQL Scripts

How many pages does an index use, and how many B-Tree levels does it have? sys.dm_db_index_physical_stats shows index levels, page count and record count.

Read More
Previous 1 … 253 254 255 256 257 258 259 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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