Yes you can.

Drawbacks?

Not a bug. CLR uses memory outside of the limit set by max server memory. You must have some memory-intensive CLR. Chat with the devs, make sure they're not doing...

M Joomun (10/29/2014)

---

Ed Wagner (10/29/2014)

---

I hope you don't have any critical data being stored on a user's local drive. I know you said it's a political situation, but storing...

If you have three data files in three separate filegroups, no you can't. If you restrict growth on the mdf and it's the only file in the PRIMARY filegroup, when...

Take a read through these:

http://www.sqlservercentral.com/articles/Administration/64582/

http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

I suspect you have a DB in full recovery and you're not taking log backups. In that case the log will grow until it fills the...

To be honest, I'd push back on this, hard.

Peer-to-peer replication is about the only thing...

ISNULL (IntegerColumnName, ReplacementValue)

The data type returned will be the 'larger' of INT and whatever the replacement value is.

btw, SQL doesn't have booleans. It has the bit data type which is...

Yes.

Well you need something that has all dates in it that you can join to.

Use a calendar table, left join from the calendar table to your data table (because you want all the rows from the calendar and matching rows from the data table)

Just a comment on this...

NEVER update the system tables. You can't touch them in most circumstances, it's very easy to make mistakes and break things and, by updating the system...

Why do you need to wrap that query in a distributed transaction?

Have you checked to see what error DTC is actually throwing?

Not unless the files are damaged in the process. SQL is perfectly capable of recovering from unexpected shutdowns

not enough disk space when...

SQL encounters a corrupt or unreadable page while doing a transaction rollback or crash recovery. Details...

My theme tune for the...