Archive for the ‘General’ Category
Find percentage of work completed in SQL Server 2005
Posted by: Manpreet Singh on: May 25, 2009
Yesterday, I and my friend were taking manual backup of database on development server through management studio and suddenly management studio stop responding. I knew that this is happening due to the load added by backup process. We were wondering if there is any TSQL statement through which we can find the status of task [...]
Cursor free way to kill connections with SQL database
Posted by: Manpreet Singh on: May 11, 2009
We all work with database scripts and there are times when we need to exterminate connections with any specific database. Theoretically it seems quite straightforward as we only need to build a script which use cursor to loop through all the connections and eradicate them one by one. But practically speaking , it’s not as [...]
SQL Server Naming Conventions
Posted by: Manpreet Singh on: September 9, 2008
- In: General| RDBMS
- Leave a Comment
Naming conventions are as important as a solid design to database. It is very important to name your table, views and stored procedure in a ways so that anyone could easily understand the query or structure of table in first glance. Poor naming convention can result in a lot of problems for both yourself [...]
OLAP Databases with SQL Server 2005
Posted by: Manpreet Singh on: August 27, 2008
With the arrival of SQL server 2005. it become the no 1 solution for OLAP databases(for windows server system). It is often consider that one database model can be used for OLAP and OLTP database. OLAP stands for Online Analytical Processing, this kind of database are used for a analysis services and have its own [...]
