Querry How we create index?can anyone give example of cluster and noncluster indexes. . . . Hi, When I first started using and new DBA, I took it upon myself to learn everything I could about these index types, and when they should be used. This article is a result of my learning and experience, and explains the differences between clustered and non-clustered index data structures for the DBA or developer new to SQL Server. If you are new understand and appreciate the differences between clustered and non-clustered indexes. Part I: Non-Clustered Index Creating a Table To better explain SQL Server non-clustered indexes; let’s start by EmpId Int, EmpName Varchar(8000) ) When you first create a new table, there is no index created by default. In technical terms, a table without an index is called a “heap”. We can confirm the fact that this new table doesn’t have an index by taking a look at the sysindexes system table, which contains one for this table an of indid = 0. The sysindexes table, which exists in every database, tracks table and index information. “Indid” refers to Index ID, and is used to identify indexes. An indid of

Filter / Copy Paste noncontiguous columns to ws in loop code Love for help me with this one codes into the first For Next loop - Thank you, Rowland: Sub Add_WS_for_Uniques() Dim rngUniques As Range, cell As Range, rngSrc As Range, rngDst As Range, ccSrc As Range, ccDst As Range Dim fmlaSrc As Range, fmlaDst As Range Dim Lastrow As Long, Firstrow As Long Dim ws As Worksheet, HCCosts

difference between VB.NET and C#? (I) what is the difference between System exceptions and Application exceptions? (I)What is CODE Access security? (I)What is a satellite assembly? (A) How the difference between thread and process? Chapter 4: Remoting and Webservices (B)What is an application domain? (B) What is .NET Remoting? (B) Which class does the remote object has to consume it? (A) Do webservice have state? Chapter 5: Caching Concepts (B) What is an application object? (I) what is the difference between Cache object and application object? (I) How can get access to cache object? (A) What are dependencies in cache page in the next page ? (I) Can we post and access view state in another application? (I) What is SQL Cache Dependency in ASP.NET 2.0? (I) How do we is the difference between “Web.config” and “Machine.Config”? (B) What is a SESSION and APPLICATION object? (A) What is the difference between ‘Server.Transfer’ and ‘response. Redirect’ ? (A)What is in .NET? (B)What is three-tier architecture? (I)Have you ever worked with Microsoft Application Blocks, if yes then which? (A)What is Service Oriented architecture? (I)What are different can we perform transactions in .NET? (I) What is difference between Dataset? Clone and Dataset. Copy? (A) Can you explain the difference between an ADO.NET Dataset and an ADO Record

REPT( TRANSPOSE(" http: / / www.newphp?id = "&'Data Submitted'!E2:E) ; TRANSPOSE( 'Data Submitted'!A2:A) = INDEX( QUERY('Data Submitted'!A2:E ; "Select E, max(A) Where E <> '' Group by E Label TRANSPOSE(SPLIT( CONCATENATE( IFERROR(REPT( TRANSPOSE('Data Submitted'!B2: B8) ; TRANSPOSE('Data Submitted'!A2:A) = INDEX( QUERY( 'Data Submitted'!A2:E ; " Select E, max(A) Where E <> '' Group by E Label max(A) '' " ; 0) ;0;2))&CHAR(10))); CHAR( 10))))) 'Results (ahab)'!B6: = INDEX( QUERY('Data Submitted' !A2:E ; "Select E, max(A) Where E <> '' Group by E Label this but I need help modifying it: Sub Add_WS_for_Uniques() Dim Lastrow As Long, rngUniques As Range, cell As Range, ws As Worksheet, HCCosts As Worksheet Set HCCosts = Worksheets("2012HC") Set StaticData = Worksheets("Static Data") Application.ScreenUpdating = False Lastrow = HCCosts.Range("F" & Rows.Count).End(xlUp).Row HCCosts Range("F1:F" & Lastrow).AdvancedFilter Action: = xlFilterInPlace, Unique: = True Set rngUniques = HCCosts.Range("F2:F" & Lastrow

button. Please help. R' Prasad DELETING DUPLICATE ROWS LIKE THIS Sub x() Dim rng As Range, rData As Range Application.ScreenUpdating = False Set rData = Range( "A1" , Range( "A1" ). End (xlDown)) rData.AdvancedFilter xlFilterCopy, copytorange: = Range( "C1" ), unique: = True For Each rng In Range( "C2" , Range( "C2" ). End (xlDown)) rng.Offset(, 1) = WorksheetFunction.SumIf(rData, rng, rData.Offset(, 1)) Next rng