john.arnott (4/15/2008)

---

[snip] the table's maintenance would be cumbersome. [snip] How much computing time do month() or day() take? Is an index effective if, assuming random distribution of birthdays,...

I agree about the 'trick' of data being unbelievably bad practice.

Whether you use IN or join to a derived table of numbers, they're essentially the same solution, no? (I...

We use JScript in the ASP environment, which to my knowledge does not support passing variables into the ADO object (like VBscript would allow) - so we must return a...

What about using the linked server to reach a custom table function? Does that keep the performance optimizations on the local server?

Select * from

server.database.owner.fnRemoteTableView( filterCriteria )

Suppose there are 10...

I usually change SQL2000 default clustered index on the primary key to the foreign key of the parent table. We are usually selecting children from a parent-child relationship. ...

Being wired is not the problem, being obligated to work all the time is the problem. If your employer is ok with you using personal IM/chat at work, then...

Have you considered building the update string inside the loop, but executing it after you have iterated all the columns? O(1) < O(n)

Also, do you have any comments/caveats on...

Or you can keep the performance offered by the native SQL server option by putting the names/IP address information in the server's HOST file. We have one colocated SQL...

I don't see this technique as an improvement where people are already using the CSV string technique. By the time you have serialized an arbitrarily large number...

OK sorry, I was not intending to be truculent.

It seemed to me that you were writing as an authority, who would have had an editor review your submission for completeness....

Where was the example using bcp or DTS?

If you're going to use a hammer to drive a screw, be thorough enough to examine the rest of the non-screwdriver solutions.

Great article. So was the inline article "Should He Be Fired?" in this morning's email. I especially liked the approach that building trust in your team's ability to...