If you prefer online, I'd just search SQL Server Performance Monitor in your search engine of choice, and start digging in.

There are several articles on this site. Check out...

There are whole books on the subject, plus huge portions of websites like MSDN.

Do you prefer books or online research, or some mix of the two?

Profiler will create a performance hit on the server. Saving the data to tables directly is the worst for that.

The best bet on that kind of thing is running...

Mad Myche (2/16/2011)

---

In regards to temp vs variable tables, when I am building procedures that could use either I will develop using both methods and check the performance on both...

oskargunn (2/16/2011)

---

Well the data compression was not turned on beforehand and I did run the estimates and it returned the same amount of compression, only 1 gb.

Most of the data...

Nope. Start it over.

tsje (2/16/2011)

---

What about issues of memory usage on temp tables or table variables.

Is there a difference?

i.e. does a temp table (#mytable) write to the disk in tempdb?

vs. a table variable...

No, Who's on first.

You'll run into performance issues because of I/O way before you run into hard limits on the number of traces.

Some data doesn't compress well.

Numbers, for example, don't compress worth a darn. Text and binary compress the best, usually, but even they have limits.

Fal (2/16/2011)

---

Koen Verbeeck (2/15/2011)

---

Fal (2/15/2011)

---

WayneS (2/15/2011)

---

Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000),...

Take a look at this: http://www.mssqltips.com/tip.asp?tip=1172

Has info on how to test if the account is in use and what to do about it. It's SQL 2000 and 2005, not...

I've used several. Current one (from Galaxy Quest) is because someone noted we had Babylon 5, Star Wars, Star Trek, and all kinds of sci fi avatars on a...

LutzM (2/15/2011)

---

GSquared (2/15/2011)

---

Any place where you need to dynamically run against objects in the database or server, or call a stored procedure over and over vs a dataset, when the...

dlatch (2/15/2011)

---

GSquared and Craig -

It was actually an SSIS package that I had written. Doing a lookup against the key and column splits on the critical tested fields. ...