I share your concerns, and appreciate you pointing this out, but unfortunately (as I'm sure you experts know) there are some cases where we have no choice but to use...

I finally figured this out. I'm not exactly sure why my permission worked,...

What are the exact errors you are seeing in your errorlog when SQL tries to start?

Are your statistics up to date for sure?

Koen Verbeeck (10/9/2014)

---

Jason Shadonix (10/9/2014)

---

And look at the disk space the table is using before and after the index. Especially if you do a lot of included columns in...

And look at the disk space the table is using before and after the index. Especially if you do a lot of included columns in that index.

copling (9/11/2014)

---

Great article; however, I can't really think of need to use Synonyms for my line of business at this moment. However, I do have 1 question. Is there a...

Wilfred van Dijk (9/11/2014)

---

We had an application which installed a database for every company defined in our organization. Each database had a postalcode table which was updated several times a...

waldodj2000 (9/11/2014)

---

What you think about synonyms vs views?

In a view i do: SELECT * FROM server.db.dbo.table

and then I use SELECT * FROM myVIEW

In a Synonyms i do the same.

what...

mjbrichards (9/11/2014)

---

One of the most useful things about synonyms that we've found is that using a synonym stops SQL Server escalating to MSDTC (with its associated performance overhead) when you...

I just had to do another install today, so I made a point to ask for a password with a quote in it. I can confirm that double-quoting does...

We have done that with VMWare literally hundreds of times and it works very well and saves lots of time.

I can't speak to what OS/Network/DNS/AD level stuff the HW team...

I ended up giving up and just installing manually. Next time I have a password with a quote in it I'll try the double quote and see what happens....

Steve Jones - SSC Editor (8/13/2014)

---

Jason Shadonix (8/3/2014)

---

We use synonyms here and there, and have never had any issues with them "not working".

We use SPs over SQL code...

Howard C. BAchtel-438731 (8/4/2014)

---

Jason,

Thanks for your response. I am a newbie using MDX for retrieving data and I hope to answer your questions:

The amount of data retrieved is approx....