With the DMZ comment I assumed there was something I was...

There are some very good reasons to use a cluster....

Dev (12/2/2011)

---

If the DB is really critical and has to be up 24/7 I would be surprised if you say you don’t have any High Availability options enabled...

Unless reindex hasn't been doing it's job I'm not worried about internal fragmentation. I'll update this post with how it goes (or if we decide to do a straight...

There isn't much on the drive outside of DB files so we should be good with that but it is something to look out for since the files we're putting...

If the SQL Server is on the domain then it's easier to use Windows authentication to connect to the server. Windows authentication is more secure than SQL authentication if...

OzYbOi d(-_-)b (11/23/2011)

---

Certainly a little curious as to why only the Decimal behaves in this manor... But this is something that I have run across before in a shop where...

BOL states that this happens for numeric and decimal so I'm betting it has something to do with the fact that those are the two data types that can take...

We send transaction log backups directly to a network location to get them off the server. With the exception of one server that works well. For full and...

To clarify what the following statement from BOL means:

That means if you try ordering...

Thanks. I was wondering what the bug was and couldn't track it down. Implicit conversion makes sense.

You're not the first to have this happen. Both due to ambiguity and...

Ninja's_RGR'us (11/8/2011)

---

cfradenburg (11/8/2011)

---

For those with a SQL 2005 box you can test on, does the following result in the same error:

use master

select fileid [file_id], name from sysfiles intersect

select file_id,...

For those with a SQL 2005 box you can test on, does the following result in the same error:

use master

select fileid [file_id], name from sysfiles intersect

select file_id, name ...

That's row number 2, not two rows.