Viewing 15 posts - 46 through 60 (of 253 total)
Let's follow up a bit on the topic of placing the queries in the newly minted SQl server back end.
Our goal is to provide an access front end and...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 20, 2017 at 4:27 pm
This small application has a ton of small update queries. It is fed by a daily extract from another must more robust application. We would have been better served if...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 14, 2017 at 4:10 pm
I've studied extensively but clearly not sufficiently to pass. I agree extensive practice in the obscure, seldom used features is necessary and memorizing exact syntax is necessary. My memory is...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 15, 2017 at 9:36 am
I've passed several SQl exams. But this exam with its emphasis on memorizing exact syntax for obscure SQL and XML seems misguided. When I need this type of information I google...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
August 14, 2017 at 10:53 am
It does require memorizing exact syntax for obscure TSQL and XML. I agree this is not relevant for most developers.
The other reason the tests are falling out of...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
July 19, 2017 at 11:47 am
We have a 200 gig database set to simple mode. In a few hours it created 50 gigs of transaction logs. Impressive.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 19, 2017 at 12:27 pm
Oops. One more:
Does it make sense to change the initial file sizes for the tempdb database in the gui? Since SQl does not change this,
it appears likely a...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 18, 2017 at 5:24 pm
correct The version we have is 2005 sp2. When I tried to install that version, I received an error message saying sp3 was required. And of course I could not...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 13, 2017 at 12:16 pm
I downloaded the sql express version closest to the one installed on the server. Afterwards I ran the MSIINV utility to deinstall SQL server. Of course this only removed components...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 13, 2017 at 11:46 am
The installation files are missing. the media files are still there. No easy way to de-install?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 12, 2017 at 3:15 pm
I decided to try upsizing using the Access application Database Tools option. For my first attempt I used a SQL server 2012 server and created a new database. It was...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 29, 2017 at 2:53 pm
Upon future investigation I determined most of the Access tables I tried to upsize were missing Primary keys. I will tell the developer to add them.
However, a...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 24, 2017 at 2:18 pm
I logged into another server with sql2014 installed. Tried to use the 64 bit SQL Data import function. The Access Database Engine option was present as a data source and...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 23, 2017 at 3:43 pm
One issue is several of the tables in the access database do not have primary keys. I did not design this monstrosity.
The sql server does not have access installed,...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 23, 2017 at 10:25 am
I've also tried importing the access data into a sql server 2014 server. The import function did not recognize the accdb file. I'm about ready to jump.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 22, 2017 at 4:49 pm
Viewing 15 posts - 46 through 60 (of 253 total)