There are two different methods to retrieve the list of Primary Keys and Foreign Keys from the database.
SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY
I maintain a spreadsheet of questions sent by users and from that I single out a topic to write and share my knowledge and opinion. Unless and until I find an issue appealing, I do not prefer to write about it, till the issue crosses the threshold. Today the question that crossed the threshold is – what is the difference between NORECOVERY and RECOVERY when restoring database and what is the restore sequence.
SQL SERVER – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
I assume you all know that there are three types of Database Backup Models, so we will not discuss on this commonly known topic today. In fact, we will just talk about how to restore database that is in full recovery model. Let us learn about backup timeline.
SQLAuthority News – Request SQLAuthority.com Stickers and SQL Server Cheat Sheet
I have been overwhelmed with the request for SQL Server Cheat Sheet recently. I absolutely think it is tremendously useful; its hand written form is adorning my wall since a long time. Having realized its usefulness I got it done professionally and distributed it at TechEd in Hyderabad, TechEd in Ahmedabad, and TechEd on Road in Trivendrum. Now, they are very much in demand.
SQL SERVER – Languages for BI – MDX, DMX, XMLA
Today, we have a very basic thing to go over. Few days back, I was discussing with one of my friends regarding BI. He told me that he knows that BI stands for Business Intelligence but he would like to know what languages BI uses to achieve the goal. The reason I found this question very interesting was because I was asked the same question two weeks back at TechEd on Road Ahmedabad. I had promised one of the attendees that I will reply to his question soon. This question, which my friend asked recently, reminded me of the same. Let us go over the languages of BI very quickly. Again, these are just definitions and there is much more to learn. Moreover, to master each language it may take years.
SQL SERVER – SQL Server Management Studio New Features
This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time.
SQL SERVER – Delete Duplicate Rows
I had previously penned down two popular snippets regarding deleting duplicate rows and counting duplicate rows. Today, we will examine another very quick code snippet where we will delete duplicate rows using CTE and ROW_NUMBER() feature of SQL Server 2005 and SQL Server 2008.