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

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

January 24, 2016

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

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…

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…

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

January 17, 2016

Pinal Dave

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

SQL System Table

Sometimes questions in the interview are extremely open ended and such questions can be very useful for candidate to play around with. For example, in one of the recent interview one of the interviewer asked the candidate that what is his favorite T-SQL script as a database administrator. The answer…

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

January 16, 2016

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

The topic around performance tuning is the most sought out search on this blog. Almost every single day the top search that lands here are around performance or around some random errors one might receive from the application. If you are a DBA, the first high level tool that you…

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

January 15, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

Writing utility scripts are one way to become smarter when working with computers. From time to time I get asked about some tasks folks use repetitively and are being counterproductive. On this note, I wanted to paint a scenario which I saw one of the DBA’s doing on their environment…