|
|
-
|
|
This is a setting that DBA are advised to place at the start of the stored procedure. What this setting does? Let us run an sample code for this.
USE AdventureWorks
GO
SELECT * FROM Person.Address
SET NOCOUNT ON
SELECT * FROM Person.Address
SET NOCOUNT OFF
You will that first ......
|
|
-
|
|
Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index.
In filtered index, you can define index to the filter portion of your data. For example, you can create a non-clustered as following.
CREATE NONCLUSTERE......
|
|
-
|
|
How many objects/features you have in SQL Server? It will range from simple Table, View to CDC, Encryption.
Let us says that you were asked to create a server trigger. Do note that DDL triggers do not have a user interface support in SQL Server Management Studio. (In case you do not know about DDL......
|
|
-
|
|
We are in the process of discussing usage of indexes in SQL Server. Today it is time to discuss another type of index.
As we did in the previous occasions, let us compare following two queries.
SELECT ProductID, SalesOrderID, SalesOrderDetailID
FROM Sales.SalesOrderDetail
WHERE ProductID = 77......
|
|
-
|
|
We discussed little about indexes last time and as promissed this is the next step into it.
For this article, we are using Sales.SalesOrderDetail table in the AdventureWorks Database.
<span style="color: #800000; font-size: x-s......
|
|
-
|
|
Indexes are very important when it comes to design your databases for better performance.
In this article we will look into what are indexes types we have in SQL Server 2008.
In SQL Server you have two types of indexes.
Clustered Index (CLI)
Clustered index is the actual table/view sorted ......
|
|
-
|
|
This is the first article from me to this site and first DBA article for the site. So I thought of playing little defensive (In cricket, if it is a new ground, coaches advice you to play defensively at starting. So I take a leaf out of the cricket coaching manual).
This topic might be a simple thus......
|
|