Generically - SQLExpress is limited only to a single processor and 1GB RAM. It's not techinically limited on DB size or # of connections. So - assuming your...

I'm pretty sure that backups can only happen to drives that are directly connected and/or can be mapped to. FTP is not an option.

You would want to back up...

Well then - you can stop looking - because there's your reason. In general - you should be avoiding running searches on things that aren't/can't be indexed. Running...

paulhunter (3/4/2008)

---

Jeff Moden

---

SQL is supposed to be an "english like language"... in English, we don't start new lines with a comma. I guess I can understand why some people might...

Haritha Kodali (3/4/2008)

---

I have this query that gets called from the code that runs too slow. It initially took 2mins 53 secs. After adding clustered index on State...

I think the confusion is that SAN's (by your definition) are always remote. Your wording threw me a little bit as well: I was curious if you were getting...

If my italian isn't entirely shot - it's stating that the path isn't correct. Meaning - it doesn't understand what "Z:" is under the credentials executing the query.

Try changing...

I think it would make Sergyi proud....:):hehe:

Gotta say - that's a catchy "else" clause.....:D

Might have to reuse that somewhere.

The order of the columns is important in the covering index.

Looks to me that the indexes that would help would be:

For the main table -

PreviousDayID, PatientID, TodayID,[Open%] ,[High%], [Low%],...

The big question is - why do you want to do it in a User-defined Function to begin with? What are you using it for? What is the...

The short answer is - the "new" PIVOT syntax only allows for one type of aggeregation, so you can't incorporate that into the PIVOT statement.

Now - given that short answer...

I wonder how that test applies to the "Ballmer Peak" theory of programming?

http://www.xkcd.com/323/%5B/url%5D

CAGreensfelder (3/4/2008)

---

Thank you! I'm a wiz at MSWord but never thought to use it.

(Used to teach "Introduction to Microcomputer Applications" at the local college - when I...

Keep in mind that this will always retrieve just one value per row (so - you're out of luck with this syntax if the row has multiple instances of that...