I think I have you beat, Steve.

My wife lost her purse at a club one night years ago. Actually it was in the pocket of her sister's coat, and her...

One thing I love temp tables for is when I need to do some extensive processing on a large collection of rows. I want transactional consistency on the original data...

A somewhat tangential issue is to qualify all of your columns with a table prefix whenever there is more than one table involved. For one I think you save a...

I use a function and a view in tandem to handle lists of columns. This is useful because I don't have to remember the actual table name, I can just...

Carsten Petersen (3/16/2008)

---

What I've come up with until now. Any comments on it (performance etc.)?

CTE Returns Primary Key, Row Number and Total Record Count to @PagerTable, and is joined with...

Adrian Hains (3/16/2008)

---

I...

I have looked...

Not related to the original topic, but here is a tip on implementing indexed views. I typically create / optimize the objects in our database but the other devs are...

Maybe this was a glaring omission in my sql experience, but I had never considered updating a variable for each row in an update like that. The function itself is...

Along these same lines - anyone who is interested in optimizing their indexes based on live usage patterns should check out this blog entry from sqlcat on related dmv's:

http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx

And you...

I assume the passwords you put in the script are not your production passwords?

Fire up replication monitor on server a. When you make a change on server a, do you...

JRodman, here is the demonstration code I mentioned:

create table test_table (number int primary key clustered, payload varchar(100));

go

WITH

-- first CTE which returns 10 rows (0-9)

digits AS (

SELECT 0 as Number

UNION...

JRodman,

I think the testing you have performed must have been in a different case than the one I was talking about. I'm only saying that the ideal approach is to...

JRodman,

I disagree with your statement of absolutes - that you should never return all columns from the CTE. See my post on page 2 of this thread - you should...

Ian,

I can tell you that sql does certainly not do a good job of pushing down constraints into the CTE based on joins outside of it.

I foolishly implemented some stuff...