Viewing 15 posts - 46 through 60 (of 5,678 total)
peter478 (11/10/2014)
can you post me a link for passthrough queries you mean?
http://support.microsoft.com/kb/303968/
Or simply google: microsoft access passthrough query
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
November 10, 2014 at 10:44 pm
As far as I know up to 2k8R2 there isn't an option for that. It's possible 2012/14 has it, I haven't played there.
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
November 10, 2014 at 12:14 pm
Not sure I understand the intricacies of what you're doing, I'm a little lost in your explanation, but if it's a 1:1 from Description to code, a Lookup Component with...
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
November 10, 2014 at 12:13 pm
Alvin Ramard (11/10/2014)
I'd like to know where so many people got the idea that the database should be set to Simple Recovery Mode first.
Bad habits from DTS when I used...
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
November 10, 2014 at 11:55 am
The single or multiple SQL User doesn't matter, just FYI. Most webapps run that way with hundreds of thousands of unique users on the far end.
What's happening with #amp...
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
November 10, 2014 at 11:50 am
Keeping query tuning to the side is like asking to create a sentence without verbs.
Queries are what puts the pressure on systems. Knowing which queries hurt can point you...
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
November 7, 2014 at 4:16 pm
Groups is a character string. So, you've lost your wrappers for it being text.
You need something like @sql = @sql + ' WHERE groups = ''' + @groups ''''.
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
November 7, 2014 at 4:10 pm
Depends on how much else is in the table. The Clustered Index carries the entire table at the leaf level, the Non-Clustered only carries included columns and information needed...
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
November 7, 2014 at 4:03 pm
Steve Jones - SSC Editor (11/4/2014)
We made a few forum changes today. If you notice something, let us know.
Recent Posts dropdown doesn't seem to want to work on IE9 through...
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
November 7, 2014 at 11:06 am
JeeTee (11/3/2014)
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
November 6, 2014 at 4:51 pm
I agree with Phil on this one, but I'd take it one step further. You're building what I usually nickname a "Mainframe File", where row ordering is important to...
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
November 6, 2014 at 4:37 pm
As a side note, if you haven't gotten yourself upgraded (like my shop) past 2k8R2, I still use variables and configurations... I just configure the variables, then share that config...
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
November 6, 2014 at 4:30 pm
PatrickIndex (10/28/2014)
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, 2014 at 12:17 pm
Doctor Who 2 (10/27/2014)
That makes sense Craig, thank you. But what about management? They don't debug anything. They may test software, but are as likely as not to test anything.
Management...
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 27, 2014 at 6:16 pm
N_Muller (10/27/2014)
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 27, 2014 at 6:12 pm
Viewing 15 posts - 46 through 60 (of 5,678 total)