Regular readers of this blog are aware of my current outsourcing assignment. I am managing very large outsourcing project in India. One thing is very special in all Indian offices are “Tea Time.” Everybody wants to attend Tea Time not only for tea or coffee but for the interesting discussion occurs at that time. This is the time when all the department employees are together and discussing whatever they wish.Today there was an interesting discussion about Quality Assurance (QA) and Quality Control (QC).
SQL SERVER – T-SQL Script to Find Details About TempDB Information
Two days ago I wrote an article about SQL SERVER – TempDB Restrictions – Temp Database Restrictions. Since then I have received few emails asking details about Temp DB. I use following T-SQL Script to know details about my TempDB. This script is a pretty old script but it does work great most of the time. I strongly encourage all of you to use a script to check your TempDB Information.
SQL SERVER – TempDB Restrictions – Temp Database Restrictions
While conducting Interview for my outsourcing project, I asked one question to interviewer that what are the restrictions on TempDB? The candidate was not able to answer the question. I thought it would be good for all my readers to know the answer to this question so if you face this question in an interview or if you meet me in the interview you will be able to answer this question.
SQL SERVER – Generic Architecture Image
Just a day ago, while I was surfing Wikipedia about SQL Server, I came across this generic architecture image. I found it interesting. Click on image to view it in large size. The physical structure of the database is divided into the MDF and LDF. The part of MDF contains file group, data files, tables and indexes, extended and page. The LDF file contains a transaction log file. The physical architecture is about how the data is actually stored in the file system. Page, extend, database files are physical architecture.
SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments.
SQL SERVER – Generate Incremented Linear Number Sequence
Just a day ago, I received interesting question on this blog. Read original question here. This is very good question and after reading this question I quickly wrote small script as answer. Let us see the question and answer together.
Q. How can we generate incremented linear number in sql server as in oracle we generate in via sequence?
SQL SERVER – 2005 – Best Practices for SQL Server Health Check
Here are few of the best practices one should follow for SQL Server Health Check.