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
Gouache painting of three colored ribbons feeding through a brass guide and joining into one braided cord.

Concat Strings in SQL Server: SQL in Sixty Seconds #035

December 5, 2012
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL NULL, SQL Scripts, SQL String

To concat strings in SQL Server, use the + operator or the CONCAT function. The tests here show what each one does with NULL, numbers and dates, how the 8000 character limit cuts a result, and when CONCAT_WS or STRING_AGG is the better tool.

Read More
SQL SERVER - Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

December 2, 2012
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL Utility

Which tables does a procedure use, and which procedures use a table? sys.sql_expression_dependencies answers both, with referenced and referencing objects.

Read More
A landscape jigsaw puzzle has one loose matching piece beside its open space.

Why Opening an MDF File Directly Goes Wrong

November 30, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Before you attach MDF file copies, check SQL Server versions, service permissions, and missing files, then choose a safer restore or attach path.

Read More
SQL SERVER - Find Weekend and Weekdays from Datetime in SQL Server 2012

SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012

November 25, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server 2012

Is today a weekend or a weekday? A question from the very first SQL Bangalore User Group meeting, answered with the CHOOSE function in SQL Server 2012.

Read More
Gouache painting of two shelves holding the same three jars in opposite orders, the short jar on the top shelf painted red

Display Datetime in a Specific Format: CONVERT and FORMAT

November 21, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL String

To display datetime in a specific format, use CONVERT with a style number or FORMAT with a pattern. This post tests both on a fixed value, shows the lowercase pattern mistake, measures how much slower FORMAT is, and explains why parsing text dates needs a style.

Read More
SQL SERVER - Using RAND() in User Defined Functions (UDF)

SQL SERVER – Using RAND() in User Defined Functions (UDF)

November 20, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

Using RAND() in a user defined function throws Msg 443, invalid use of a side-effecting operator. Here is a simple workaround that lets a UDF use a random value.

Read More
SQL SERVER - Removing Leading Zeros From Column in Table

SQL SERVER – Removing Leading Zeros From Column in Table

November 19, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server

Most people ask how to keep leading zeros in SQL Server. This time a reader wanted to remove leading zeros and white space from a column, so here is a script.

Read More
Previous 1 … 195 196 197 198 199 200 201 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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