SQL Server Archives - Page 23 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Puzzle – Working with functions to Concatenate columns

July 10, 2015

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Every now and then I get pulled into coding review sessions and those are some of the fun times I every have working with T-SQL of any sorts. This blog is inspired by one such time where I saw at a customer location a code that was lengthy and in…

SQL SERVER – 2016 FIX: Install – Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed

July 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I enjoy spending time with my daughter almost every single day. It keeps me busy at home and most importantly, some quality time with her allows me to relax after a long day at work. But there one thing that has caught my attention every single day I have been…

SQL SERVER – Identifying Blocking Chain Using SQL Scripts

July 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

There are a number of blog posts that have been written on this very topic. This can be from basics to almost advanced in many ways. I am outlining some of them here below: SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution SQL SERVER…

SQL SERVER – Creating Dataset Using VALUES Clause Without Creating A Table

July 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

You know that you can add data to a table using VALUES clause. But did you know that you can create a dataset using VALUES clause like a table without adding into another table? Suppose you want to create a data set with two columns named a and b SELECT…

SQL SERVER – Secure by Default – The Mantra

July 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

Generally the talks I give at conferences revolve around performance and tuning. These are always the most sought after topic and I don’t disappoint the requests because they give me an opportunity to learn something new too. Last month when I visited Sri Lanka for the first ever SQLSaturday event,…

SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level

July 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Transaction Isolation

It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. I have seen many DBAs getting confused between these two terms because both of them…

SQL SERVER – Steps to Generate Windows Cluster Log?

July 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Log

Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. It is tough to learn everything all by ourselves, so learning is best done by sharing. There are many incidents with SQL cluster…