SQLBOT (8/25/2009)

---

gah (8/25/2009)

---

my simple thoughts:

...

single click "subscribe to topic"...without moving off page and this flag then used to

filter "recent posts" options to only display what I have...

Row_Number() is how I'd do that. It actually does create a loop, but it's a LOT more efficient than a cursor, triangular join, or explicit loop (While loop).

I'm pretty sure it was checksum, not binary. Since I didn't care about the difference in case, which is the primary difference between the two.

select checksum('A'),checksum('a'), binary_checksum('A'), binary_checksum('a');

Results:

142 142...

If the database is in Full recovery mode, then yes. ApexSQL and Lumigent both publish log parsers that can read SQL 2005 transaction logs.

Or...

What login are you creating the user accounts based on? If the server-level login has certain rights, database-level user accounts will have those rights.

You can use a checksum to narrow down the search. It can make a good leading-edge for what would otherwise be a multi-column index.

Checksum isn't exact, but it can...

What rights does the guest login have in those databases?

For XML won't do line-feeds because XML files don't need them. That's what tags are for.

Why do you need line-feeds in XML?

One take on it, reasonably well-written, is here[/url]. Not sure I agree, but at least it's something.

Personally, I'd say the difference is based on the ratio of you asking...

Mel Harbour (8/25/2009)

---

GSquared (8/25/2009)

---

The main site improvement I'm still looking for is a FAQ in the options on the left of the page, between Home and Articles.

Other than that, I'm...

The main site improvement I'm still looking for is a FAQ in the options on the left of the page, between Home and Articles.

Other than that, I'm fine with how...

I include my online presence as part of my resume. Don't even force them to Google me. (Googling my name doesn't actually find much that's useful, or even...

In that case, it's just the logical names for the files, not the physical names, so it doesn't matter.

I don't think anyone yet has accused the...