Ha, should be easy for someone like you, Thomas. Tackle it. Just looking for 2-3 pages on how solutions work.

Interesting. I'll have to play with this. No time now, but I've done some Python, and have been working with the SDTIG on their Python series. I've gotten behind,...

Manually, probably. However, I'd script out the change from the wizard (I think this allows this) and then add an item to the script to change the linked server password.

http://blog.sqltechie.com/2008/12/spaddlinkedsrvlogin-to-modify-or-add.html

alternatives to shrinking to reclaim space? No.

However, as Lynn noted, indexes should be rebuilt. Once you shrink, you might dramatically fragment data. Worth keeping 2x your largest table in free...

We're not really a MySQL site, so we might not be great at helping here.

What's I'd suggest is that you do a few things.

1. learn to retrieve the XML from...

How can you determine if a new value is unique if you already have duplicates?

What would be your definition? Remember that there is no order to rows, so you can't...

You'll need to provide more of a description of what is and isn't working. We can't see your data, so please include the table DDL, some sample data, and then...

Yes, this is a warning that you should understand if you are using an aggregate (SUM, AVG, etC), that the row with a NULL value is not included.

70-464 is the BI exam. There's not a separate BI cert. Go for MCSE or MCSA, depending on what you want.

There isn't a specific certification for BI technologies: https://www.microsoft.com/en-us/learning/sql-certification.aspx

MS 70-463 is the BI exam: https://www.microsoft.com/en-us/learning/course.aspx?cid=20463

Ed Wagner (4/21/2016)

---

Steve Jones - SSC Editor (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops...

Haven't seen this much. Typically people just let SQL cache things itself, but I could understand how a large load might benefit here, distributing some of the work.

I know a...

Why? That's the architecture. No reason to do more than need to understand this. You can complain to MS, but I doubt they're changing this anytime soon, and certainly not...

Two ways:

1. Use a trace to capture when tables are queried. Takes time, and not necessarily correct.

2. Use a file search mechanism against all of your .RDL files in the...

MadAdmin (4/22/2016)

---

Check to see if the indexes are being used, or if they are duplicated, or if you can create better indexes, i.e. consolidate.

It would be horrible to rebuild 800GB...