SQL Tips and Tricks Archives - Page 101 of 536 - SQL Authority with Pinal Dave

SQL SERVER – 2016 Error Reasons: Msg 10778, Level 16 Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported

January 29, 2016

When I was writing the blog SQL SERVER 2016 – InMemory OLTP support for Foreign Key, it felt like a great addition to SQL Server. I felt there must be something that I might be missing as the obvious. I was not wrong in that feeling too. One of my…

SQL SERVER – Add failover cluster node fails with “number of cluster nodes supported for edition”

January 27, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

A lot of my blog readers contact me via comments and I try my best to reply to all of them. Sometimes issue is so interesting that I ask them to contact via email. This blog is result of such an interaction. Asif (name anonymized) was trying to Add third…

SQL SERVER – Timeout expired. The timeout period elapsed prior to completion of the operation

January 26, 2016

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Server, SQL Server Security

Today we are going to learn about how to fix the error: Timeout expired. The timeout period elapsed prior to the completion of the operation.

SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?

January 25, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Batch, SQL Extended Events

Some of the learnings can lead to another exploration when someone does stump you with something you didn’t know. To understand the basics of batch mode and row mode, read the blog SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode where I have explained the concepts. This…

Interview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?

January 24, 2016

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Function

Question: How do you convert ASCII to DECIMAL or DECIMAL to ASCII? Answer: ASCII – Returns the ASCII code value of the leftmost character of a character expression. CHAR – Fixed-length non-Unicode character data with length of n bytes. Examples: --Decimal to ASCII SELECT CHAR(80)+CHAR(73)+CHAR(78)+CHAR(65)+CHAR(76) ASSQLAuthorityAuthor GO --ASCII to Decimal…

SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes

January 22, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

Every version of SQL Server brings new capabilities that enhance the features that were introduced in the previous versions. I am sure the team is working based on the feedbacks given by customers as they starting using the new capability. As I was scanning through some of the enhancements that…

Hyper V: Error and Fix – Fix – Boot failure. Reboot and Select proper Boot device

January 20, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

While trying to deploy new machines on my Hyper-V, I faced an error. Boot failure. Reboot and Select proper Boot device or Insert Boot Media in selected Boot device It was a VHD file which I downloaded from Microsoft site. I searched for the solution on many sites and they…