Tags » SQL Authority

Interview Question of the Week #013 - Stored Procedure and Its Advantages - How to Create 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 yawning last time). 211 more words

SQL Authority

SQL SERVER - System procedures to know SQL Server Version

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? 102 more words

SQL Authority

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

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. 379 more words

SQL Authority

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

: 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. 1,028 more words

SQL Authority

SQL SERVER - Knowing Nested Transactions Behavior with SQL Server

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. 499 more words

SQL Authority

SQL SERVER - Where is ERRORLOG? Various Ways to Find its Location

Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. 411 more words

SQL Authority

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

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. 165 more words

SQL Authority