Transaction and Local Variables - Swap Variables - Update All At Once

submitted by pinaldave 1 month, 13 days ago

blog.sqlauthority.com — Summary : Transaction have no effect over memory variables. When UPDATE statement is applied over any table (physical or memory) all the updates are applied at one time together when the statement is committed. read more...

1 comment | category: Database | Views: 8

SQL SERVER - Guidelines and Coding Standards Complete List Download

published 2 months, 4 days ago, submitted by pinaldave 2 months, 6 days ago

blog.sqlauthority.com — Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where they should not prevent best practices for coding. They are basically the guidelines that one should follow for better understanding. The concept behind implementing coding standards and guidelines, is that the consistency and uniformity in programming so that if multiple people are working on the same code, it becomes easier to communicate, share with or understand each other’s work. With the goal of promoting good coding standards and guidelines I have created document which can guide developers. read more...

3 comments | category: Database | Views: 315

SQL SERVER - 2008 - Interview Questions and Answers - Download PDF

published 2 months, 12 days ago, submitted by pinaldave 2 months, 13 days ago

blog.sqlauthority.com — Interview is very important event for any person. A good interview leads to good career if candidate is willing to learn. I always enjoy interview questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server is very large subject and not everything is usually asked in interview. In interview what matters the most is conceptual knowledge and learning attitude. I have listed all the series in this post so that it can be easily downloaded and used. All the questions are collected and listed in one PDF which is here to download. If you have any question or if you want to add to any of the question please send me mail or write a comment. Bookmark this first ever set of interview questions and answers. read more...

2 comments | category: Database | Views: 310

Introduction to Table-Valued Parameters with Example

submitted by pinaldave 3 months, 1 day ago

blog.sqlauthority.com — Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing so many parameters. This is one feature all the SQL Server developer were waiting for long time. This article explains how it can be used with very simple words. read more...

1 comment | category: Database | Views: 13

Changing Your Garbage Collector Settings on the Fly

published 3 months, 1 day ago, submitted by Rickasaurus 3 months, 1 day ago

atalasoft.com — .NET 3.5 and 2.0 SP1 jointly included a new feature which lets you programmatically manipulate the way your garbage collector acts. This can be done through changing the value of a new property of the System.Runtime.GCSettings class named LatencyMode. In this article I will walk you through this new property and the different effects of each of it's possible settings. read more...

add a comment | category: Tips & Tricks | Views: 243

Google Chrome and Web Standards

aggiorno.com — How does the adoption of Google Chrome affect cross browser compatibility? Are web standards a solution? How can I easily move to standard compliant pages? read more...

add a comment | category: IE | Views: 460

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN

published 3 months, 29 days ago, submitted by pinaldave 4 months, 1 day ago

blog.sqlauthority.com — INTERSECT operator in SQL Server 2005 is used to retrieve the common records from both the left and the right query of the Intersect Operator. INTERSECT operator returns almost same results as INNER JOIN clause many times. When using INTERSECT operator the number and the order of the columns must be the same in all queries as well data type must be compatible. Let us see understand how INTERSECT and INNER JOIN are related.We will be using AdventureWorks database to demonstrate our example. read more...

3 comments | category: Database | Views: 251

SQL SERVER - Better Performance - LEFT JOIN or NOT IN?

published 7 months, 10 days ago, submitted by pinaldave 7 months, 12 days ago

blog.sqlauthority.com — What do you think? I am sure result will surprise you. read more...

2 comments | category: Database | Views: 21