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 - UDF to Return a Calendar for Any Date for Any Year.

SQL SERVER – UDF to Return a Calendar for Any Date for Any Year

February 20, 2008
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts

Reader Dan Golden built on my weekly calendar function to create a UDF to return a calendar for any date for any year. I fixed a small first and last week bug.

Read More
Escaping a single quote in SQL Server: 'Villeneuve-d''Ascq' with the doubled quote in red

SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string

February 17, 2008
Pinal Dave
SQL Interview Questions and Answers
SQL Error Messages, SQL Scripts, SQL Server, SQL String

Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).

Read More
Gouache painting: on a calm river, three rows of flat stepping stones cross from the near bank to the same vermilion post on the far bank

LOG With a Base: Make the Calculation Explicit

February 15, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

LOG with a base makes logarithm meaning explicit. Compare base two, base ten and the natural default using typed, positive inputs.

Read More
SQL Server Management Studio Query Window.

SQL SERVER – Get Current Database Name

February 12, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts

Need the current database name in a script? SELECT DB_NAME() returns the name of the database you are running the query in. It is a one line answer.

Read More
SQL SERVER - 2005 - Find Unused Indexes of Current Database

SQL SERVER – 2005 – Find Unused Indexes of Current Database

February 11, 2008
Pinal Dave
SQL Performance
SQL Index, SQL Scripts

A simple but accurate SQL Server 2005 script to find unused indexes in the current database, since unused indexes slow down INSERT and UPDATE statements.

Read More
Gouache painting: two identical wall rails each carry the same five horseshoes graded from small to large, plus two bare vermilion hooks

NULL Sort Order: Put Missing Values Where Readers Expect

February 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

NULL sort order uses a CASE bucket to put missing values last. Keep a stable tie breaker and preserve the original score.

Read More
A paper ribbon of comma separated values feeding into a machine and coming out as a tidy table.

SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server

February 6, 2008
Pinal Dave
SQL Tips and Tricks
CSV, SQL Scripts, SQL Utility

How to import CSV file data into SQL Server with BULK INSERT: create a table, point to the comma delimited file and load every row in a few quick steps.

Read More
Previous 1 … 319 320 321 322 323 324 325 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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