However you wouldn't build indexes for every query. I would think you would start with the columns in PKs and FKs first, if you haven't explicitly declared those or set...

Richard (7/29/2009)

---

I could not find a chair that really expressed me so I built one.

See it here

It is from a 2007 Corvette. The recline still works and it is...

That's more along the lines of what I'd expect.

The memory usage in SQL Server can be a little strange. I know there are certain things that might need contiguous references,...

Hadn't considered the ports to move between machines, but that's a good idea. I'd go above 50000 and just pick a port for each app. Makes sense.

I'm not sure the sony reader allows annotations. The iPhone apps don't, though you can bookmark a page.

The PC reader (BN) does allow notes.

This also impacts performance. Lower fillfactor, more reads to get the data.

You have to find a good balance for heavily accessed tables that accounts for reads and writes.

Minimal risk that I see with the browser. If someone is going to scan, they'll find the ports. I've set specific ports so that I could be sure that port...

Joe, you can highlight and annotate on the Kindle. Not quite the same thing, but just so you know.

I think it's a great device and platform, but there are issues...

Typically that error is an interruption in the communciation between your server and the client. The number of processes shouldn't be an issue, though each one takes resources. It's possible...

It's actually SARG able, meaning search arguments can be used by the optimizer to better handle your query.

Not to create issues, but I have had friends work for the Catholic or Jewish hospital companies, or for organizations like CBN. They pray before meetings, nothing illegal about it.

GSquared...

I don't believe there is a workaround. The CREATE TRIGGER documentation says not text/ntext types.

What are you trying to accomplish?

SQL server only runs on Windows. You cannot install it on any other OS. It can be Windows Mobile/CE to Data Center server and everything in between, but it will...

You'll need to use a CASE with LEN to determine what the places mean. Then the SUBSTRING to split out the items.

The issue is that if you have

1101

is that 1:10:01...

Move to varchar(max) as a data type.