Database Migration, Comparision and Synchronization Tools
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Temporary Tables and Table Variables An Overview

Some days back i was asked about Temp Tables and Table Variables the basic difference why one is better than another one and all, and i am not able to provide a satisfactory reason\answer at that time so this is the time when i studied about a lots about...
Posted: 07-31-2009 9:50 AM by Ashish Gilhotra | with 3 comment(s)
Filed under: , , , , ,

BackUp Status Script

This time its all about a script a backup script.Today early morning i asked to get BackUp details for some of DB’s we have, usually they ask me about the last BackUp taken so its easy for me to tell him. But this time he needs all the history of...
Posted: 07-22-2009 2:17 PM by Ashish Gilhotra | with no comments
Filed under: , , , ,

T-SQL Challenges

Hi All … You all must here about T-SQL Challenges , these challenges are ideal to learn Set Based Queries using TSql. The most beneficial part of these challenges is that, through these challenges , you get a chance to see better solution to solve...
Posted: 07-08-2009 4:05 AM by Ashish Gilhotra | with no comments
Filed under: , ,

Who Created a Table – DDL Triggers in SQL SERVER 2008

Hi all this post is about the new features in SQL Server 2008 .. SQL Server 2008 has a power full feature called DDL triggers which uses for Auditing changes in database and this is very useful too. You will find a blog entry about auditing using transaction...
Posted: 06-30-2009 10:02 AM by Ashish Gilhotra | with no comments
Filed under: , , ,

Encryption & Decryption Part II

Hi all me again here with a post about Encryption & Decryption in Sql Server 2005.I have received a couple of questions regarding my article Encryption & Decryption in Sql Server 2005 , so i started responding through mail but because i found...
Posted: 06-29-2009 9:34 AM by Ashish Gilhotra | with no comments
Filed under: , , ,

Error/Exception Handling in SQL Server 2005

Being a .Net developer, the most useful feature i found was the Error Handling or Exception Handling technique.When it comes to programming languages , all popular OOP languages have TRY()…Catch() method to handle an exception. In Sql Server 2005...
Posted: 05-09-2009 11:16 AM by Ashish Gilhotra | with no comments
Filed under: , , ,

Data/Table Partitioning

Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. It helps us to split the larger tables and data in to smaller parts. In a few word this means that you can...
Posted: 05-04-2009 11:12 AM by Ashish Gilhotra | with no comments
Filed under: , , ,

Copyright © Beyondrelational.com