Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked



Upload Image Close it
Select File

Browse by Tags · View All
BRH 6
Index 6
Non-Clustered Index 5
Performance 4
#SQLServer 3
#TSQL 2
SQLServer 2
Clustered Index 2
Filtered Index 2
SSMS 2

Archive · View All
April 2010 7
March 2010 4
August 2010 2
May 2010 2
October 2011 1
September 2010 1

  • 1
    Liked

    SET NOCOUNT ON

    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 ......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Apr 9 2010 1:17PM
    Profile
  • 1
    Liked

    Filtered Index

    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......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Apr 6 2010 6:01AM
    Profile
  • 1
    Liked

    Are You Using Template Explorer

    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......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Apr 1 2010 3:22AM
    Profile
  • 0
    Liked
    1
    Comments

    Covering Indexes

    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......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Mar 31 2010 5:53AM
    Profile
  • 0
    Liked

    Usage of Indexes - 2

    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......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Mar 29 2010 2:40AM
    Profile
  • 0
    Liked

    Indexing Basics Part 1

    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 ......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Mar 18 2010 10:41AM
    Profile
  • 1
    Liked
    1
    Comments

    SSMS Customize Shortcuts

    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......
    Blogs »  Dinesh Asanka
    Dinesh Asanka  Posted on Mar 3 2010 4:54AM
    Profile
Previous 1 | 2 Next
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]