Grumpy DBA (4/15/2016)

---

True, although the OP referred to detaching the files (why are mdf and ldf files on the same drive?), copying and pasting to another drive to "create space"...

Here's an example of how I've used triggers in the past. We wrote an order entry system that had an EAV design for attributes. The design, this was...

Brandie,

A couple of things:

1. How did you deploy the packages to msdb? I haven't used msdb with 2012 as we are using the project deployment model, but I do...

Grant Fritchey (4/8/2016)

---

BL0B_EATER (4/8/2016)

---

Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would...

SQLRNNR (4/6/2016)

---

Dang...

Interesting. I believe that is there for mirroring & availability groups but if it works for this situation even better.

All I can say is "Wow!".

The only thing I can think of to do within SSIS is to do something like an Execute SQL Task as the first step that...

Your first issue is that you can't use a variable directly as a table name. SQL is assuming that @MyTable is a table variable NOT a table name. You'll...

I'll second the recommendation of PowerBI. Ad hoc reporting and data analysis are really what it is designed for. You definitely don't want to just turn your users...

I'm pretty sure you don't want to make that domain group the owner of the database anyway. That would be the same thing as putting all those users in...

Does someone have the file open in Excel?

I can only echo what Hugo has already said. Triggers are a tool that has its uses, but, like all tools, need to be used correctly. You don't...

Can you verify that the query returns non-zero values?

Are there any expressions on the dataset?

Grant Fritchey (3/23/2016)

---

BL0B_EATER (3/23/2016)

---

I might get slapped by asking this but what does it take to get an MVP award? ( just curious). To the people that hold one is...

BL0B_EATER (3/23/2016)

---

I might get slapped by asking this but what does it take to get an MVP award? ( just curious). To the people that hold one is it your...