Viewing 15 posts - 4,081 through 4,095 (of 6,026 total)
There are some 3rd part applications, for example employee project / time reporting or asset management, that require SQL Server as database but are relatively small scale and don't require...
March 3, 2015 at 11:27 am
At least for me, schema comparison is more of a diagnostic tool used in scenarios where I'm troubleshooting an issue in production and need to know what total differences there...
March 3, 2015 at 9:14 am
Bob JH Cullen (3/3/2015)
Eric M Russell (3/3/2015)
March 3, 2015 at 9:05 am
It sounds to me like some folks are just making in-place modifications to tables and stored procedures in the development environment and then using a schema compare against production too...
March 3, 2015 at 8:43 am
ZZartin (3/2/2015)
Jeff Moden (3/2/2015)
Don Halloran (3/1/2015)
(Also I hate web development 😛 )
Ah, yeah... we need to you move that smiley face one pixel to the right and change the color...
March 3, 2015 at 7:27 am
Migrations based deployments are based on tracking each change to a database in a separate script and then executing each script, in order, on your production database. This is hard...
March 2, 2015 at 12:20 pm
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
Viewing 15 posts - 4,081 through 4,095 (of 6,026 total)