It seems that you need get the computer name inside SQL Server to match where it is now installed. You might start by reviewing the information below. I found...

The link below says you cna run this at the Publisher OR the Subscriber to remove replication objects.

https://msdn.microsoft.com/en-us/library/ms188734%28v=sql.110%29.aspx

I don't know of a way to do that. The GUI is going to automatically point to the tables that are in the database from which you start the...

jbalbo (1/22/2015)

---

Hi

First , sorry if I word this incorrectly....

We have setup a report server where a db's tables are refreshed from a backup daily.

All SP and views are created...

I would say you are on the right track. The two index examples would eat up space unnecessarily and would cause additional work for modification queries involving the Key...

Have to agree with Kevin's advice.

This question is really too broad. Are you...

Changing the compatibility mode after your third party software upgrade is in place should be fine. As Jeff indicated, you definitely want to do this in a test environment...

rob.lewis 86087 (1/12/2015)

---

Was wondering if there was a best practice minimum permissions for creating a SQL login to use when setting up a new shared Data source for SSRS report...

I purchased it and liked it a lot. There are a wide range of questions and great advice about how to think through questions that you may be asked...

Have you looked at the execution plans? Are they identical?

bgrossnickle (12/11/2014)

---

We have a nightly ETLV job that our 30 clients run every night. Depending on the size of the client, it can run from 1 to 7 hours. We...

tcronin 95651 (1/9/2015)

---

I have 2008r2 server 128 gig of RAM, quad proc 48 core, supporting 3rd party Medical Records app (no I can not change the app, I can and...

I would suggest going out to s place like brentozar.com and getting the sp_AskBrent stored proc and running it to see what it tells you in terms of performance issues....

PiMané (1/20/2015)

---

Hi,

I'm analyzing a server 2008 R2, build RTM...

I was looking at the sys.dm_io_virtual_file_stats and got scared with the tempdb write stalls... io_stall_write_ms/num_of_writes gives 1080ms.. 1 second average wait...

When I look up the idea of pausing the mirroring session I am not coming across anything that specifically addresses your question. Is it out of the question to...