Viewing 15 posts - 2,521 through 2,535 (of 5,685 total)
Actually, you don't. What you want is a ForEach loop for each of the patterns, and then do what you need to via SSIS variables and expressions on the...
September 29, 2011 at 2:52 pm
Sapen,
Table Pins were more important when you had incredibly limited RAM on the older 32 bit machines. These days anything you'd want to pin will remain a 'hot' page...
September 29, 2011 at 2:50 pm
Chris Becker (9/29/2011)
Return rowcount is < 200 rows - this does not RPC:Complete then take 22 minutes to return to client, the time between rpc starting and completed event is...
September 29, 2011 at 2:48 pm
Heya Amy,
Not sure if this will help you or not, but an article I wrote about job postings and how to deal with them is here, if you can live...
September 29, 2011 at 1:14 pm
What's the rowcount and rowsize of the returned data? Have you tested the network throttles?
This may be a data return issue more then it's a coding issue. You...
September 29, 2011 at 1:04 pm
GilaMonster (9/29/2011)
Evil Kraig F (9/29/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Awesome...
September 29, 2011 at 12:55 pm
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
Awesome Gail, glad to see...
September 29, 2011 at 12:08 pm
Steve Jones - SSC Editor (9/27/2011)
Evil Kraig F (9/27/2011)
I...
September 27, 2011 at 5:31 pm
Took a bit to read through the discussion and decide if I wanted to go near it with a ten foot pole.
I don't.
On a side note, looks like I may...
September 27, 2011 at 4:33 pm
I got it right for the most horribly wrong reason. I'm still not familiar with some of the assumptions made in declarations.
I assumed this:
INSERT INTO #DATA VALUES('1 jan 2010...
September 27, 2011 at 1:58 pm
SQLRNNR (9/27/2011)
Evil Kraig F (9/27/2011)
Trey Staker (9/27/2011)
Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's really pricey but...
September 27, 2011 at 1:09 pm
GilaMonster (9/27/2011)
Evil Kraig F (9/27/2011)
homebrew01 (9/27/2011)
Evil Kraig F (9/26/2011)
I would approach this a little differently:
Is there an advantage ? Gail's seems easier to read, and I think hers could...
September 27, 2011 at 1:07 pm
mw112009 (9/27/2011)
Please disregard the previous reply.
The query did manage to split out the entire stored procedure.
So let me give it a try and let you know...
September 27, 2011 at 12:53 pm
Trey Staker (9/27/2011)
Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's really pricey but I got my company...
September 27, 2011 at 12:50 pm
homebrew01 (9/27/2011)
Evil Kraig F (9/26/2011)
I would approach this a little differently:
Is there an advantage ? Gail's seems easier to read, and I think hers could be restarted where it...
September 27, 2011 at 12:45 pm
Viewing 15 posts - 2,521 through 2,535 (of 5,685 total)