Viewing 15 posts - 5,176 through 5,190 (of 5,678 total)
Andrew above has the best 'simple' method. An alternative would be, when this gets more complex, to include a script object and sequence containers that you enable/disable as necessary...
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
October 29, 2010 at 2:00 pm
WHERE (@gender = 'B' OR gender = @gender)
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
October 29, 2010 at 1:46 pm
Michael Valentine Jones (10/29/2010)
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
October 29, 2010 at 12:52 pm
EDIT: That was a dumb idea on further review.... nixing my first comment.
Check this link:
Seems to have a lot to do with the SQL Server installation, but beyond that, I...
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
October 29, 2010 at 12:20 pm
Can you confirm that both the indexing and the data volume are the same between the Test and the Prod servers you're getting different results on?
There's more here than blocking,...
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
October 29, 2010 at 12:17 pm
Heh, meant to say the grants themselves aren't the concern, sorry for that.
That is the beginnings of a perfectly good monster, alright, but I'm curious about the wrapper logic. ...
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
October 29, 2010 at 11:55 am
I've been through four, but only managed to find *one* auditor who would actually talk to me. They tend to be incredibly tight lipped, but we smoked together a...
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
October 29, 2010 at 10:53 am
Mymail,
The grant's are the concern, it's the IX (Intent Exclusives) I'm curious about. Beyond that though, the very short description you gave scares the heck out of my inner...
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
October 28, 2010 at 8:03 pm
This scream "Homework Problem" to anyone else?
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
October 28, 2010 at 8:01 pm
Think this would be a bit much as my signature?
CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT
AS
-- Go read the documents, inline comments are for sissies.
IF EXISTS (SELECT * FROM...
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
October 28, 2010 at 5:39 pm
You're looking at the difference of pre-allocated pages being re-used, if my understanding is accurate. Less prepwork for the engine.
SQL Server doesn't let you do pre-allocates inside the allocated...
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
October 28, 2010 at 5:31 pm
CELKO (10/28/2010)
Look up the COALESCE() function. Do not use the old Sybase museum ISNULL(). They are not quite the same and you can get screwed.
The museum piece is faster.
http://jerrytech.blogspot.com/2006/05/sql-2k-performance-isnull-vs-coalesce.html
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/performance-isnull-vs-coalesce.aspx
Is it...
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
October 28, 2010 at 5:20 pm
WayneS (10/28/2010)
Craig - I see you came through on your threat of a ST avatar! Seems appropriate, especially in the thread with Joes latest rant.
Sadly appropriate. Why is it...
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
October 28, 2010 at 4:06 pm
preensheen (10/27/2010)
John Rowan (10/26/2010)
Data Flow source adapters do allow for SP execution. Does attempting this give you an error?
Yes, i am trying to pass parameter and and everything correctly...
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
October 28, 2010 at 3:38 pm
mbender (10/28/2010)
I've just started using them as work tables, and have really enjoyed it. Normally we would do all the work in the...
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
October 28, 2010 at 3:32 pm
Viewing 15 posts - 5,176 through 5,190 (of 5,678 total)