Viewing 15 posts - 6,796 through 6,810 (of 22,211 total)
Sioban Krzywicki (2/4/2015)
Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus, javelin). It was less than twice...
February 4, 2015 at 10:41 am
Without more evidence, I don't know.
It could just be bad parameter sniffing. It could be something else. Gather to data to be sure.
February 4, 2015 at 10:37 am
It's also possible that you're seeing differences in the plan because of ANSI connection settings being different between SSMS and the web app. Because, assuming you ran the query with...
February 4, 2015 at 10:18 am
This usually has one of two causes. The first, and the easiest, is that your statistics need to get rebuilt. They'll be rebuilt automatically as you use them, but they'll...
February 4, 2015 at 10:16 am
Eirikur Eiriksson (2/4/2015)
Sioban Krzywicki (2/4/2015)
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag of...
February 4, 2015 at 8:45 am
shew (2/4/2015)
Grant Fritchey (2/4/2015)
My book has been updated very extensively for SQL Server 2014.
I ran across a copy of your "SQL Server 2012 Query Performance Tuning" book this morning. This...
February 4, 2015 at 8:42 am
Brandie Tarvin (2/4/2015)
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag of wind and...
February 4, 2015 at 8:21 am
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag of wind and a bit of a...
February 4, 2015 at 7:53 am
One source of suggestions (and please, note that word, suggestions) for columns that might need an index are the Missing Index DMVs. But, the problem with using these is two-fold....
February 4, 2015 at 7:49 am
I too am not a fan of Management Data Warehouse. It works well enough, but misses so much you have to do a ton of extra work to get a...
February 4, 2015 at 7:41 am
Basically, there's a lock in place during execution to prevent updates during execution. That's all.
February 4, 2015 at 7:34 am
Ed Wagner (2/4/2015)
GilaMonster (2/4/2015)
Brandie Tarvin (2/4/2015)
GilaMonster (2/3/2015)
And spending the evening at the office because there are scheduled blackouts in my area. Again.Scheduled blackouts? Is the electrical grid overworked?
Yup, since 2008.
So,...
February 4, 2015 at 7:11 am
Just to toss another point of view in here, admittedly one that is vendor centric.
I work for Red Gate Software. I've used both our products and litespeed in production...
February 4, 2015 at 3:58 am
SQL Guy 1 (2/3/2015)
February 3, 2015 at 12:22 pm
The best way to monitor in SQL SErver 2008 or better with minimal impact on the server is to use Extended Events. Here's an article[/url] that specifically shows some suggestions...
February 3, 2015 at 12:19 pm
Viewing 15 posts - 6,796 through 6,810 (of 22,211 total)