Viewing 15 posts - 4,801 through 4,815 (of 22,211 total)
GilaMonster (4/19/2016)
And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?
If you do, I'm going to have to mark...
April 19, 2016 at 4:52 am
The way to automate backups is to use T-SQL (or Powershell). I cover all the basics in this article.[/url]
April 18, 2016 at 3:34 pm
The only things that immediately jump out are the two DISTINCT operations. That's usually a crutch for either bad data or bad data structures. To really improve performance, I'd address...
April 18, 2016 at 12:00 pm
April 18, 2016 at 11:03 am
I have to jump on with Jeff & Kevin on this one. By and large one should use the appropriate data types in the appropriate place. Is it a non-issue...
April 18, 2016 at 10:58 am
The primary is going to follow the settings for statistics updates. It won't change because the database is in an Availability Group.
April 18, 2016 at 7:59 am
jeff.mason (4/18/2016)
Grant Fritchey (4/18/2016)
If you do go to use extended events (also my advice on a 2012 forum),...
April 18, 2016 at 7:57 am
I'm with Lowell. I'm only writing the query if I get the grade.
If you're stuck, try writing the query. Show us what you have tried that doesn't work. I'm sure...
April 18, 2016 at 5:32 am
If the log backup is not running (and that's how I read the explanation), then the committed transactions won't be removed from the log and it will continue to grow....
April 18, 2016 at 5:30 am
SSMS doesn't "open" anything as a database. SSMS is just the client that lets you look at what is on the SQL Server instance. It's the instance that manages and...
April 18, 2016 at 5:28 am
Piling on, don't use the Profiler GUI against production systems. It hurts performance.
If you do go to use extended events (also my advice on a 2012 forum), be sure you...
April 18, 2016 at 5:21 am
At a really low level, it's how the storage of the information is maintained. But I'm with Jeff, a better definition of what you're trying to understand, other than just...
April 18, 2016 at 5:17 am
naveen.neerukattu1228 (4/18/2016)
Hi Homebrew01, johnwalker10Thankyou for your help and have little bit confusion around Refresh means Refresh will done with in single instance with multiple databases?
It completely depends on what's...
April 18, 2016 at 5:14 am
Lynn Pettis (4/15/2016)
Sergiy (4/14/2016)
nhansen pcc (4/11/2016)
Have you identified the corruption? has the server team looked at the drives or SAN?
Both our internal SAN team, and the vendor have looked...
April 16, 2016 at 10:58 am
What the heck is this doing in the JOIN criteria:
0 = 1
and pbu.bu_id is not null
I gave up after that. I'm not paid enough.
Instead of NOLOCK on umpti-gazillion tables, why...
April 15, 2016 at 11:12 am
Viewing 15 posts - 4,801 through 4,815 (of 22,211 total)