Ads

Captured Technology - Blog

All Posts Term: sql server
2 post(s) found

Microsft Webmatrix: The New Innovation

Microsoft WebMatrix.jpg

Microsft Webmatrix: The New Innovation


An innovative free of charge solution created by Microsoft is intended to streamline the operations necessary to construct, modify as well as position internet sites above Windows. WebMatrix is this solution and it works by giving out a package comprised of an internet server, a database, in addition to programming frameworks. The built-in experience is obtainable as an integral part of the Microsoft Web Platform, and is intended to deliver web designers leveraging the Windows platform by means of a small download size (15MB download, if .NET 4 isn't installed then 50mbs), straightforward and simple internet stack.
.Net Development.Net Development

Adding Indexes to SQL Server 2005 Tables

Adding Indexes to SQL Server 2005 Tables

I had the opportunity this week to tune a SQL Server 2005 database to improve the performance of a web application. I first created indexes on the temporary tables within a stored procedure that was causing much of the delay and later discovered through the execution plan, there was specific bottle-neck that could be cleared. Here is an illustration of the temp table indexing:

IF OBJECT_ID('#TempTable') IS NOT NULL
CREATE NONCLUSTERED INDEX [#idxTemp_TempTable_Field1_Field2] ON #TempTable
(
[Field1] ASC,
[Field2] ASC,
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = ON, 
IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = OFF, 
ALLOW_PAGE_LOCKS  = OFF) ON [PRIMARY]

But by executing the same stored procedure in a query window and selecting ‘Include Actual Execution Plan’ from the toolbar, I was able to see it individual query’s cost within the stored procedure. Then it is possible to look at the most expense queries, their most expensive operations, and add indexes to the permanent tables that reduce execution time.

Marketing Materials - Save up to 80%

Blog Directory

Latest technology news.
 Patrick Stevens
 493  245961  5/12/2022

Translate

Categories

Blog Calendar