Viewing 15 posts - 676 through 690 (of 1,353 total)
If you have a new box, install SQL 2008 R2 on that box. Restore the database(s) from backup. Then change the compatibility level and test the application against the database...
March 5, 2015 at 9:11 am
Usually aggregatable = False is used for hanger dimensions. Even if you think operationally it doesn't make sense to sum the tems, from the cube standpoint, this may not...
March 3, 2015 at 10:09 am
You should have gotten a warning message when you set that that you wouldn't be able to use the rejected records feature.
March 3, 2015 at 8:43 am
I agree this is strange. Only records that are for whatever reason in error should be rejected. It is possible to add the error number to the output....
March 3, 2015 at 8:09 am
I did create the PK using the table designer in SSMS, so it did create clustered indexes (according to the Indexes list in SSMS). I can't imagine a situation where...
March 2, 2015 at 8:00 am
It's been a long time since I've used Access for anything, but if I remember correctly Access creates locks against whatever tables it touches, and doesn't let them go until...
February 27, 2015 at 2:48 pm
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 use...
February 27, 2015 at 2:25 pm
We sell an application that needs a database and use SQL Express
What do you use for a front-end?
February 27, 2015 at 1:25 pm
all three of my projects at my last job had aspx front-ends
That would illustrate my point. Access has a niche for which solutions can be developed very quickly. ...
February 27, 2015 at 7:49 am
Personally I find the exists/not exists statements to be more difficult to write, while the LEFT JOIN WHERE IS NULL is extremely intuitive to me. It's interesting to discover...
February 27, 2015 at 7:38 am
As a replacement for access?
Everyone's talked about the database, but what about the front end developement. What do you use, and how long does it take to make a...
February 27, 2015 at 7:24 am
SQL is a poor realization of a "true" RDBMS
Can you explain this a little more. Why is it a "poor" realization? It seems fine in most cases to...
February 12, 2015 at 6:45 am
It is otherwise OK.
There's nothing wrong with a uniqueidentifier primary key. If the system is going to use an artificial key, it's not much better or worse than an...
February 4, 2015 at 7:18 am
There are cases where using a GUID as the primary key is valid. The problem comes if you also make it your clustered index.
These cases are rare. To say...
February 3, 2015 at 2:19 pm
CELKO (2/2/2015)
--------------------------------------------------------------------------------
This is a garbage pile; it has not key and no way to have a key.
I thought they called that a heap?
A heap is a table without a...
February 3, 2015 at 7:16 am
Viewing 15 posts - 676 through 690 (of 1,353 total)