Just my 2 cents.

If you set pagefile too small or worse disable it, the system will be slow regardless of ram size. On my comp with 2 GB ram the...

If you need just visit count, add a count column to the parent table, if you want more data on each visit (timestamp) , need to analyze visits (ie distribution),...

Take a look at the query execution plan.

Though not always helpful, it will give you at an idea where to look for the problem.

Recently I had similar problem with...

Unfair?

Matter of planning. Hardware is cheap. In US it's even cheaper than in Europe.

Savings are significant: I can simultaneously debug a fat client, ISAPI dll, sql triggers and all interactions....

I don't think that that cursor is the bottleneck. I ran a similar sp but replaced exec with print and it executed in practically no time for a hundred of...

Not that much. I bought it few months ago. Core2 duo 6600, 2gb ram, WD sata2 300gb. Fast disk (throughput 35mb/s write and 49 read), fast ram and a quality...

The niftiest trick is this:

CREATE INDEX IXC_TestData_Cover1 ON dbo.TestData(SomeID,SomeCode)

My timing is:

================================================================================

"Ugly trick" code...

SQL Server Execution Times:

CPU time = 1125 ms, elapsed time = 1091 ms.

================================================================================

XML code...

SQL...

This looks like a replication task - copies missing data from one database to another.

So if there's a lot of data in any database, it takes time to do a...

Since the sp runs a dynamic query and field names are not known in advance, it's impossible to do a join, unless the sp always returns at least the link...

Ugly trick? why?

Custom aggregates are extremely useful feature. While lists can be done with "FOR XML PATH", some thing can't, like when you have to do a binary OR (not...

oops, of course. I reread the original post again. I should be more careful.

insert into T2 select * from T1 where ;

delete from T1 where ;

You can put it into T1 trigger too, so you don't have to manually call the...

It's called custom aggregate (I think). It executes the expression for each row in the resultset. You can do it with FOR XML PATH() too.

Take a look at this thread:

http://www.sqlservercentral.com/Forums/Topic462961-145-1.aspx

A well known concept in software industry is configurability, meaning your app reads an external config file (INI, XML,...) or registry. Or asks the user and saves his input as...

Every table intended for update must have a unique key. In update statement you put unique key in where clause. If you don't care about concurrency, it's enough (upWherekeyonly update...