Viewing 15 posts - 7,816 through 7,830 (of 22,213 total)
Kwisatz78 (7/2/2014)
In regards...
July 2, 2014 at 9:04 am
Did you hear, for a little while Tim Howard was listed on Wikipedia as the US Secretary of Defense. That's awesome.
July 2, 2014 at 8:01 am
yeah, I don't have a precise checklist that I use. I'm not sure of one either. Brad McGeehee may have one.
July 2, 2014 at 7:33 am
All things you need to do when designing a database fills books. In fact, if you're just getting started at database design, I'd strongly recommend reading a bunch of books....
July 2, 2014 at 6:45 am
Kwisatz78 (7/2/2014)
I actually have your book SQl Server 2012 Performance Tuning. The flow of the book seems to be arming the reader with techniques for tuning queries followed...
July 2, 2014 at 6:24 am
All performance tuning should start at the server. Ensure the server is well-configured first. Then start gathering metrics, again, at the server level to start. Wait stats, etc. Be sure...
July 2, 2014 at 5:07 am
Back to your basic argument, I'm with you. Using the language in the standard mechanism by default is usually the better approach. There are any number of valid reasons to...
July 2, 2014 at 3:41 am
GilaMonster (7/2/2014)
wilks (7/2/2014)
I had misunderstood the scan count from IO statistics, I see now it can refer to an index or table scan.
No, it doesn't. It is not a count...
July 2, 2014 at 3:39 am
You could capture a lot more information using extended events. You can usually capture machine name and other information with it. I'm not sure which event I'd set this one...
July 2, 2014 at 3:33 am
Just piling on a bit so you have some reinforcement. I'm with Sean and Jeff. Create the tables, but put them in a different schema. Separating function by naming convention...
July 2, 2014 at 3:28 am
Sounds like you have it covered. Lock escalation occurs, but I don't find it's a common thing. If you're doing the type of data load that's going to benefit from...
July 2, 2014 at 3:23 am
Sarah Wagner (7/1/2014)
SQLRNNR (7/1/2014)
Nice first article Sarah (at least here on SSC). If you have others, please let us know where to find them.
This was my first article. ...
July 1, 2014 at 4:49 pm
I've been hearing a lot of mixed stuff lately on the need to update statistics. Personally, I'd do it. It's not going to hurt anything and might help.
You can switch...
July 1, 2014 at 12:06 pm
michael.minarzick 97083 (7/1/2014)
There's no doubt that...
July 1, 2014 at 11:59 am
Viewing 15 posts - 7,816 through 7,830 (of 22,213 total)