If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other transactional databases, then consider more of a Kimball...

jerry-621596 (9/15/2016)

---

I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.

Seems like the mystery runs deeper...

I find it convenient to use xp_cmdshell to do things like execute NET or DOS commands for informational purposes, like in environments where the host server doesn't allow RDP connections....

Data Science belongs more on the Business Intelligence wing of the IT department, rather than over in the DBA wing. Certainly we as a DBA can leverage tools like Excel...

This happens for me occasionally, and I use the following script to update sysjobactivity to reflect that the last run ended, and then it calls procedure to stop the job.

declare...

djackson 22568 (9/15/2016)

---

Eric M Russell (9/15/2016)

---

But going back to Steve's editorial, organizations need to implement application level encryption (ie: PGP for emails) and database level encryption rather than relying on...

Gary Varga (9/15/2016)

---

Eric M Russell (9/15/2016)

---

But going back to Steve's editorial, organizations need to implement application level encryption (ie: PGP for emails) and database level encryption rather than relying on...

I'd reccomend against an indexed view for reasons mentioned earlier by others.

However, if this view is giving the reporting users everything they need, and they can tolerate some degree of...

Analyzing data while in the process of performing your job as a DBA is not really "science". It's just like knowing a little something about chemistry can help you be...

But going back to Steve's editorial, organizations need to implement application level encryption (ie: PGP for emails) and database level encryption rather than relying on infrastructure encryption like SSL, VPN,...

Iwas Bornready (9/15/2016)

---

Jeff Moden (9/14/2016)

---

Night? Free brainstorming for the company and it's at night?

I've heard of "Down Tools" or "Down...

You can't really elminate the number of tables joined unless you refactor your data model. However, Common Table Expressions can reduce the complexity, and sometimes improve the performance, of queries...

By setting the property RetainSameConnection = True on the Connection Manager, temporary tables created in one Control Flow task can be retained in another task. You would have X number...

Gary Varga (9/14/2016)

---

It is this sort of thing that has me longing for from the freelancers world that I live in. That none of my clients have yet to do...

djackson 22568 (9/14/2016)

---

Eric M Russell (9/14/2016)

---

djackson 22568 (9/13/2016)

---

I think more...