also - have you tried testing the "default beep" sound from within the control panel?

Control panel -->Sounds and audio devices-->Sounds Tab-->Program Events-->(hit the play button)

You can reset that to "none"...

Well - the solar panels are designed to CAPTURE (absorb) the energy, not bounce it elsewhere. But - yes- once you get past the costs of the parts, it's...

The thing I'm finding interesting which seems to be throwing off the numbers is that the sp_xml_preparedocument and sp_xml_removedocument aren't part of the execution plan/effort. The second syntax has...

...for 3.99 a minute of course.....

Well - i'm not sure I follow. XQUERY is a facility used to perform queries off XML data (whether it's stored in SQL Server, a free-standing file, XML stream,...

don't forget someone to do the running commentary as to technique, effectiveness, etc...:D

Wayne -

SQL Server has been advocating that the ORDER BY exist in the outer-most SELECT. So it will ignore any ORDER BY defined in the view. From...

Of course - one part might be that if you're only backing up 1/7th of your database each day (which seems to be what the filegroup backup is proposing), I'm...

THAT doesn't make much sense. you should find that both of them should be the same execution plan.

Did you run DBCC Freeproccache between the two executions? I have...

You should also look at the various properties of the DB's as well. My Dev edition platform seems to "like" setting the Auto-Close feature to ON on any databases...

I'm not sure what you're running this in, but the fact that you're running 3 cross joins (meaning joins with NO join criteria) is going to very quickly return VERY...

They're two entirely different animals.

Pass-through queries are roughly the equivalent of running ad-hoc SQL statements from Query analyzer: your machine sends the server a question, and the...

I don't claim to know what they plan on doing in '08. I do think you've found the current backdoor for what you're wanting to do however (with OLEDB).

I...

I'm not entirely sure I understand your question, but you might care to look up the

SELECT.... FOR XML

syntax. It will output the contents of a select statement as...

Of course - with 50 users, Server + USER CAL licensing price will be just about the same as 2 per Processor licenses.