Viewing 15 posts - 3,466 through 3,480 (of 6,041 total)
Years ago I was involved in a SQL Server 2000 -> 2005 migration. There was a 3rd party hardware interface application that would not connect to SQL Server 2005. From...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 8:35 am
The purpose of foreign keys are understood by all here.
But, aside from it's impact on bulk load performance (typically not an issue for OLTP databases), can someone recap what...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 8:18 am
Just curious what type of code changes would be needed for a MS Access application originally designed for SQL Server 2005 to support SQL Server 2014 ?
Of course the connection...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 7:31 am
RonKyle (9/2/2015)
We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just generic objects....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 2, 2015 at 1:32 pm
We all just need to come to terms with the fact that application programmers have a need to locally persist things like shopping carts, messaging, or just generic objects. It...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 2, 2015 at 12:27 pm
I've seen cases when someone was attempt to use the Import Wizzard to load a table and accidentally checked the option 'Delete Existing' instead of 'Append', or where a miscoded...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 2, 2015 at 8:27 am
Psst! Hey Buddy! You wanna buy some source code?
Yuck, who let a sales repsentative for Red Hat wander into the data center? 😀
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 2, 2015 at 7:07 am
Apparently app programmers building a persistance layer think they're real database developers. 😛
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 2, 2015 at 7:01 am
First, use a schema comparison tool between the old and new database to confirm all indexes were migrated over.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2015 at 2:24 pm
Welsh Corgi (9/1/2015)
Ed Wagner (9/1/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2015 at 1:27 pm
Welsh Corgi (9/1/2015)
Unfortunately that is not a quick fix.They are running a lot of SP's that use Temp tables. Hundreds...
Here are a few TEMPDB related scripts from my toolbox.
This...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2015 at 1:08 pm
Welsh Corgi (9/1/2015)
Eric M Russell (8/31/2015)
Welsh Corgi (8/31/2015)
Eric M Russell (8/31/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2015 at 9:08 am
Estimating an IT development project help if you start with a framework. For example, in the home construction industry, unless you're going for a multi-million dollar Frank Lloyd Wright style...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2015 at 7:55 am
The idea of telling a computer to do x seems more bounded and contained than other professions, but it's really not. This is often because developers don't get a complete...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 1, 2015 at 7:27 am
Iwas Bornready (8/31/2015)
I wouldn't know what do do without foreign keys.
I have some idea of what doo doo would happen without foreign keys.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 31, 2015 at 2:48 pm
Viewing 15 posts - 3,466 through 3,480 (of 6,041 total)