Assume that there are two tables table1 and table2 which have same structures and table1 has 10 millions rows and you want to move all rows from table1 to table2. The quickest method that I have learnt is to use Partition Switching [code] alter table ta

Recently watched an inspiring regional movie, where actor asks actress to take her birth date, and multiply day with 12 and Month with 31 and add those results. As soon as she tells the result, in 3-4 seconds, actor will tell her birth date. At first glanc

In few scenarios, we might use types of other programming languages, and the operations on that type. But if those types are not recognized in compile-time, it will throw compile-time errors. By declaring the type as dynamic it will bypass compile time err

We all know that a static variable will be shared by entire class instead of objects. What about Generic Types?? Suppose, from a generic type, if 2 constructed types created, will they maintain different copy or same copy?? They will maintain their own cop

Today, my colleague asked me an interesting question. In below code snippet, what is A<T> and A<int> called as? Are both of these are classes? If so, How can you differentiate these while calling them? [code] class A<T> { } clas

In Earlier versions of .NET, String class has IsNullOrEmpty() method, which can be used to check whether the string is null or empty. To check for white spaces, we need to write additional code. Now .NET 4.0 introduced a new method, IsNullOrWhiteSpace()

I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing: [code] /* I would like to insert information from table Pro

Both RegisterClientScriptBlock & RegisterStartupScript can be used to register script in web page. However script registered through "RegisteredClientScriptBlock" method will be rendered before any page elements rendered, where as script registered through

Many people believe that table variables are stored in memory (RAM) and temp tables are stored in tempdb. I can see a few comments around this post. (http://beyondrelational.com/justlearned/posts/262/sql-server-difference-between-temp-table-and-table-varia

OUTPUT clause can return in parallel way both INSERTED and DELETED rows. It is useful to logging in archive original and new values. [code] ... OUTPUT DELETED.value [oldValue], INSERTED.value [newValue] [/code]