Search Results | SQL Server Performance Forums

Tuning question

Thread by: akus, Jun 17, 2008, 2 replies, in forum: SQL Server 2005 Integration Services

I am building customer detail de-duping process in SSIS. While flowing say 2000 rows against 20 or so lookups (lookup set averaging 200000 rows) the...

String N'Format' Sting...

Thread by: akus, Feb 11, 2007, 3 replies, in forum: SQL Server 2005 Reporting Services

When I use report parameters, they get formatted with N forcing datatype transalation. e.g. select a from table where b = 'string' gets formatted...

Clickthrough

Thread by: akus, Feb 6, 2007, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi, I've got reporting requirement with need for clickthrough. I see from version features, that "infinite clickthourgh" is only availabe with the...

instead of trigger

Thread by: akus, Jan 18, 2006, 2 replies, in forum: General Developer Questions

Hi all, I am having big performance problems with scenario where I hope to capture values from inserted. Update query contains where clause id =...

(nolock) speed gain

Thread by: akus, Dec 22, 2005, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi all, Following statement performs very differently with an without (nolock) hint. Can someone explain why the difference is so huge, or if I can...

From 7 to 2000 to 2005

Thread by: akus, Nov 30, 2005, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, Has anyone got any experience on upgrading to 2005 yet? We recently upgraded our systems from 7 to 2000. Now there seems to be scope for...

Temp table slow with MIN()

Thread by: akus, Oct 11, 2005, 12 replies, in forum: T-SQL Performance Tuning for Developers

Hi, We have a SQL 2000 batch process using temp tables. Table #a has 116 rows of 15 (narrow) columns (SeqNum is identity column) "SELECT...

Triggery

Thread by: akus, Jul 3, 2005, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi, Our transaction table has 3 triggers (mainly for audit purpose): -a trigger for INSERT, UPDATE, DELETE -another trigger for INSERT -and another...

Replication during upgrade.

Thread by: akus, Jun 16, 2005, 1 replies, in forum: Performance Tuning for SQL Server Replication

We are upgrading a system with 2 different replication topologies (one inward and one outward). Topology 1 (outwards to satellites) SQL7 -...

Index Tuning Wizars acting funny.

Thread by: akus, Jun 1, 2005, 3 replies, in forum: Performance Tuning for DBAs

I've taken a trace taken from sql server 7 and try to analyse it against 2000 database which is a copy of the version 7 production one. Trace has...

LUNS

Thread by: akus, May 26, 2005, 1 replies, in forum: Performance Tuning for Hardware Configurations

Hi All, I already posted similar message to one of the other groups before finding this one (apologies if I am repeating myself). -We are replacing...