Viewing 15 posts - 4,096 through 4,110 (of 6,035 total)
RonKyle (2/27/2015)
He was afraid of the learning curve. I'm afraid of the problems they are going to have down the road as soon as more than 1 person wants to...
February 27, 2015 at 3:08 pm
A non-clustered index won't necessarily result in double I/O on reads. Given a well designed non-clustered index with all required columns included, it can entirely cover the user query without...
February 27, 2015 at 1:03 pm
N_Muller (2/26/2015)
......
To note is the fact that the table(s) will have millions of rows, but the customer will request data for at at most, 100 or so identifiers.
Regarding concerns about...
February 27, 2015 at 12:30 pm
ScottPletcher (2/27/2015)
A lower FILLFACTOR might be required. Since users always provide the up-to-50-byte key, the idea is to avoid having to create nonclustered indexes. This creates more I/O,...
February 27, 2015 at 12:25 pm
ScottPletcher (2/27/2015)
Eric M Russell (2/27/2015)
February 27, 2015 at 11:29 am
From what you've described, I'm envisioning the table as looking like something similar to this, bothin form and function, but it would help if we had the actual table definition.
create...
February 27, 2015 at 11:21 am
As a general rule, the clustered key should be sequentially incremented (to avoid page splits and accumulating fragmentation) and it should be narrow, because it will be used as the...
February 27, 2015 at 11:14 am
If the 10GB online storage limitation is not enough to contain reference or historical data, then there are options to link to the data externally. Access will be slow, and...
February 27, 2015 at 10:29 am
You're only seeing things from the client end of an ETL process. Perhaps there is some difference in the data retreival method used by MS Access versus SQL Server. My...
February 27, 2015 at 7:48 am
I would consider SSEE for a 10 user line of business application that doesn't require GB of reference data or ad-hoc queries. However, it would have to be a business...
February 27, 2015 at 7:41 am
Of course containing "date" values in VarChar columns is a bad idea from the start, and once it's done, it's no small change to undo, because there are applications and...
February 26, 2015 at 9:19 am
sstanek 27058 (2/26/2015)
February 26, 2015 at 8:57 am
PHYData DBA (2/25/2015)
Eric M Russell (2/25/2015)
February 25, 2015 at 9:58 am
If I offended anyone here with my analogy, of a table having no primary key, to that of a feral child having no name, then I'm sorry. I think that...
February 25, 2015 at 9:28 am
Great leaders are almost always great simplifiers, who can cut through argument, debate and doubt to offer a solution everybody can understand.
– Colin Powell
I believe this quote is particularly...
February 25, 2015 at 9:14 am
Viewing 15 posts - 4,096 through 4,110 (of 6,035 total)