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
A jar of ground coffee with a red scoop, the hand grinder unused behind it

Indexed Views: When the Faster Reads Are Worth It

September 26, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Server, SQL View

Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.

Read More
Configure sql server startup parameters.

SQL SERVER – Denali – Startup Parameters Easy to Configure

September 26, 2011
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

SQL Server Denali makes startup parameters easy to change. Here is the quick path in SQL Server Configuration Manager to the startup parameters screen.

Read More
A skier riding a chairlift while a groomer prepares the slope below

Azure SQL Database for the On-Premises DBA

September 25, 2011
Pinal Dave
SQL Tips and Tricks
Cloud Computing, DBA, Query Store, SQL Azure

Azure SQL database for the on-premises DBA changes patching and backups, while leaving query tuning, access, cost, and recovery checks with your team.

Read More
A plain removable wooden tray fits inside a larger open storage box on a table.

Running SQL Server in a Container for Testing

September 24, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Create a SQL Server container for testing from Windows PowerShell, keep data in a named volume, and separate disposable runtime from backups.

Read More
Curved wooden reading nook with books.

Puzzle – Usage of New Index Hints – ForceSeek and ForceScan

September 23, 2011
Pinal Dave
SQL Puzzle
Query Hint, SQL Index, SQL Server

SQL Server Denali adds the FORCESCAN hint next to FORCESEEK. A weekend puzzle on these Index Hints: write a query where each one improves performance.

Read More
Two empty baking tins on a floured bench, a deep square one and a long shallow one, a hand reaching for the long tin.

SSAS Tabular vs Multidimensional: Choosing for a New Project

September 22, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL Analysis Services, SQL Server

Compare Tabular vs Multidimensional for SSAS projects, including storage, relationships, write-back, team skills, and model checks.

Read More
A line of stone cairns crossing a misty moor, the nearest one half built with loose stones beside it.

Logging ETL Runs in a Table

September 22, 2011
Pinal Dave
SQL Tips and Tricks
ETL, SQL Log, SQL Server, SQL Server Agent

Logging ETL runs in SQL Server gives each step start and end times, row counts, and errors so the next morning’s investigation has facts.

Read More
An open wooden toolbox on a bench with a row of new hand tools laid out beside it.

SQL SERVER 2012 Functions – 14 New Functions – A Quick Guide

September 21, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server

All 14 new SQL Server 2012 Functions in one quick guide, from TRY_CONVERT and PARSE to DATEFROMPARTS and CHOOSE, each linked to my post and Books Online.

Read More
EOMONTH() query results in SQL Server Management Studio.

SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction

September 20, 2011
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts

A quick introduction to the EOMONTH function in SQL Server Denali: get the last day of the month for a date, one of seven new date and time functions.

Read More
SQL SERVER 2012 - DateTime Functions - DATEFROMPARTS() - DATETIMEFROMPARTS() - DATETIME2FROMPARTS()

SQL SERVER 2012 – DateTime Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS()

September 19, 2011
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server 2012

SQL Server 2012 adds seven new datetime functions, such as DATEFROMPARTS, DATETIMEFROMPARTS and EOMONTH. A quick look at building dates from their parts.

Read More
Previous 1 … 402 403 404 405 406 407 408 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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