I am assuming you have a local instance of SQL Server 2008 running on your workstation.

Open the SQL Server Configuration Manager. Click on the SQL Server 2008 Services. ...

Actually, IIRC, Indexed Views are available in Standard Edition, just that the QO in Enterprise Edition will automatically use an Indexed View if it is appropriate for the query.

Please post the DDL (CREATE TABLE statement) for the table, sample data (as a series of INSERT INTO statements), and the code you have written in attempting to solve your...

If your tempdb has grown to this size, it did so for a reason. I would not even attempt to shrink it as it will just have to grow...

Not sure why it doesn't work. Copy and paste it to the address bar, that worked for me.

Or, you could look it up in Books Online by entering System...

By having it run as a continuously running Task at the OS level, I know that if I run an ad hoc or on demand backup, the file will be...

After reformatting the code to make it more readable for me (I love indention and white space) I do see one difference between the two queries, but not sure if...

Please provide the DDL for the tables including indexes and attach the actual execution plans for both queries. You can save them as .sqlplan files, zip them and attach...

Pleasse keep replies in this thread related to the connection string problem only. Replies to the second problem should be directed here.

Please keep threads to one problem.

In the appropriate database, run this query, it may help you in narrowing down when this happens. You may need to setup a server side trace to track changes...

Start here, everything you need is in several of the tables listed:

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/aa615add-54e6-40f5-8b55-3728b26884ee.htm

I setup robocopy using Task Scheduler on our Windows Server 2008 systems. Set it up to start when the system started and to move files to a separate server....

They haven't called me back since that one day. Which is fine, I don't miss working there, just a few of the people. I managed to steal one...

CirquedeSQLeil (3/8/2010)

---

Lynn Pettis (3/8/2010)

---

I got a call from an employer from which I was fired. They paid me $100 per hour, including travel time (3 hours), to come up...

It's...