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 - Always On Availability Group Listener Missing in SSMS but Working Fine in Failover Cluster Manager

SQL SERVER – Always On Availability Group Listener Missing in SSMS but Working Fine in Failover Cluster Manager

January 24, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Computer Network, SQL High Availability, SQL Scripts, SQL Server, SQL Server Cluster, SQL Server Management Studio

My client’s AG listener worked fine in Failover Cluster Manager, yet SSMS showed nothing. Here is what causes a listener missing in SSMS and the fix.

Read More
Gouache painting of a wooden shape sorter box with matching blocks and one vermilion star block beside it

Find the Data Type of an Expression in SQL Server

January 23, 2019
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts

To find the data type of an expression in SQL Server, pass it to SQL_VARIANT_PROPERTY or describe the whole query with sys.dm_exec_describe_first_result_set. This post tests both on a percentage calculation, shows how precision and scale come out, and explains why 2147483647 plus 1 fails.

Read More
SQL SERVER - FCB::Open Failed - TEMPDB Files Fail to be Created with Error: "CREATE FILE Encountered Operating System Error 3"

SQL SERVER – FCB::Open Failed – TEMPDB Files Fail to be Created with Error: “CREATE FILE Encountered Operating System Error 3”

January 21, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL TempDB

SQL Server would not start: FCB::Open failed because TempDB files could not be created, with operating system error 3. Here is how I fixed it.

Read More
An open garden gate allows passage while sturdy braces keep its frame stable

Does NOLOCK Really Applies No Lock? – Interview Question of the Week #209

January 20, 2019
Pinal Dave
SQL Interview Questions and Answers
Query Hint, Schema, SQL Lock, SQL Scripts, SQL Server

Does NOLOCK really applies no lock? No. NOLOCK takes a Sch-S, or schema stability, lock. Here is a simple script to see it for yourself.

Read More
SQL SERVER - FIX: Msg 8180 - Statement(s) Could not be Prepared. Deferred Prepare Could not be Completed

SQL SERVER – FIX: Msg 8180 – Statement(s) Could not be Prepared. Deferred Prepare Could not be Completed

January 14, 2019
Pinal Dave
SQL Tips and Tricks
Linked Server, SQL Error Messages, SQL Scripts, SQL Server

A linked server query with OPENQUERY gave Msg 8180: Statement(s) could not be prepared. Deferred prepare could not be completed. Here is what I learned and the fix.

Read More
A handcart carries a millstone from a crowded workshop to a roomier adjacent space

How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208

January 13, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Performance, SQL Scripts, SQL Server, Transaction Log

Question: How to Move Log File or MDF File in SQL Server? Here are the steps I use to move a busy LDF or MDF file to a quieter drive.

Read More
SQL SERVER - FIX: Msg 9514 - XML Data Type is Not Supported in Distributed Queries

SQL SERVER – FIX: Msg 9514 – XML Data Type is Not Supported in Distributed Queries

January 11, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server 2019, SQL XML

Querying a table with an XML column over a linked server fails with Msg 9514: XML data type is not supported in distributed queries. Here is the fix.

Read More
Previous 1 … 80 81 82 83 84 85 86 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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