If there's only 1 VM setup on the server, no competing software whatsoever, is there any noticable performance degradation (anything above let's say 5-10%)?

This is an idea I have. It seems fair and truly random. Let me know what you think.

insert into #temp

Select top 100 id, value from baseTable order by...

Just add the code in the after_insert event and synchronise the logins within the application.

Other option is to add a job that works the logins. Then run that job...

What type of trigger are you using?

Also why are you trying to do this?

DB means db engine

CI means case insensitive

BI means business intelligence

X64 is for 64 bits

I have no idea what LT means (maybe has something to do with ETL (SSIS) but that's...

Here's the download page for all the versions fo AdventureWorks

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Seems to me like you need to go with analysis services here and show them how to use it to run reports (on there own sandbox server). That way...

jeffrey yao (10/25/2008)

---

I see what proposed in the article is an overkill most of time in SQL2K5 EE. For DB side rollback, is there anything better/quicker than the database snapshot?...

Have you tried the same trick using a view?

Geek101, You better post that question on a new thread, you're far more likely to get help that way.

Stupid question here... but what happens if you reverse the order of the servers just after creating the migration scripts?

Doesn't that help you create the rollback scripts.

I'm sure it won't...

I don't know if it's possible, but to repair the framgentation problems, you need to defrag the drive with the DB detached (otherwise defrag won't touch those files). If...

Check the autoshrink, autogrow settings on sql 2k5.

If the files need to grow during the process, that'll hurt a lot (as much as 40-50% slower). Autoshrink could add fragmentation...

How do you "notify" the other application?

I'm only guessing here... but I'd assume that the server is waiting for the application to close, and maybe also a success / failure message to report back to you.

What...