Viewing 15 posts - 2,956 through 2,970 (of 6,042 total)
The DMV dm_exec_procedure_stats returns one row for each cached stored procedure plan. There can be multiple cached plans for a single procedure (database_id, object_id). The column 'plan_handle' is the plan...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 21, 2016 at 11:51 am
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
Viewing 15 posts - 2,956 through 2,970 (of 6,042 total)