Daniel,

have you tried creating a new cleanup job with the new version of SSMS? They are quite easy to recreate using the GUI tools, and its probably faster to...

Hi Eric,

why would you need to install BIDS on the servers themselves? You can deploy your solution without any management/development GUI installed on the target machine, or have I...

SQLRumble,

I just wanted to voice my support for SQL Sentry. We have been testing/using it for the past few months and will be installing it here. I found...

Hi YN,

I remember Ross Mistry talking about this at the European Pass Summit in April. He is avery knowledgable on HA and likes Database Mirroring, but warns against automatic...

Hi Faiyaaz,

you would need to make sure that any logins that exist on the 2000 installation are moved to the 2008 installation.

This can be done very easily with the following...

Hi Faiyaaz,

The difference between an inplace upgrade and a side-by-side installation is that the upgrade means you don't uninstall the 2000 instance, but effectively overwrite the 2000 installation.

When going from...

Hi Faiyaaz,

If I understand correctly, you want to keep the SQL 2000 installation and install SQL 2008 alongside it and not upgrade the installation, right?

Whats my best option, Can I...

Yep thats me 🙂

Hi Andre,

I don't know if it helps at all, but in the log you can see that the Database Service itself (Datenbankmoduldienste) were not changed at all by the upgrade...

Thanks Matt and Dave.

I thought it was something like parameter sniffing for SET @variablename=value, but couldn't remember the name!

In this case a wrapper call to a procedure would be better,...

Hi,

I think that the degradation issue is one that mainly affects mainstream SSDs and not the enterprise versions.

From what I've read, file fragmentation will not slow down an SSD at...

Hi there,

I recently spoke to a guy from SQLCAT here in europe whilst at the European PASS conference (Thomas Kejser). He was one of the people responsible for the...

Hi RichardB,

I was only making it clear to anyone reading the rest of the thread that SQLBackup or Quest are not the bad guys when it comes to a slow...

Hi RichardB,

that is not Quest's fault, it will most likely be down to slow proc. or I/O problems (you did say they are dev boxes).

I don't think there is much...

RBarryYoung (4/15/2009)

GermanDBA (4/15/2009)I know that if the series has the same quality that RBarryYoung produces here on a daily basis, it will be a wonderful primer for quite a few...