Sql Server Articles (246) - Page 14

Database Backup to / Restore from Remote Server - SQL Server 

Backup and Restore is one of the high availability model. In this article, I would like to perform Backup on Remote server and Performing Restore the backup file(.bak) from Remote Server into local SQL Server.

User defined stored procedure should not be Prefixed with "SP_". Why and When ? 

According to Microsoft best practice, User defined stored procedures should not be started with 'SP_'. The reasone is...

Implementing Full-Text Search on View 

Full Text Index is used to perform queries to find-out the character data. These queries can include word or phrase searching. We can create a full-text index on a table or indexed view in the database. Only one full-text index is allowed per table or indexed view.

Exclusive access could not be obtained because the database is in use 

You might get the error related to "Exclusive access could not be obtained because the database is in use" so, in this article we will gain over this error.

CASCADING Referential Integrity in SqlServer 

This article will expalins you how to delete and update a Child Table records implicitly when updating or deleting a Parenet Table.

Deleting Duplicate Rows when the table doesn’t have a primary key. 

This article gives a quick way of deleting duplicate records from a given table, that doesn’t have a primary key.

Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase 

This Article explains you how to Encrypt and Decrypt a text

Policy Based Management - SQL Server 2008 

Monitoring and Preventing policy violation activities on Database objects, Databases, Instances on SQL Server 2008 using Policy Based Management (PBM)

How to Update Remote SQL Server Databases with a Single Click "SQL Remote All Updater" 

This article describes how to update Remote SQL Server Databases with a Single Click.

SQL Server 2008 T-SQL Enhancements 

SQL Server 2008 introduces some T-SQL enhancements which is used to improve the database performance and maintenance.

How to Execute SSIS Packages in C# ASP.NET - Part I 

In this s Article I am going to explain the technology that came with Sql 2005. This is SSIS which stands for Sql Server Integrated Services. Recently I was working on a project for a client with large sum of Data and there was a need to process the data on a certain time frame. There were lot of technologies available at my Disposal, but this kind of Functionality needed to be streamlined and optimised. Of all the Technologies, i have chosen SSIS. In this Article I will demonstrate on how to executing the SSIS Packages in an ASP.NET(C#).

SQL Query Optimization FAQ Part 1 (With video explanation) 

In this article we will first try to understand what is a SQL plan, how is it created and then we will move towards understanding how to read the SQL plan. As we read the SQL plan we will try to understand different operators like table scan, index seek scan, clustered scan, RID lookup etc. We will also look in to the best practices associated with clustered and non-clustered indexes and how they function internally. We will practically see how indexed views increase performance and in what scenarios we should use the same.

IDENTITY columns in SQL Server 

The IDENTITY columns are auto incrementing columns provided by SQL Server. There can only be one IDENTITY column per table. SQL Server will take care of incrementing this column automatically.

SET VS. SELECT in SQL Server 

SET and SELECT both key words are used to Assign Variables in SQL Server. SET and SELECT both specifies the columns to be changed and the new values for the columns. The values in the specified columns are updated with the values specified in the SET and SELECT in all rows that match the WHERE clause search condition. If no WHERE clause is specified, all rows are updated.

Join Multiple Tables In SQL 

This article describes about how you can join different tables in SQL. It describes different join operations.