Refactoring and static code analysis tool for SQL Server
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.

Date Calculations made easy..

DateTime is a very useful yet complex datatype in SQL. I have heard many people saying they are not comfortable when it comes dealing with Date calculations. Let us take a closer look at various functions used for date calculations. DAY Returns an integer...
by Divya Agrawal on 03-15-2010 | 360 Views

SQL Server Backup command

Every SQL Server developer have a basic knowledge of Backup commands. Well, this command come with a huge number of different options which can be highly useful in various ways. You can refer the complete list of Backup commands with all the options on...
by Divya Agrawal on 02-09-2010 | 424 Views

Data Flow Transformations in SSIS

Well, let me share this time something related to SSIS. Many of you might be using this feature provided by SQL Server for importing or exporting data to and from different sources. Let me share you something about the “Data Flow Task”. “Data...
by Divya Agrawal on 09-26-2009 | 1,996 Views

Query Execution Plan – Continued..

In my previous post I have shown you how to deal with Key Lookup. Going more into the depth of Lookups, there is another Lookup called RID LookUp . Both of these LookUp’s are categorized under Bookmark LookUp. Bookmark Lookup occurs when a non-clustered...
by Divya Agrawal on 09-13-2009 | 369 Views

Query Execution Plan

I have been looking onto how Query Execution Plan works on internet. It shows the execution plan SQL Server Query Engine used to achieve the output. There are numerous operators used when the query is complex enough to show the plan. Well, i am assuming...
by Divya Agrawal on 09-01-2009 | 329 Views

Uses of local-name function of XQuery

I was just surfing net and came across a very good function " local-name ". When i searched for its defination in Books Online I found it as a function which "Returns the local part of the name of $arg as an xs:string". It means that...
by Divya Agrawal on 07-30-2009 | 451 Views

Concatenate multiple rows delimited by comma

You might have heard about people looking for concatenating more than one rows into a csv string. Previously i found out difficult enough. I used coaelesce to do that . But coaelesce usually asks for a varibale to be declared and updates the values in...
by Divya Agrawal on 07-29-2009 | 1,215 Views

Copyright © Beyondrelational.com