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

SQL SERVER – Script to find SQL Startup Account using WMIC

March 31, 2015

Friends are your lifeline that keep your life interesting. I have various friends’ circles that range from family, acquaintances, work and the most exciting circle is the technical circles. Most of the times the tech circles is what fuels most of the post that lands up here. I was talking…

SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups

March 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server

Off late I have been writing a lot around SQL Server backups and administration topics. I have seen a lot of my readers have been enjoying some of the deep conversations I have with people in the industry. As I always say, most of the blog posts are inspired by someone asking me a question, me doing the research and then reaching out to them to give a solution. This blog post is no different in that aspect.

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

March 29, 2015

Pinal Dave

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

SQL Stored Procedure

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…