Viewing 15 posts - 2,221 through 2,235 (of 6,041 total)
SEO (search engine optimization) is a broad general term; there are many forms of search engines besides web searching and Google. Are we talking about a web search engine or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 28, 2016 at 7:25 am
Pingala (9/28/2016)
I am not sure how many rows are in a particular "queued" delete operation. Does indexing help?
Like I mentioned above, an index on the DELETE's WHERE clause predicate is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 28, 2016 at 7:11 am
Talib123 (9/27/2016)
I'm a production DBA and have been for a good while.
I can query, join filters but how do I get my T-sql skills to a developer\Report writer...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 2:53 pm
Steve Jones - SSC Editor (9/27/2016)
That I agree with.
Where I work now, we have a dedicated DevOps team who performs functions like application configuration and support, deployments, automation tooling, etc....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 12:41 pm
Steve Jones - SSC Editor (9/27/2016)
Eric M Russell (9/27/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 11:54 am
Are you deleting one row or a range or rows?
Also, is the selectivity of the delete operation covered by an index?
For example, if you DELETE FROM TABLEA WHERE...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 9:38 am
Grant Fritchey (9/27/2016)
Rich Mechaber (9/27/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 8:39 am
Especially for a flattened table, using DATA_COMPRESSION = PAGE option on a conventional row store clustered index table should result in 50% - 70% compression, which does translate into fewer...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 8:33 am
200k rows isn't very large to begin with, and a medium sized server can easily table scan that within a few seconds with no indexing. But since it's for archival...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 8:21 am
DevOps works when it's intentional; like when IT staff have DevOps as part of their official job description, are separate from the development team and have their own manager. DevOps...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 27, 2016 at 7:32 am
Steven.Grzybowski (9/26/2016)
Inside that locked box is medication. Lots and lots of medication. My regularly prescribed daily meds, every OTC NSAID you can think of,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 26, 2016 at 3:53 pm
ScottPletcher (9/26/2016)
Eric M Russell (9/26/2016)
ScottPletcher (9/23/2016)
Eric M Russell (9/23/2016)
Regardless of SQL Server version, performance optimization should start by looking at execution plans.
Not necessarily. If the best clustered indexes are...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 26, 2016 at 10:51 am
ScottPletcher (9/23/2016)
Eric M Russell (9/23/2016)
Regardless of SQL Server version, performance optimization should start by looking at execution plans.
Not necessarily. If the best clustered indexes are not already in place,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 26, 2016 at 9:01 am
In all fairness to the DBA, this situation might be a reacton to the IT environment; for example office politics, the incentive program, or micromanagement on the part of upper...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 26, 2016 at 8:27 am
Yes, what can't be measured cannot be managed.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 24, 2016 at 12:35 pm
Viewing 15 posts - 2,221 through 2,235 (of 6,041 total)