Viewing 15 posts - 2,956 through 2,970 (of 6,041 total)
Rows are not guaranteed to return in any specific order unless you specify an ORDER BY clause. Please provide the DDL for the table so we have a better picture...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 11:44 am
Changing the clustered key from a ramdom GUID to a sequenial integer will help prevent page splits, so that that helps reduce I/O and blocking during inserts. It appears that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 11:08 am
Wayne West (1/21/2016)
Eric M Russell (1/21/2016)
... With connection pooling, the number of SPIDs won't measure the total number of "users" or "seats", but counting concurrent SPIDs can be used to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 10:16 am
Wayne West (1/21/2016)
Eric M Russell (1/21/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 10:08 am
ZZartin (1/21/2016)
Eric M Russell (1/21/2016)
Alex Gay (1/21/2016)
Eric M Russell (1/21/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 9:35 am
Also, Microsoft TechNet provides pre-configured virtual labs (a browser based on-demand VM) to go along with topical step-by-step instructional videos. You only need a Microsoft Live login ID to spin...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 9:22 am
When you say "foreign", I assume you mean identifying any characters not belonging to the Latin General language. Maybe I'm way off base, but as a first stab, experiment to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 9:09 am
Alex Gay (1/21/2016)
Eric M Russell (1/21/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 8:49 am
What I've done is create a change order ticket for each deployment. ServiceNow happens to be the production control system we use. Within the source control system for each project...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 8:40 am
How about a licensing model that simply charges for and caps the number of concurrent connections or non-system session SPIDs without concern for number of cores, distinct users (CAL), or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 8:10 am
Eirikur Eiriksson (1/20/2016)
...
Quite impressive, 28 operators in the execution plan, parallel execution, four full table scans and I'm now putting out the fire ignited by the CPU when running this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 7:14 am
Here you go. It's entirely possibly for multiple rows, or multiple columns within the same row, to tie for having highest date, so it will potentially return multiple rows in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 20, 2016 at 2:48 pm
"Gut Feel"? There is a pill for that.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 20, 2016 at 2:35 pm
Jonathan-Fussell (1/20/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 20, 2016 at 2:31 pm
Someone should do a spoof of the mockumentary film 'A Day Without a Mexican'. The premise and title would be: 'A Day Without a DBA'.
http://www.rottentomatoes.com/m/day_without_a_mexican
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 19, 2016 at 3:16 pm
Viewing 15 posts - 2,956 through 2,970 (of 6,041 total)