Grant Fritchey (6/30/2008)

---

Hey guys,

You think you have problems now? Wait until nHibernate and all it's ilk are in your development systems. Now you'll have object specific databases with dynamic SQL....

Hi John,

I copied the files.

Assume instance A has no model database. I stop services on instance A & B. Copy the model data & log file from the...

I can't say I have worked for a company with colleagues like that.

I suppose when I left one company I had more information about processes than I could pass over....

Instead, focus your efforts on refactoring and teaching small lessons. Show them how a change might help them or speed things up. How to think about indexing. You might be...

I used this one.

http://www.compman.co.uk/scripts/browse.asp?ref=742103

I'm used to code in VB background but this book got me up and running in C# in pretty quick time.

In an ideal world, you would have seperate physical drives, sure.

Is your database used 24/7? If not then backing up to the same physical drive won't cause any pain...

Never seen this! You can't actually delete the model database from the management studio or execute drop database against it.

How is the service even running as well?

Anyways, I just...

Just a quick thought. Are you setting a fill factor on your indexes or leaving them at 100%?

I just spotted this post. I've not had time to read all the replies so I may well be repeating what someone has already posted.

You're original post asking about...

What does DBCC SQLPERF(LOGSPACE) tell you?

If you don't want to take regular log backups, you can always manually backup the log file and then shrink the transaction log. However,...

I work from home when I need to. If I really need to focus on something I'll work from home.

I can't say I am bored working at home though....

I've worked in a couple different environments in England.

Firstly, one where on I knew a bit of everything...So even though I was the DBA, I could get a call about...

Well, since being swayed to buy an Xbox360 last year, I got into Call of Duty 4 in a big way. Getting closer to level 55, so I may...

Sorry, didn't quite explain myself there. I'm not trying to make the resultsets the same.

The two pieces of code are the same, with the exception that one inserts to...

I forgot to add, it's SP4. No additional hot fixes after SP4 have been applied - I am trolling through those now to see if there was a fix.