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

SQL SERVER – How to View Objects in mssqlsystemresource System Database?

September 11, 2015

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

The series of interview questions are always fun. Sometimes I get to hear strange questions and are worth a detailed post. This blog is in continuation to one such question that landed into my Inbox which I personally felt had to have little explanation. During interviews there would be at…

SQLAuthority News – Ryan Adams Running for PASS Board of Directors

September 11, 2015

Pinal Dave

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

SQL PASS

I recently learned that Ryan Adams is running for the PASS Board of Directors. I care for PASS which is a Professional Association of SQL Server. I care about who runs PASS as it directly affects my daily routine. Every year, I spend a good amount of time in making sure…

SQL SERVER – Column Alias and Usage in Where Clause

September 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Server

You can assign a new name for a derived column in the SELECT statement which is also known as an alias name. But you need to understand how column alias are assigned and its scope

SQL SERVER – Identify Time Between Backups Calculation

September 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL DMV

As part of my script archives, I stumbled upon a script that I had written a long time back and thought this must get to the blog. This script was inspired from a simple question asked by an DBA when I had visited them for a session. The question was…

Interview Question of the Week #035 – Different Ways to Identify the Open Transactions

September 6, 2015

Pinal Dave

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

Question: What are different ways to identify open transactions in SQL Server? Answer: There are many ways to identify the open transactions. If there are some transactions which were started and not yet committed or rollback, you can use any of these to find them Use DBCC command There is a…

SQL SERVER – How to Enable or Disable All the Triggers on a Table and Database?

September 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Trigger

Here is the quickest way to disable all the triggers for a table. Please note that when it is about the table, you will have to specify the name of the table. However, when we have to enable or disable trigger on the database or server, we just have to…

SQL SERVER – Configure the Backup Compression Default Server Configuration Option

September 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

When I get a chance to talk to Enterprise customers working with a really smart DBA team, I generally look out for options they use on a daily basis and are often missed in the bigger scheme of things. One such feature of SQL Server Enterprise Edition is the ability…