Viewing 15 posts - 4,441 through 4,455 (of 5,685 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...
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...
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...
January 7, 2011 at 4:08 pm
Dangit, what's with me and double-posting today? Sorry, ignore.
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....
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...
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...
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...
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. ...
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...
January 7, 2011 at 3:06 pm
Grant Fritchey (1/7/2011)
Craig Farrell (1/7/2011)
Donalith (1/7/2011)
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...
January 7, 2011 at 1:43 pm
Donalith (1/7/2011)
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,...
January 7, 2011 at 11:28 am
Viewing 15 posts - 4,441 through 4,455 (of 5,685 total)