ACID (an acronym for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved.
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 – FIX : Error : 3702 Cannot drop database because it is currently in use.
Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. This is a very generic error when DROP Database is command is executed and the database is not dropped. The common mistake user is kept the connection open with this database and…
Read MoreSQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)
Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. They can exactly tell what is going on with SQL Server and its objects at the moment.There are tow kinds…
Read MoreSQL SERVER – UDF – Remove Duplicate Chars From String
Few days ago, I received following wonderful UDF from one of this blog reader. This UDF is written for specific purpose of removing duplicate chars string from one large string. Virendra Chauhan, author of this UDF is working as DBA in Lutheran Health Network. CREATE FUNCTION dbo.REMOVE_DUPLICATE_INSTR (@datalen_tocheck INT,@string VARCHAR(255))…
Read MoreSQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource
Yesterday I had meeting with few of the leading outsourcing companies in Ahmedabad, India. Regular readers of this blog knows that I am currently in India handling large scale outsourcing assignment. My responsibilities includes managing application development, system architecture and database architecture. The purpose of meeting was to exchange the…
Read MoreSQL SERVER – Grouping JOIN Clauses In SQL
I always enjoy writing and reading articles about JOIN Clauses. One of my friend and the best ColdFusion Expert Ben Nadel has written good article about SQL JOINs. There are few interesting comments as well at the end of article. “JOIN grouping is pretty powerful and can get you out…
Read MoreSQL SERVER – Q and A with Database Administrators
I have been in India for more than a month now, as I am leading a very large outsourcing project. We have conducted few interviews since the project required more Database Administrators and Senior Developers. I am listing few of the questions discussed during all the interviews. The whole event…
Read MoreSQL SERVER – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator
Read my article in SQL Server Magazine December 2007 Edition I will be not able to post complete article here due to copyright issues. Please visit the link above to read the article. [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQLAuthority News – Download SQL Server 2005 Books Online (September 2007)
Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The September 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and…
Read More