The Rambling DBA: Jonathan Kehayias

Good article to read...

If the disk are not providing adequate performance, it does not matter how you slice up the database files. They are still working on the same disk.

We have been...

Paul White NZ (4/4/2010)

---

MeltonDBA (4/4/2010)

---

I have not had a chance to use it but would be interested to hear if it works for you or not. The app was...

You can...

Note to self...read before posting :hehe:

No...SQL Server will only capture counters and information for what resources it is using. It does not take much note of what is outside the boundary.

beejug1983 (4/3/2010)

---

Hi

I want to know if .mdf file gets deleted wrongly, can we recreate .mdf file, whereas .ldf file is available on the disk.

If it is possible suggest me...

Could you use TableDiff (comes with SQL Server 2005)? Pull information about the configured jobs of each server to a temp table (or compare the sys tables straight, but...

I don't type that fast so Perry beat me to it...

But to re-iterate:

You should...

I supported Navision 4.x years back and it contained a Change Log table that if enabled would log just about everything a user did in Navision. If that account...

Not sure where you read but you are correct Target is how much memory SQL would like and Total is how much it has. I'm not sure you would...

That would be an interesting thing to implement. ...

Unlike SQL Server 2000; 2005 and 2008 don't write license to the registry anymore. You may find instances were it might have, but Microsoft goes by "paper proof". ...

Can you post a few messages before and after this one within your log?

Try this post out:

http://www.sqlservercentral.com/Forums/Topic227694-5-1.aspx

It does not mention use of Windows logins. I use SQL Logins for my 2000 instances while connecting using SSMS 2005 and it seems to function...