Viewing 15 posts - 4,351 through 4,365 (of 5,678 total)
navecomp (1/18/2011)
How would you troubleshoot INSERT errors when dealing with a large data-set (100+ fields)?
Practically, I copy the DDL to a new table, point the insert at that, and then...
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 18, 2011 at 11:21 am
Then your object is configured wrong, or your exec statements are coughing up errors. Things to check offhand:
It doesn't appear that you're using parameters, so make sure there's nothing...
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 18, 2011 at 11:19 am
First thing: Check for some cross database ownership chaining and cross DB calls from your procs. They're waiting, it seems, for access to the pages in memory (latches).
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 18, 2011 at 11:13 am
Alvin Ramard (1/18/2011)
Steve Jones - SSC Editor (1/18/2011)
Alvin Ramard (1/18/2011)
Craig Farrell (1/18/2011)
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.
Anyone got a guitar? ...
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 18, 2011 at 11:11 am
I don't believe it's a script error offhand, but would you mind doing a quick test? Can you try only one of the EXEC items in the T-SQL task...
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 18, 2011 at 11:10 am
JEFFREY SCHELL (1/18/2011)
Thanks for the quick response!
No problem. 🙂
Definitely option 3 is a semi denormalized option but would you agree it is the best performer in terms of SELECTs? In...
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 18, 2011 at 11:04 am
kenambrose (1/18/2011)
I respectfully disagree. To provide a teaching example for a database design...
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 18, 2011 at 10:55 am
If you don't mind a little research I did from another thread, a quick test I did:
http://www.sqlservercentral.com/Forums/Topic1046084-392-1.aspx#bm1046202
That said...
Option 3 is the worst performer if you ever change the values...
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 18, 2011 at 10:14 am
sqldba_icon (1/18/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 18, 2011 at 10:03 am
sravanb (1/18/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 18, 2011 at 9:59 am
SQLSmasher (1/18/2011)
try thisselect id, avg(sal) from @temp
where sal <> 0
group by id
having count(reportingperiod) = 2
declare variable to store reportingperiod. in above example i have used constant 2
WHa?
non - zero...
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 18, 2011 at 9:57 am
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.
Anyone got a guitar? We can make a country song out of them!
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 18, 2011 at 9:53 am
kthanigaivel (1/18/2011)
that table contains 50 rows around 1.5mb.we need better solution.
50 Rows? At 1.5 MB? That's... (counts off on his fingers, removes a shoe...) 30k per row?
That's LOB...
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 18, 2011 at 9:48 am
Keymoo,
I scanned through your code twice, and nowhere can I find anything that seems like it would translate to your pctDescription column. Am I missing something here, or does...
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 18, 2011 at 9:38 am
Simon Hardstaff (1/18/2011)
If we watch the process thread in the SSMS we keep seeing ‘Suspended’ (Wait type) against ‘PageIOLatch.EX’ or ‘PageIOLatch.SH’
Those are drive I/O waits. You're pulling, most likely, off...
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 18, 2011 at 9:32 am
Viewing 15 posts - 4,351 through 4,365 (of 5,678 total)