Hi, How to get last 5 rows from table without using order by clause and there is no primary key in the table.. Thanks...

hello sir I am designing a project for online test series for all subject like mathematics, physics, chemistry, . I have a problem in storing mathematical equation which includes special symbols an in organic chemistry structural formulas etc.How can we...

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Introduction Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A general table structure which people come up to store this kind of data is - Where, EmployeeID id the UniqueID alloted to every new employ...

On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this question. Actually speaking, without explicit logging or tracing, it is no...

In my previous post we see how to move MSDB database, today we will see how to move or relocate MASTER database. While moving MASTER database we’ll have to consider few other things like changing start-up parameter for SQL Server Service. I will also me...

In recent past we have a situation where in we required to move MSDB, Model and Master databases to new location, the reason being faulty drive. While moving system databases to new location we need to be extra cautious. Let’s see the process step-by-st...

`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed what’s new in SQL Server 2012 setup, MS has released SQL Server 2012 training kit and made it available for us to download. In recent past,...

Use NOLOCK hint to avoid block - this is what I have often heard/see in many forums I participate, during local user group events and meeting. I have always advised that its not that good idea to use hints, as it may cause data corruption and blocking. ...

MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL Server 2008 SP 3, this build version is 10.00.5768.00. Below are the bugs that have been fixed in this CU: FIX: A backup operation...