Viewing 15 posts - 2,776 through 2,790 (of 5,685 total)
We're definately going to need more information to help you puzzle this out.
can you provide the DDL to the table in question, and the actual execution plans? This isn't...
July 16, 2011 at 9:38 pm
whattheETL (7/15/2011)
July 15, 2011 at 4:34 pm
billiam904 (7/15/2011)
July 15, 2011 at 4:10 pm
billiam904 (7/15/2011)
At the moment, it is safer to stay at the job I am at. None of my old contacts are hiring either.
That's a decision you have to make....
July 15, 2011 at 3:14 pm
TravisDBA (7/15/2011)
Craig Farrell (7/15/2011)
July 15, 2011 at 3:07 pm
billiam904 (7/15/2011)
Craig,Are you will willing to work 12-15 hours a day
No.
for $600 a month?
If beers cost a buck at the bar and my rent was $150/month with $25/month in...
July 15, 2011 at 1:35 pm
Does anyone else see the problem with the concern of overseas outsourcing? It's not the people overseas that are the problem. We are.
We've fought long and hard to...
July 15, 2011 at 12:41 pm
Revenant (7/15/2011)
bopeavy (7/15/2011)
SQLRNNR (7-15-2011)
--------------------------------------------------------------------------------
motivation
observation
Conclusion
Wash, Rinse, and Repeat.
July 15, 2011 at 12:06 pm
To add to what Jason said, also see it from the business side.
When you call your cable company, which of the following do you want to hear?
"Yeah, Cable Internet, What's...
July 15, 2011 at 11:36 am
SevereIdea (7/15/2011)
July 15, 2011 at 11:32 am
graham.balmer (7/15/2011)
Ok. What about updating the partitioned view with another table, can't see how this can be done without referencing the view in the update to find the matching rows?
Can...
July 15, 2011 at 11:31 am
To redeem myself, with the A B only linked requirement, try the following:
SELECT
ms.*,
ma.*
from
#MySample AS ms
JOIN
#MyAddress AS ma
ONLEFT(ms.ID, 9) = RIGHT( ma.AddressCode, 9)
WHERE
LEFT( ma.Addresscode, 6) = 'A B '
July 15, 2011 at 11:21 am
Koen Verbeeck (7/14/2011)
Isn't this on the right track?http://www.microsoft.com/learning/en/us/course.aspx?id=2778A
It doesn't cover everything (such as reading a query plan), but it covers most of the basics...
Hm, right idea, but certainly misses a...
July 15, 2011 at 12:44 am
Unless the proc is performing dynamic sql, and if the proc is in the dbo schema, yes.
This is twofold. First, for the dynamic SQL, the dynamic component will then...
July 14, 2011 at 11:08 pm
Viewing 15 posts - 2,776 through 2,790 (of 5,685 total)