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

Interview Question of the Week #013 – Stored Procedure and Its Advantages – How to Create Stored Procedure

March 29, 2015

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

There are some questions which are so old that they should not be asked in the interview and gets old. Here is one of the questions I have spotted so many times in the interview that if co-interviewer asks to the candidate, I often feel bored (well, I was caught…

SQL SERVER – System procedures to know SQL Server Version

March 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events, SQL Stored Procedure

There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? They are SP_SERVER_INFO and EXEC XP_MSVER EXEC sp_SERVER_INFO If you execute the above, you get a result set with informations about the…

SQL SERVER – Find the Growth Size for All files in All Databases

March 27, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I am a big time advocate of some common best practices that I see in the industry. These have been ingrained into every session that I do be it SQL Server, MySQL or any other databases. Though I work extensively on SQL Server and from time-to-time on other databases, the…

SQL SERVER – Mistake to Avoid: Duplicate and Overlapping Indexes – Notes from the Field #073

March 26, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Index

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about indexes and its impact. We often believe that indexes will improve the performance of the query, but it is not true always. There are cases when indexes can reduce the performance as well. Read…

SQL SERVER – Knowing Nested Transactions Behavior with SQL Server

March 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Transactions

SQL Server is an interesting database system that baffles me every single day that I get to learn something new. This blog has been my way to share these learnings. Every time I write something new, my blog readers have been kind enough in pushing me with interesting comments that…

Interview Question of the Week #012 – Steps to Restore Bak File to Database

March 22, 2015

Pinal Dave

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

SQL Scripts

Here is the question, I was asked the other day at the conference. Question: If I have a .bak file and I want to restore it database what are the various steps involved in it. Assume that I do not know much about that backup file. Answer: I love this question,…

SQL SERVER – Trivia – Days in a Year

March 21, 2015

Pinal Dave

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

SQL DateTime

Every time I wrote a blog, I tend to get back to most of them via the search. Most of you ask me questions and I do few simple search back to make sure I am able to address them. Yesterday as I was searching for an interesting question, Now…