Viewing 15 posts - 10,516 through 10,530 (of 49,566 total)
A threshold should be above what is normal for your server.
January 2, 2014 at 12:46 am
JohnFTamburo (12/31/2013)
Hi.As much as I hate loops, this is the right place for one in order to remove the data without ballooning the transaction log.
Loops don't prevent log growth. On...
January 2, 2014 at 12:09 am
Ed Wagner (12/9/2013)
with cte as (
select top 100000 oid
from problem_table
...
January 2, 2014 at 12:07 am
Why is 2 logins/sec the threshold and is this a problem? What's normal for this server?
January 2, 2014 at 12:03 am
One table. 500 rows is nothing, 200 000 rows per year is nothing. 365 tables per year is horrible.
January 1, 2014 at 6:56 am
And the error you got was....
December 31, 2013 at 5:21 am
ifts? You have full text enabled (and possibly set up with partitioning?) If so, drop your full text indexes, you can always rebuild them later if you need them
December 31, 2013 at 3:49 am
That query just shows that you have no tables or indexes created on any partition schemes, not that you have no partition schemes.
December 30, 2013 at 3:28 pm
Revenant (12/30/2013)
For performance tuning, I would reword it as "Measure often, tune when needed."
I was just thinking exactly that.
December 30, 2013 at 9:11 am
isuckatsql (12/30/2013)
Since i did not, i deleted the table from the DB and the partitions from my hard drive, assuming that would do the job.....WRONG !
That will indeed...
December 30, 2013 at 9:08 am
wolfkillj (12/30/2013)
is there really a performance problem or are you just "tuning" the query as a knee-jerk response to seeing a scan in the execution plan or some similar shibboleth?
Exactly.
I'm...
December 30, 2013 at 9:01 am
Updates to the system tables are not allowed.
What are you trying to do? If you want to remove partitions you should be using ALTER TABLE and merge the partitions or...
December 30, 2013 at 6:43 am
Parameter sniffing, or more accurately lack thereof. http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/
Try this, and note the slight changes I made to the dates and date comparison as well, as the original version could miss...
December 30, 2013 at 5:12 am
Ok, after another frustrating thread of 'why do you want to remove that operator from the query, is it causing problems', the next article on the to-do list (after I...
December 30, 2013 at 1:44 am
Have a look through the error log, find the errors that state why SQL is marking that database recovery_pending.
December 29, 2013 at 12:18 pm
Viewing 15 posts - 10,516 through 10,530 (of 49,566 total)