Viewing 15 posts - 6,856 through 6,870 (of 22,211 total)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday night party.
Need to get...
January 22, 2015 at 7:55 am
Jeff Moden (1/21/2015)
Sioban Krzywicki (1/21/2015)
I hope everyone here is ok with it too...
To be honest, I don't care if someone's eyes are on stems and they leave snail tracks. ...
January 21, 2015 at 2:20 pm
free_mascot (1/20/2015)
search engine work differently in different version to improve the performance. However while doing upgraded one should keep the db in the original compatibility mode unless...
January 20, 2015 at 6:32 am
Doing the rebuilds online can reduce contention, but it will increase the amount of time it takes. It's a tradeoff.
January 20, 2015 at 6:30 am
The execution plan is your bestest buddy in situations like this.
Joining to views is a common code smell in T-SQL. The language just doesn't lend itself to code reuse. While...
January 19, 2015 at 1:16 pm
I am clearly biased, but check out the books below in my signature.
January 19, 2015 at 1:12 pm
It could be any number of things. First thought is the changes to the cardinality estimator. See how many rows the execution plans think it's going to get from the...
January 19, 2015 at 1:09 pm
to really understand which of the queries are giving you the most pain, I strongly suggest you run the trace file through the RML Utilities (you'll have to recapture one...
January 19, 2015 at 5:58 am
Also remember that these processes are subject to blocking and resource contention. It could just be that there were more shared locks or something causing waits on the rebuild process...
January 19, 2015 at 5:54 am
Test, test, test, test, test.
I agree that keeping it simple and using ALTER TABLE is the right answer most of the time. I also agree that you may see...
January 19, 2015 at 5:52 am
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop,...
January 19, 2015 at 5:48 am
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop,...
January 19, 2015 at 5:45 am
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like...
January 18, 2015 at 12:58 pm
Very few choices there. You'll have to clean the data. Decide which dates are supposed to be correct and modify them. No other way around that.
January 18, 2015 at 7:08 am
Viewing 15 posts - 6,856 through 6,870 (of 22,211 total)