Viewing 15 posts - 2,266 through 2,280 (of 49,571 total)
ChrisM@Work (10/6/2016)
GilaMonster (10/6/2016)
Eirikur Eiriksson (10/6/2016)
Using a conditional IF statement is by far the simplest way of doing this.And is prone to the performance-related problems that Chris alluded to.
https://www.simple-talk.com/content/article.aspx?article=2280
We must be...
October 6, 2016 at 11:22 am
Just had one of the new staff members stop me in the kitchen to tell me about his friend who runs the SQL user group (he doesn't though does help...
October 6, 2016 at 6:52 am
Eirikur Eiriksson (10/6/2016)
Using a conditional IF statement is by far the simplest way of doing this.
And is prone to the performance-related problems that Chris alluded to.
https://www.simple-talk.com/content/article.aspx?article=2280
October 6, 2016 at 6:09 am
You've getting 'bad' plans in cache, sometimes the query gets a good plan on the first run (when the restart or maxdop 'works') and sometimes it gets a bad plan...
October 5, 2016 at 12:14 pm
1) Changing the maxdop setting clears the plan cache.
2) It's probably got nothing to do with maxdop
3) Extremely unlikely
You've probably got something like bad parameter sniffing or similar resulting in...
October 5, 2016 at 9:11 am
hurricaneDBA (10/5/2016)
It's done once a day due to space limitations at work
Doesn't make sense. The total size of the log backups will be about the same whether they're backed...
October 5, 2016 at 7:09 am
And why are you only backing the logs up once a day? The reason that logs get backed up is for recovery purposes, so that the database can be restored...
October 5, 2016 at 6:52 am
hurricaneDBA (10/5/2016)
Thanks for the reply GailI have 3 txn logs which have reached 3 GB.
What's the recommended route?
Leave them alone is the usual recommendation for log files
I know shrinking...
October 5, 2016 at 6:48 am
Log backups truncate the log, as in mark the log space as reusable. The do not reduce the size of the file.
October 5, 2016 at 6:36 am
Get someone in to do a performance tuning exercise on your server. That's about all I can suggest with such little information.
October 5, 2016 at 3:03 am
Oh, you mean the max size, not the growth.
It's 'limited' to 2TB, which is the maximum allowable size of a log file, so it's essentially the same as unlimited.
Not...
October 5, 2016 at 1:07 am
CferMN (10/4/2016)
Could you please explain how to tell what the table is most frequently filtered by or how to tell the most common predicate used against the table?
You go and...
October 4, 2016 at 1:58 pm
The screenshot shows the file growth is 10MB, exactly as the ALTER DATABASE specified. So, what's wrong?
October 4, 2016 at 8:21 am
That should work fine. Can you post a screenshot of the file properties after running that?
October 4, 2016 at 7:00 am
Viewing 15 posts - 2,266 through 2,280 (of 49,571 total)