Loner (3/4/2008)

---

I totally agree to that. Besides the technology changes...

If you want to check out the thread I was referring to - it's over here:

http://www.sqlservercentral.com/Forums/Topic454846-371-2.aspx#bm455633

Jack Corbett (3/4/2008)

---

Thanks for the explanation Matt. This is basically how I thought it would work, but trying to understand it sets my head spinning because it is so...

GregoryAJackson (3/4/2008)

---

function use in the SELECT List and or on the JOIN can also cause severe problems (maybe even worse then in the WHERE Clause).

by placing a Function in the...

psst - Jack? (secret time)

Jeff's solution is referred by MS tech-heads (some of their bloggers) as an "inner loop" technique. Meaning - you have to touch each record...

Jack Corbett (3/3/2008)

---

Jeff, Thanks for keeping me up too late again. As it seems I say often, I thought I was an expert then I came to SSC...

Shrinking log files is sometimes required when they go over the size you want. I wouldn't do it a lot, but it sometimes happens. I would try to...

"Resistance is futile....Your experience will be assimilated into the SQl Server Central collective....":D

I would go web application. Mostly because there is a single deployment, and no workstation by workstation config issues to worry about.

If you have access to VS2005 standard or...

jim (3/3/2008)

---

I have migrated an Access app to SQL 2005 over the weekend. I'm pretty new to SQL, have programmed in Access for years, but am still learning something new...

sqlbrowser = the "SQL BROWSER service" (in control panel/admin tasks/services).

It "advertises" SQL instances, so it makes it easier for apps to "know" how to talk to a specific SQL instance.

The sad part is - it can be used as a very decent way to create a BusinessObjects - like "universe" for your devs to interact with. That's...

I'm not a big fan right now. Mostly because it seems to reintroduce a lot of the weaknesses seen in previous attempts at the same thing. It's a...

What do you mean by "invalid"?

What specifically clues you in to it being "invalid"?

Are you getting an error? If so - where?

I've been a big fan of those USB hard drives that have popped up with the included backup software. On a high-speed USB connection - it's about as fast...