Viewing 15 posts - 2,146 through 2,160 (of 2,339 total)
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?
November 15, 2014 at 6:33 am
mario17 (11/14/2014)
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...
November 15, 2014 at 6:24 am
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...
November 14, 2014 at 8:29 pm
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...
November 14, 2014 at 1:02 pm
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,...
November 14, 2014 at 12:50 pm
Google "port 1433". The vulnerabilities are endless....
November 12, 2014 at 11:34 am
I've put things back and now need to know how to open up the firewall to the new named instance when the port is dynamic.
You don't. You assign a...
November 12, 2014 at 9:06 am
That is not a linked server. If you are on the same instance, and querying two separate databases, you should see very good performance.
November 12, 2014 at 8:59 am
Johnny B (11/12/2014)
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...
November 12, 2014 at 8:45 am
Empty the recycle bin???
Show hidden files and folders?
Show protected operating system files?
November 6, 2014 at 11:44 am
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...
November 6, 2014 at 11:42 am
November 4, 2014 at 9:33 am
Kimberly Tripp describes VLF's in detail in this article
http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/
November 4, 2014 at 8:59 am
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...
November 4, 2014 at 8:55 am
Soundex may be more trouble.
SELECT SOUNDEX('First'), Soundex('Firsyth'). Yeah, that's really a street name around here!
Try to standardize the addresses.
In other words, change "Ave.", "Avenue", "Ave", and so forth...
October 29, 2014 at 2:01 pm
Viewing 15 posts - 2,146 through 2,160 (of 2,339 total)