SQLisAwE5OmE (11/28/2015)

---

Hi Jeff,

I did not test the script yet, but i kind of got an idea...i need to enter the server name, db name and the path details.

In regards to...

Lynn Pettis (11/28/2015)

---

tt-615680 (11/27/2015)

---

Thank you for your reply, I'm running the following sql permission query which works fine on all other servers, the only difference is that a few of...

Hello and welcome to the forums.

You're right in that creating a new DNS name allows you to refer to the server name, but not the instance. Your connection strings...

SQL Server needs to be installed on the system you're using to restore, but it does not have to be installed on the drive you want to restore to. ...

Jeff Moden (11/28/2015)

---

When you start talking about tera-bytes for an instance, I'd start thinking about a lot more memory than 64GB per node and I wouldn't think about splitting it...

Nice sentiment, Phil. I know what you mean...giving back for good fortune seems altruistic, but I too get a lot out of it. Helping others comes with its...

Hello and welcome to the forums.

Your understanding is correct. If you need the data in the database, you must have enough space on the target machine to be able...

I have to agree with Kevin. I don't see what's wrong with running a trace either, but if that's the edict you have to live with, so be it....

I know precisely what you mean. Taking something down to its...

Grill

Whatever you do, please don't just run the DTA and create everything it wants. You'll probably end up with so much over-indexing that you won't be able to see...

I see the spam bomb went off again today. What's with the online TV stuff. It's almost as if the reddit links are multiplying.

From what you describe, it sounds like your tables are in fact joined together. So you want your job names as columns, right? What does the query return...

Well said. Steve and RedGate do a lot of work to keep SSC running. There are an awful lot of smart people in the SQL Server community that...

I come...