A few days ago, I was invited to one of the largest database company. I was asked to review database schema and propose changes to it. There was special username or user logic was created for me, so I can review their database. I was very much interested to know what kind of permissions I was assigned per server level and database level. I did not feel like asking their Sr. DBA the question about permissions.
SQL SERVER – Difference Between @@Version and xp_msver – Retrieve SQL Server Information
Just a day ago, I was asked which SQL Server version I am using. I said SQL Server 2005. However, the person I was talking was looking for more information then that. He requested more detail about the version. I responded with SQL Server 2005 Service Pack 2. After the…
Read MoreSQL SERVER – 2005 – Limitation of Online Index Rebuld Operation
Just a day ago, during one interview question of Online Indexing come up. I really enjoy discussing this issue as I was talking with candidate who was very smart. Following two questions were discussed. 1) What is Online Index Rebuild Operation? Online operation means when online operations are happening the…
Read More
SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
As the title is very clear what this post is about I will not write long description. I have listed definition of FILLFACTOR from BOL here.
SQL SERVER – Types of DBCC Commands When Used as Database Console Commands
Just a day ago, while discussing some SQL issues with one of the Sr. Database Administrator in India, we end up discussing DBCC as Database Console Commands when used as T-SQL. We both tried to remember what are the types of DBCC as Database Console Commands and could not come…
Read MoreSQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
Error : Msg 7411, Level 16, State 1 Server is not configured for RPC This was annoying error which was fixed by Jr. DBA, whom I am personally training at my organization. I think he is going to be great programmer. He worked in my organization for more than 8…
Read MoreSQLAuthority News – Book Review – Backup & Recovery (Paperback)
Backup & Recovery [ILLUSTRATED] (Paperback) by W. Curtis Preston (Author) Link to Amazon Short Summary: This book’s does not only teaches you have to create safe backup but it takes you to the next level where a large organization can save tons of dollars a year by making their backup…
Read MoreSQL SERVER – Three T-SQL Script to Create Primary Keys on Table
I have always enjoyed writing about three topics Constraint and Keys, Backup and Restore and Datetime Functions. Primary Keys constraints prevents duplicate values for columns and provides unique identifier to each column, as well it creates clustered index on the columns. -- Primary Key Constraint upon Table Created Method 1…
Read MoreSQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007)
In its continued commitment to interoperability, Microsoft has released a new SQL Server 2005 Driver for PHP. The SQL Server 2005 Driver for PHP Community Technology Preview (CTP) download is available to all SQL Server users at no additional charge. The SQL Server 2005 Driver for PHP is a PHP…
Read MoreSQL SERVER – Explanation and Understanding NOT NULL Constraint
NOT NULL is integrity CONSTRAINT. It does not allow creating of the row where column contains NULL value. Most discussed question about NULL is what is NULL? I will not go in depth analysis it. Simply put NULL is unknown or missing data. When NULL is present in database columns,…
Read More