On the second point:

There are a couple of reasons for getting more than one row (allow me to gloss over most of them for a moment).

Usually though it is because...

That really does seem like it would be best done in a procedure, with the calculated difference value returned in an OUTPUT parameter. Is there any particular reason you...

If you are using Enterprise Edition, you could consider partitioning the LOB table.

Placing archive data on read-only file groups within the partitioning scheme would mean you could use the READ_WRITE_FILEGROUPS...

On the face of it, this sounds more like a procedure with an output parameter than a function.

Functions tend to suck badly as soon as they involve data access.

If you...

Hey C# Screw!

So not your last post after all then 😉

Other side of the Pacific, if you don't mind!

For an example of how to capture CPU time (worker time) forgive...

timothyawiseman (5/9/2008)

---

My primary motivation in writing this article was for my own team, who I found out in conversation was not aware of all of these. I went looking...

Charles Kincaid (5/9/2008)

---

I just keep running the delete thing multiple times. I then TRUNCATE the log :hehe: Of course if I want a realy clean small empty I...

srienstr (5/9/2008)

---

One comment:

There's generally no need to do a delete without criteria, as truncate will perform better with less logging:

exec dbo.sp_msforeachtable 'truncate table test.dbo.[?]'

That said, I'm sure it depends and...

Anatol Romanov-404520 (5/9/2008)

---

All extended stored procedures mentioned in the article are well known to most of the people working with SQL Server for some years. They have been discussed many...

rnjohnson10 (5/8/2008)

---

Are you kidding me? If something is hanging up the server, the GUI will take minutes or longer to show you what's happening. Using sp_who2 is generally...

Jeff Moden (11/19/2009)

---

Heh... last but not least... if you want to see all of the T-SQL code example really start dragging their feet, just change the datatype of the column...

Same here 🙂

Isolation Levels In The Database Engine - Books Online

Connect item created for the unexpectedly slow performance with Windows collations.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=512459

Please vote for it!

Thanks

Paul

Paul White (11/19/2009)

---

...my timing results have always been CPU-only. I will admit to being lazy and using SET STATISTICS TIME instead of total_worker_time / execution_count from sys.dm_exec_query_stats or Profiler...