jpbankston (11/17/2014)

---

Somewhat in line with the original question, I have a user whose login is used by the dbo user on a few databases. Consequently, that user has permissions...

I think you may have asked the wrong question.

My answer to you is:

What specific problem are you trying to solve? Or, what specific argument are you trying to win?

mario17 (11/14/2014)

---

Thanks SSCarpal,

Wow!!!, adding rows instead of columns, can you expand this topic a bit, if new client need to add extra info for given transaction, like Sex_ID for customer...

Hence my comment that EAV's mat not be very scalable.

Right now, there is a set of EAV's in our current system. The original intent was to solve the problem...

Possible answer #1

You gotta be kidding me. There are actually clients where we would need to add columns that would be specific to a client? The business rules, and...

Well, take a look at your SELECT query, and then look at your UPDATE query.

In the select, your WHERE clause is testing for the value 'Suite' in Line2.

In the update,...

Google "port 1433". The vulnerabilities are endless....

You don't. You assign a...

That is not a linked server. If you are on the same instance, and querying two separate databases, you should see very good performance.

Johnny B (11/12/2014)

---

Hi,

I have an existing 2012 default SQL Express. It's set up on a VPS managed by a third party. I have an administrator account on this 2012 Windows...

Empty the recycle bin???

Show hidden files and folders?

Show protected operating system files?

Have you tried to understand the transaction log, how it works, and the differences between Full, Bulk-logged, and simple recovery models?

Because if you had, you may not be asking this...

SSC Stairways:

http://www.sqlservercentral.com/stairway/73776/

Greg Larson on SimpleTalk

https://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/

Kimberly Tripp describes VLF's in detail in this article

http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

The main issue was when I clicked a link to go to a post on the forums from the main page.

But, this same thing occurred when clicked other links...