Viewing 15 posts - 5,596 through 5,610 (of 5,678 total)
CirquedeSQLeil (9/15/2010)
Steve Jones - Editor (9/15/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
September 15, 2010 at 12:51 pm
rpalacios 19022 (9/15/2010)
Derrick, when I execute the new query, I'm getting the following error:
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "aspnet_users1.ApplicationId" could...
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
September 15, 2010 at 12:46 pm
I'm... not sure. But, hazarding a guess, it's got to do with Truncate simply doing page deallocations instead of actually wiping data. Now, why backup is actually picking...
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
September 15, 2010 at 12:42 pm
drew.allen (9/15/2010)
Craig Farrell (9/15/2010)
- For these users, they need all items from somewhere else...-- Cross Join to create master list of user/itemcodes
It's actually not a CROSS JOIN, because the value...
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
September 15, 2010 at 11:22 am
brian_winzeler (9/15/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
September 15, 2010 at 11:03 am
Yeah, I didn't build DDL out for the table so I didn't doublecheck my code for functional running, but I forgot to drop AS [name] in at the select levels...
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
September 15, 2010 at 10:48 am
:ermm: Yikes. That is one twisted piece of code you've got there.
Let me see if I get this straight. You set the group code, get the itemcode/levelval, 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
September 14, 2010 at 7:10 pm
But but Lowell, If Iz answerz I kin haz internets cookie! Right? Prize iz internetz cookie?
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
September 14, 2010 at 6:52 pm
Not sure of your baseline for the data, I'm not sure if just under a minute is good, or bad, for this. However, to case statements:
In the select clause,...
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
September 14, 2010 at 3:43 pm
EDIT: (LOL, beaten to it twice. 😉 Ah well, have your choice of formatting then. 🙂 ) /EDIT
Best to do the aggregation as a subquery and your calculations...
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
September 14, 2010 at 2:20 pm
A couple of questions:
Have you done any attempts to determine the throttle point, if it's reads from the Daily Transaction DBs, if it's network throughput, if it's the writes local,...
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
September 14, 2010 at 2:11 pm
Any chance you can post the table/index definitions and a query your reports use? Helps us to try to figure out if you've optimized to indexes and the like...
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
September 14, 2010 at 11:07 am
I would doubt it. I'd look more for a funky piece of data. If you can, find out what the numeric settings they have are, then go 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
September 13, 2010 at 2:53 pm
npeters 86796 (9/13/2010)
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER TRIGGER [dbo].[zDT_RM00301U] ON [dbo].[RM00301] AFTER UPDATE
AS
set nocount on
BEGIN
UPDATE dbo.RM00301
SET DEX_ROW_TS = GETUTCDATE()...
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
September 13, 2010 at 12:30 pm
Considering many of my scripts run 2k characters or more, I'd have thought I'd have ran into it if it did. I just took a breeze through tools-options 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
September 10, 2010 at 12:42 pm
Viewing 15 posts - 5,596 through 5,610 (of 5,678 total)