Viewing 15 posts - 18,511 through 18,525 (of 22,202 total)
Yep. It can be done. We're using it as part of our migration plan too. I didn't do the setup myself, but I can ask the guy who did it...
February 3, 2009 at 6:17 am
With linked servers I almost always do one of two things. Put the entire load on the linked server, meaning, perform all the joins, etc. on that machine and get...
February 3, 2009 at 6:07 am
Can you post the actual execution plan? Simply looking at a slice of the code we may or may not be able to identify an issue, but looking at the...
February 3, 2009 at 6:04 am
You can use trace events to capture individual statements within a stored procedure. Is that what you're looking for?
February 3, 2009 at 5:59 am
No need to be sorry. Just trying to help. You'll get more eyeballs on your question when it's new if you make it a new post. That's all.
February 3, 2009 at 5:40 am
Jeff Moden (2/2/2009)
Grant Fritchey (2/2/2009)
Jeff Moden (2/1/2009)
Grant Fritchey (1/23/2009)
There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER.
I'm thinking this one isn't about how to create...
February 3, 2009 at 5:37 am
I can't seem to open the new zip attachment. Sorry.
Looking at the query some more, you've got correlated sub-queries in the select list. This is effectively RBAR (row-by-agonizing-row) processing. Those...
February 3, 2009 at 5:34 am
Lynn Pettis (2/2/2009)
Matt Miller (2/2/2009)
Lynn Pettis (2/2/2009)
Phil Factor (2/2/2009)
Steve, you're supposed to be on holiday!
Typical geek, can't stay away. I should know, I do the same thing here, even...
February 2, 2009 at 10:59 am
I agree MSDN. You might also see if there's an introductory DBA book that has a good chapter on it.
February 2, 2009 at 9:30 am
Unless you're having troubles with the system, I wouldn't recommend changing the PK's on the tables.
That said, int is likely to index a bit better than char(10), so you'll get...
February 2, 2009 at 9:29 am
idrees.butt (2/2/2009)
I really wana read the books but they will be expensive and...
February 2, 2009 at 8:49 am
GilaMonster (2/2/2009)
I'd also recommend T-SQL Fundamentals by Itzik Ben-Gan. I've only glanced through it, but it looks good.
I agree. This is also a very good resource. Thinking about it some...
February 2, 2009 at 8:06 am
idrees.butt (2/2/2009)
Actually I find it always difficult to even understand the topics by which people post their problems. The content is so technical or specific that...
February 2, 2009 at 7:52 am
I agree with Jeff, portable code is a myth.
For the type of query you're running, let me say one thing, look at the execution plan for each query. I wouldn't...
February 2, 2009 at 6:58 am
Nice one. Sharp & direct.
February 2, 2009 at 6:53 am
Viewing 15 posts - 18,511 through 18,525 (of 22,202 total)