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 - Performance Tuning - Is It Really A Top Skills for a SQL Server Consultant? - Notes from the Field #059

SQL SERVER – Performance Tuning – Is It Really A Top Skills for a SQL Server Consultant? – Notes from the Field #059

December 25, 2014
Pinal Dave
SQL Performance
Notes from the Field, SQL Server Security

The world needs more Performance Tuning consultants, but is tuning really the top skill for a SQL Server consultant? Brian Moran answers from a business view.

Read More
Two wax-sealed wine bottles on a cellar rack, one seal whole and the other with a fine crack across it.

Page Verify CHECKSUM and Why It Matters

December 24, 2014
Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC

Page verify CHECKSUM detects altered database pages on read; inspect old settings, understand new writes, and review suspect pages.

Read More
SQL SERVER - Puzzle - Why Decimal is Rounded Up?

SQL SERVER – Puzzle – Why Decimal is Rounded Up?

December 24, 2014
Pinal Dave
SQL Puzzle
SQL Scripts

Why decimal is rounded up in one script and not in the other when both divide 10000 by 17? Try this holiday puzzle before you read the comments.

Read More
SQL SERVER - Story of Temporary Objects

SQL SERVER – Story of Temporary Objects

December 23, 2014
Pinal Dave
SQL Tips and Tricks
Devart, SQL Scripts, SQL Server, SQL TempDB

Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.

Read More
SQL SERVER - List the Name of the Months Between Date Ranges - Part 2

SQL SERVER – List the Name of the Months Between Date Ranges – Part 2

December 22, 2014
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

Part 2 on listing the names of the months between date ranges, with an improved script from readers Miladin Joksic and Peter Lalovsky that adds more details.

Read More
SQL Server Management Studio query window with SQL code.

SQL SERVER – List the Name of the Months Between Date Ranges – Correction

December 21, 2014
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function

Sanjay Monpara caught a small error in my script to list the name of the months between two dates: it skipped the first month. Here is his corrected script.

Read More
SQLAuthority News - Presented on Database Worst Practices at SQLPASS 2014 in Seattle - November 5, 2014

SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014

December 20, 2014
Pinal Dave
SQLAuthority News
SQL PASS, SQLAuthority Author Visit

I presented Database Worst Practices at SQLPASS 2014 in Seattle on November 5. Here is the title and abstract of the session in case you missed it.

Read More
SQL SERVER - Reverse String Word By Word - Part 4

SQL SERVER – Reverse String Word By Word Part 4

December 19, 2014
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String

In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.

Read More
SQL SERVER - Creating the SSIS Catalog - Notes from the Field #058

SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058

December 18, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, SSIS

SQL Server 2012 added the SSIS Catalog to store, run and log packages in one place. In Notes from the Field #058, Tim Mitchell shows how to set it up.

Read More
SQL SERVER - Reverse String Word By Word - Part 3

SQL SERVER – Reverse String Word By Word Part 3

December 17, 2014
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String

Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.

Read More
Previous 1 … 278 279 280 281 282 283 284 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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