Marios,

That's an interesting scenario. I haven't dealt with it, but my thoughts are that you enable AWE on all instances. With 2-3GB for each instance, I think you would not...

That should be the right file. I think a reboot is necessary since there could be a pending change. Shouldn't hurt.

Order shouldn't matter, never seen it do so in the past, but I've added things to the end so I know what to remove.

Be sure you document your changes.

I own a training center, but I'm not sure classroom is for everyone. Some people like the live environment, getting a ton of information packed into one week. Others think...

I'd be interested as well. What people typically do is quiesce the system, make sure nothing else is happening, and then run your process.

Keep in mind that the server is...

Typically you have CALs that allow a client to access any number of devices. I don't believe this has changed, but licensing is fluid, so I'd check directly with Microsoft...

I don't think there are queries for this. I'd assume it's in the registery, so perhaps you can xp_regread the data out of there. Might need multiple queries.

Interesting thoughts, and I'm looking forward to seeing what you think about tomorrow's comparison.

Jeff, inspections are often third party, city or county employers, isn't that better than having the developer...

How do you expect this data to get into folders? What type of result set?

The data from SQL Server can be easily exported using DTS or bcp and you can...

You are using NOINIT, which means you append each day's backup to the file.

Use INIT to create a new file each day.

Service Broker might help here. I suppose you could delay messages until some time.

The other thing is perhaps insert the data into a Q table of some sort with a...

The View is treated just like a table. In essence, I believe that your query is merged into the view for the execution plan. It doesn't materialize the view and...

It helps as a bonus with experience. You have to sell it to your company, or if the company is large enough, they might automatically recognize it.

Congrats!!!!!

FYI, the 2008 exams are in development now. My guess is they'll release in early 2009.

AFAIK, only Management Studio can view query plans. As Gail mentioned, they can be saved, but the data is only in the XML file (sqlplan) or shown in SSMS.

You can...