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
Msg 15281 Error from SQL Server.

SQL SERVER – FIX: Msg 15281- SQL Server Blocked Access to Procedure ‘sys.xp_cmdshell’ of Component ‘xp_cmdshell’

February 16, 2017
Pinal Dave
SQL Tips and Tricks
SQL Command, SQL Error Messages, SQL Scripts, SQL Server

Msg 15281: SQL Server blocked access to procedure ‘sys.xp_cmdshell’ because it is turned off. Here is how to turn xp_cmdshell on with sp_configure.

Read More
A rack holds separate sealed backup parcels, with a new one added at the end

How to Add Date to Database Backup Filename? – Interview Question of the Week #109

February 12, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Backup and Restore, SQL Scripts, SQL Server

A reader using Backup to URL asked how to add the date to a Database Backup Filename. Here is a script that builds the name for you.

Read More
SQL Server sp_spaceused window.

SQL SERVER – Puzzle – Why does sp_spaceused Show No Values?

February 8, 2017
Pinal Dave
SQL Puzzle
SPARSE Columns, SQL Scripts, SQL Server

Why does sp_spaceused show no values for a table that clearly has rows? It stumped me for 10 minutes. Here is the puzzle, try it before reading on.

Read More
6.3 os info sql.

SQL SERVER – SQL Server: Getting OS information using DMV

February 6, 2017
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, Windows

Need the Windows version SQL Server runs on? Get OS information with the sys.dm_os_windows_info DMV, or read it from the ERRORLOG at startup.

Read More
One sewing tool makes a new seam while another refreshes a worn seam

How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108

February 5, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Statistics

Question: How to Enable Auto Update Statistics and Auto Create Statistics? Let us learn how we can fix that in today’s blog post.

Read More
Gouache painting of a worker moving blocks beside a temporary storage tank with a colored space gauge

SQL SERVER – Script to Find and Monitoring TempDB Space Usage

February 2, 2017
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL TempDB

Monitor tempdb space usage with separate data-file and log checks. Find task allocations and open transactions before choosing a remedy.

Read More
Sql sever error dialog.

SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP

January 31, 2017
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Error Messages, SQL Scripts, SQL Server

Can an InMemory table have a foreign key to a disk-based table? I tried it and got Msg 10778. Here is what the error means and the limits to know.

Read More
Previous 1 … 133 134 135 136 137 138 139 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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