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

submitted by pinaldave 1 month, 2 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 1 month, 24 days ago, submitted by pinaldave 1 month, 25 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: 311

SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search

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

blog.sqlauthority.com — This is the first ever and complete example for SQL Server 2008 - Full Text Catalog and Full Text Search. Make sure to book mark for future reference. read more...

2 comments | category: Database | Views: 188

Introduction to Filtered Index - Improve performance

submitted by pinaldave 2 months, 19 days ago

blog.sqlauthority.com — Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. When we see an Index created with some WHERE clause then that is actually a FILTERED INDEX. I am sure this feature will change how the indexes are created in SQL Server. read more...

1 comment | category: Database | Views: 9

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN

published 3 months, 18 days ago, submitted by pinaldave 3 months, 19 days 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: 250

SQL Server Pre-Code Review Tips - A list of tips for enforcing coding

submitted by pinaldave 1 year, 1 month ago

dotnetslackers.com — Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep watch on all stored procedures, at frequent intervals, before code comes to final code review. read more...

1 comment | category: Database | Views: 2

Scrum: Agile Software Development for Project Management

published 1 year, 2 months ago, submitted by pinaldave 1 year, 2 months ago

blog.sqlauthority.com — Scrum is organized around the following roles: * Product Owner - Determines what functionality is needed * ScrumMaster - Leads the Scrum and is primarily responsible for making sure the Scrum process is followed and removing impediments that keep the Team from working * The Team - Those who do the actual work that translates what the Product Owner has requested into usable functionality Read more ... read more...

4 comments | category: Database | Views: 6

SQL SERVER - Restore Database Without or With Backup - Everything Abou

submitted by pinaldave 1 year, 3 months ago

blog.sqlauthority.com — The questions I received in last two weeks: “I do not have backup, is it possible to restore database to previous state?” “How can restore the database without using backup file?” “I accidentally deleted tables in my database, how can I revert back?” “How to revert the changes, I have only logs but no complete backup?” “How to rollback the database changes, my backup file is corrupted?” Answer: You need complete backup to rollback your changes. If you do not have complete backup you can not revert back. Sorry. read more...

add a comment | category: Database | Views: 0