Viewing 15 posts - 4,246 through 4,260 (of 5,678 total)
Elliott Whitlow (1/25/2011)
With triggers we can either write the data to the other DB directly or use something like service broker to queue it up.
Side comment: Service...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 12:42 pm
That's the kind of situation that tends to get me in trouble with my mouth.
"Let's see, would you like that in Wild Assed Guess time formatting, or Goldbricking for Giggles...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 12:11 pm
CTEs are one-shot subquery definitions, only good for the next 'real' statement in the process.
They're more a way to organize subqueries into more intelligible code rather than creating unique structures...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:59 am
To SQL Server? Not really, not once you've opened the server's "door", so to speak.
Any chance you could post the query and execution plans for the windows and non-windows...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:48 am
GilaMonster (1/25/2011)
Craig Farrell (1/25/2011)
I've got it pretty good at the moment...
Wish I could say the same, as I'm sure my near-constant rants (whining) has implied. Starting to think about alternatives,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:42 am
Some quickies in addition to Grant's questions, and I agree on Cascades. I hate them with a passion. It's almost worse then the hidden logic behind triggers.
Why is...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:29 am
duncfair (1/25/2011)
Steve,SSRS isn't an option because the decision to use a 3rd party reporting tool isn't negotiable at this time.
Thanks
Welp, I'm afraid not knowing much, if anything, about Logi, we're...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:23 am
GilaMonster (1/25/2011)
ALZDBA (1/25/2011)
Sheer luxury :Wow:at least if you compare it to most of us :blink:
Yup. Wish I was in that position.
I've got it pretty good at the moment but that...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:20 am
Then you are relatively up a creek unless you bind in an MS Access front end for reporting, Crystal Reports (I think you can pay them some royalties to include...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 11:03 am
Just a quick addon to Phil's suggestion which is inline with what you're attempting, a quick and dirty alternative:
Use this in an execute SQL task and feed the result set...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 10:58 am
MB-400824 (1/25/2011)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 10:19 am
Do NOT go from 15,2 to 21, 10. You will most likely lose data.
Why?
15,2: 1234567890123.45
21,10: 12345678901.234567901
Note where the decimal ends up in precision.
You want 23,10, if...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 10:07 am
Brian McGee-355525 (1/25/2011)
I removed QuoteSplit as it is redundant, and I added an A4, to give me more than 10000 rows available to the tally table. That's it really,...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 25, 2011 at 9:44 am
Million Row Testbed:
INSERT INTO DeFielder (FileTypeID, FileData)
SELECT
1,
CASE WHEN t.N%2 = 0 THEN '"' + CONVERT( VARCHAR(150), NEWID()) + ',' + CONVERT( VARCHAR(150), NEWID()) + '"' ELSE CONVERT( VARCHAR(15), t.N)...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 8:56 pm
Sometimes I wonder if other authors out there feel the same way. Do writers assume their code will be rewritten by someone before it is used. Digital rights and...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2011 at 8:56 pm
Viewing 15 posts - 4,246 through 4,260 (of 5,678 total)