Viewing 15 posts - 4,126 through 4,140 (of 6,041 total)
On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from another table but initially empty. Also,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2015 at 10:03 am
GoofyGuy (2/20/2015)
Where do you think Senior DBAs end up?In the grave, as far away from deceased programmers as is possible.
So, where does an Entity Framework developer land when you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2015 at 10:32 am
Regardless of where the remote server is located, so long as there is a LAN connection between, then latency is not an issue when pulling across hundreds or a few...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2015 at 8:39 am
"Where do senior DBAs land finally?"
That's a self-answering question. If you want to do something more, then you have to become something else besides a senior level DBA....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2015 at 7:01 am
jackson.fabros (2/19/2015)
Aside from the obvious (stop, listen, take notes, repeat),...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 2:35 pm
patrickmcginnis59 10839 (2/19/2015)Ok I'll bite, why is the row lookup slower on heaps? There is still an (invisible) key to the row.
OK
When a table is non-clustered heap, SQL Server adds...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 2:20 pm
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)It's unclear how a table containing only Title + Author, and duplicates allowed, would be used by an application. If someone wanted to know what titles...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 11:49 am
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)
ZZartin (2/19/2015)
I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 11:06 am
Alvin Ramard (2/19/2015)
A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan. ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 10:51 am
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)
ZZartin (2/19/2015)
I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need for or a possible...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 10:17 am
Depending on the level of detail in the record, an event can be uniquely identified by a combination of time, place, actor, and action. In this case the Account number...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 10:13 am
I wouldn't consider myself "lazy", but I do try to maintain only a small manageable number of priorities that I perceive "matter". Most IT developers do, which is why we...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 9:09 am
ZZartin (2/19/2015)
I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need for or a possible primary key.
To...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 8:57 am
Whipping up a complete stored procedure within a minute in front of a crowd is not what I do. Although looking at some of the poorly thought out legacy stored...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 8:25 am
ZZartin (2/19/2015)
Eric M Russell (2/19/2015)
Grant Fritchey (2/19/2015)
shane.green 1227 (2/19/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2015 at 8:01 am
Viewing 15 posts - 4,126 through 4,140 (of 6,041 total)