Viewing 15 posts - 6,016 through 6,030 (of 22,211 total)
Brandie Tarvin (5/27/2015)
Just curious how many people on The Thread are World Cup fans. Cause... STUFF and MORE STUFF.And I was wondering how y'all felt about it.
Damn! Still two more...
May 27, 2015 at 6:17 am
GilaMonster (5/27/2015)
WhiteLotus (5/26/2015)
I don’t think eliminate distinct will make any difference ….By which you mean you've tested it and it didn't make any difference? ....
Despite the fact that the DISTINCT...
May 27, 2015 at 4:30 am
I just ran a quick experiment with this code:
DECLARE @i INT = 0;
WHILE @i < 300
BEGIN
SELECT * FROM dbo.Agent AS a
SET @i += 1;
END
I was able to see all 300...
May 26, 2015 at 9:58 am
I'm happy to help out any way I can.
Why were you trying to get 250 execution plans though? I'm just confused (not questioning you).
May 26, 2015 at 9:48 am
You're using SSMS to capture a batch (sounds like a WHILE or CURSOR?) that is executing over 250 statements and you're trying to capture all 250 execution plans? I wouldn't...
May 26, 2015 at 7:17 am
If I'm understanding the question, you just need to use RESTORE ... WITH MOVE. There are samples at the link. Using WITH MOVE will allow you to rename the data...
May 26, 2015 at 7:14 am
If you're returning 45,000 rows out of a 197,000 row table, That's approximately 25% of all the data in the table. The fastest way for it to perform that will...
May 26, 2015 at 7:11 am
Do be cautious. If something has been locking a resource because it just didn't have a commit on the transaction, chances are the rollback will be fast. But if it's...
May 26, 2015 at 7:09 am
Another option, if you are in the 2012/2014 realm is to look at Availability Groups. You can have one that is read only and keeping it up to date is...
May 23, 2015 at 5:44 am
Thanks for the feedback. Everyone is pretty much mirroring my opinion on it. I'm not surprised.
May 23, 2015 at 5:12 am
Question for the crew since this is a fairly international audience, plagiarism
I understand that some cultures look at it very differently than most Western European-based ones do. There's the whole...
May 22, 2015 at 9:54 am
Eirikur Eiriksson (5/16/2015)
Still waiting for an answer to the question Why?😎
Can't possibly speak for the OP, but it sure looks like they've got a rats nest of triggers and...
May 22, 2015 at 7:42 am
Jack Corbett (5/22/2015)
My employer just finished a renovation and I'm...
May 22, 2015 at 6:53 am
For the process you have to be blocking itself, you're probably looking at a parallel plan on one or more of the queries involved. Here's what I'd do. First, capture...
May 22, 2015 at 5:56 am
audiocool (5/22/2015)
GilaMonster (5/22/2015)
audiocool (5/22/2015)
is the following service require to turn onSQL Server Analysis Service ?
Are you planning to use it's features? Are you planning to build cubes, do data mining...
May 22, 2015 at 3:24 am
Viewing 15 posts - 6,016 through 6,030 (of 22,211 total)