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 - Using MaxTransferSize parameter with SQL Server Backups

SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups

March 30, 2015
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

A DBA asked whether backups on new EMC storage should use a 256 KB transfer size. Here is what I learned about the MaxTransferSize parameter.

Read More
SQL SERVER - Where is ERRORLOG? Various Ways to Find ERRORLOG Location

SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location

March 24, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Scripts, SQL Server

When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.

Read More
Two archived file canisters beside empty slots in a new cabinet

Interview Question of the Week #012 – Steps to Restore Bak File to Database

March 22, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts

Restore bak file backups safely with header and file inspection, complete Windows paths, conditional access changes, and recovery options.

Read More
SQL SERVER - Backup on mapped drive failing with error - Error 3201, Level 16, State 1

SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1

March 18, 2015
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server

Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.

Read More
Gouache painting: one brass key hanging on a post beside a long row of identical wooden garden gates in a stone wall, every gate ajar, a small vermilion ribbon tied to the key

Add a User Across Databases: A Tested Script With Cleanup

March 9, 2015
Pinal Dave
SQL Tips and Tricks
Dynamic SQL, SQL Login, SQL Scripts, SQL Server Security

To add a user across databases you need one login and, in every chosen database, a user and a role. This post gives a tested script that does it, checks it and removes it again on SQL Server 2025. It also answers the model database question and shows the server-level shortcut.

Read More
A selected red cup marks one position within a continuous seasonal storage sequence.

SQL SERVER – Converting YYYYDDD Ordinal Date Codes Safely

March 2, 2015
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

This Julian date example uses an ordinal YYYYDDD code. I distinguish that business encoding from an astronomical Julian day number.

Read More
A music-box mechanism with separate cylinders for repeated passages

Interview Question of the Week #009 – Is GO T-SQL Statement?

March 1, 2015
Pinal Dave
SQL Interview Questions and Answers
SQL Command, SQL Scripts, SQL Server

Explain GO T-SQL confusion with batch boundaries, GO repetition, variable scope, semicolon errors, and a procedure creation example.

Read More
Previous 1 … 165 166 167 168 169 170 171 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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