SQL Archives - Page 93 of 519 - SQL Authority with Pinal Dave

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

January 25, 2016

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 – Script: Change Service Account Using WMI / SMO

January 23, 2016

Pinal Dave

SQL

Powershell, SQL DMV, WMI

Last week I wrote a post where my friend faced problem because he changed the service account of SQL Server from services. mass rather than SQL Server Configuration Manager. Let us learn how to change service account using WMI/SMO.

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…

SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early

January 21, 2016

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server

While trying to prepare for a demo, I ran into some interesting error. When I searched for error about STOPAT on the internet, there were not many clear answers so I thought of sharing on my blog. Actually, my demo was all about point in time restore feature of SQL Server. I was trying something similar given in my earlier blog.

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…

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

January 19, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP

When InMemory OLTP was introduced in SQL Server 2014, there were a number of limitations that restricted customers to effectively use the capability. One of the most commonly asked capability was around the ability to create Foreign Keys. On first look, I thought this was always available. But while experimenting…