Viewing 15 posts - 4,351 through 4,365 (of 5,685 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...
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...
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).
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? ...
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...
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...
January 18, 2011 at 11:04 am
kenambrose (1/18/2011)
I respectfully disagree. To provide a teaching example for a database design...
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...
January 18, 2011 at 10:14 am
sqldba_icon (1/18/2011)
January 18, 2011 at 10:03 am
sravanb (1/18/2011)
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...
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!
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...
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...
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...
January 18, 2011 at 9:32 am
Viewing 15 posts - 4,351 through 4,365 (of 5,685 total)