It should work still work. I had a linked server going from SQL2008 to SQL2000 and SQL 2008R2 to SQL2000 as well.

On every SQL Server I create a nightly maintenance plan up do DB Intergity checks.... then another Maint. plan to update stats weekly.

Here is a script that all DBA's should run periodically even if you think you know who may have 'sa' and or other rights within SQL Server. Once in a...

Here is a thought you could try if you haven't already. Instead of backing up to one file backup to 4 files. I have seen backup times for...

Make sure you rebuild indexes and update stats too. Every time I move a db from older version of SQL Server to a new version I rebuild the indexes.

In general we have virtualized almost all of our Windows servers except for about 10%. We do have 3 prod SQL Server clusters that are not as busy as...

The added features are nice. However, most of these features are ENTERPRISE Edition only. Most of all of the installations in the world are Standard Edition and I would...

William Soranno (4/15/2014)

---

Bill,

Your senario might work if I had only a few databases to mirror and a few "applications" to change connection strings.

I have 66 databases, and growing, on the...

Interesting article and you make some good points. However, we are going to migrating away from our Clusters that we have as we upgrade in the coming years. We...

Eric M Russell (4/14/2014)

---

I wish Microsoft had called this latest release SQL Server 2012 R2. Now those of us not planning to use v2014 in the forseeable future look like...

Tatsu (4/14/2014)

---

Markus (4/14/2014)

---

[quote-0Yes, but aren't those [In-memory] features only available for ENTERPRISE Edition? If so, not many will be able to justify the huge cost for that version of...

Tatsu (4/14/2014)

---

The In-Memory OLTP and In-Memory Columnstore indexes (for...

Eric M Russell (4/14/2014)

---

Going from v2000 to v2005 was obviously a leap forward in terms of how SQL Server database are implemented and coded. To a lesser extent v2008 had...

skeleton567 (4/11/2014)

---

How long needs to tempered by a responsible DBA constantly reminding folks that equipment and software are aging, becoming obsolete, impossible to support or fix if broken. Don't...

We have a massive system that we implemented in 2010 that has a handful of SQL2005 dbs as its back end. The application is running on Win2003 32 bit...