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

SQL SERVER – Msg 1206, Level 18, State 118 – The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

November 6, 2014

The saga of working with error messages continues. Here is an error that was shared at one of the User group meetings by a member. While working via linked server to do data manipulation they reported this error on their servers: Msg 1206, Level 18, State 118, Line 9 The…

SQL SERVER – Table Space Allocation Details using DMV

November 5, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV

Understanding SQL Server from inside-out is always something I have loved to learn from time to time. Recently, I was asking my good friend Balmukund on how are pages allocated inside SQL Server and what are the various ways to find the same. He was quick to bounce and say…

SQL SERVER – Using Bitwise And (&) Instead of a Junction Table – Notes from the Field #053

November 5, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 53rdth episode of Notes from the Field series. Everyday I get 100s of emails and most of the emails have a similar request. Everyone wants to get maximum performance, but they want to make the least amount of changes in their code. Well, though…

SQLAuthority News – Get My Two Books FREE at #SQLPASS

November 4, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Every year when I visit SQLPASS, I do book signing where I give away my books for free. This year there are two opportunities when I am going to give away my books for free. Though the books are in great numbers they always run away early. I strongly suggest that…

SQL SERVER – PowerShell way of Restarting SQL Server Service

November 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

I learn a lot when I go for conferences all around the world. There are styles, content and cultural differences that I get a chance to learn and enjoy as part of my trips. Most of these trips I make are geared towards at least one learning experience I can…

SQL Authority News – Presenting Session at #SQLPASS on November 5, 2014

November 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL PASS

I will be attending SQLPASS 2014 this year in Seattle. I have attended SQLPASS 5 times before and this is my sixth times for the event. I love this event and that is why every single year I attend the event. This time I will be presenting on session Secrets…

SQL SERVER – Why my Database is in Restoring Mode After Taking Backup?

November 1, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Once upon a time there was a SharePoint consultant named Pepper. She wanted to learn about SQL Server Administration/DBA work. While she was a master SharePoint consultant at her office in Bethel she grew curious to learn SQL Server. She wanted to be independent when dealing with SQL server chores…