Viewing 15 posts - 4,441 through 4,455 (of 5,678 total)
Okay, so, basically same thing.
For those following along, a pertinent quote from the article:
These are, as the name suggests, Recordsets that have been disconnected from the data source, thus allowing...
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 7, 2011 at 4:28 pm
Elliott Whitlow (1/7/2011)
Craig Farrell (1/7/2011)
Elliott Whitlow (1/7/2011)
The advent of CTE's do reduce the need for temp tables and table variables, but does not negate it.CEWII
Elliott, I'll have to disagree 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
January 7, 2011 at 4:12 pm
Sean,
Can you be more specific as to what you mean by a Disconnected Recordset?
The only thing I could find on it is from a programmatical standpoint where recordsets/datasets aren't 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
January 7, 2011 at 4:08 pm
Dangit, what's with me and double-posting today? Sorry, ignore.
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 7, 2011 at 3:56 pm
Jason,
%DiskTime and Queues are no longer valid parameters if you're working against SAN systems. If you have independent RAIDs, that's different. They're really meant for single spindle checks....
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 7, 2011 at 3:56 pm
Elliott Whitlow (1/7/2011)
The advent of CTE's do reduce the need for temp tables and table variables, but does not negate it.CEWII
Elliott, I'll have to disagree with you here. 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
January 7, 2011 at 3:52 pm
One alternative to this you might want to approach is the use of schemas on a per store basis. This way the front end code/proc/view calls don't have 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
January 7, 2011 at 3:48 pm
You'll probably want something along the lines of ( ISNULL( Firstname) == TRUE & ISNULL( LastName) == TRUE) ? 1 : 0 in a calculated field before entering 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
January 7, 2011 at 3:18 pm
Is it persisted, and can you show us the DDL that builds this table via script? That'll help.
You've already got a varchar(max) column in line with other data. ...
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 7, 2011 at 3:15 pm
because the binary conversion doesn't equate to just three characters.
declare @blah varBinary(8)
SET @blah = 0x746F680000000000
print @blah
print CONVERT( CHAR(8), @Blah, 0) -- Not sure why the 0 but figured I'd test...
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 7, 2011 at 3:06 pm
Grant Fritchey (1/7/2011)
Craig Farrell (1/7/2011)
Donalith (1/7/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 7, 2011 at 2:00 pm
Shifty,
Do get the wait stat information, it's important, but this also concerned me:
Average disk sec/Trans
P drive (RAID10 - 14 drives) 0.014
G drive (RAID10 - 14 drives) 0.014
K drive (where DB...
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 7, 2011 at 1:43 pm
Donalith (1/7/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 7, 2011 at 1:24 pm
wlblee38 (1/7/2011)
I'm not that familiar with functions is there a way to do this with SQL? Here's what i revise from your example.
:ermm: That was SQL. Proc based,...
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 7, 2011 at 11:28 am
Subbu,
Slow down, take a deep breath. Your post above doesn't make much sense but I'm guessing that's because you're typing quickly and in a bind.
Take a moment. Think...
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 7, 2011 at 11:24 am
Viewing 15 posts - 4,441 through 4,455 (of 5,678 total)