316 reputation
17
bio website
location
age
visits member for 2 years, 6 months
seen Mar 18 at 19:02

Jan
12
comment Getting each status change in a table
'Cause it's not just those columns; it's a metric ton of data per day, but this one column is all I care about for this crappy subquery. Martin saved my bacon!
Jan
12
accepted Getting each status change in a table
Jan
12
comment Getting each status change in a table
Perfect! And now I am more edumacated.
Jan
12
comment Getting each status change in a table
Sorry, power knocked out the office for about 10 hours. :P No, I need each date for each status change. So if it goes into status A 5 times, I need 5 dates. Be nice if it were just the first instance of A, but no such luck.
Jan
11
asked Getting each status change in a table
Nov
8
awarded  Tumbleweed
Nov
1
asked Error 7373 connecting to SSAS 2008 only from one machine
Jul
12
comment Sneaky rollback in SQL Server 2008 R2
Trace didn't show anything. I moved the t-log to a different drive and then added a new one and shrunk the current one down to nothing with no growth allowed so it essentially wouldn't be used. So far so good; unfortunately it's one of those 'have to define a positive with a negative' situations.
Jul
9
comment Sneaky rollback in SQL Server 2008 R2
SSIS workflow with no changes for months, and rollbacks that happen spontaneously: normally I'd be looking at SSIS too but it just doesn't compute. If a logic error exists for something that runs daily for months or years at a time, it would have shown up before now. I've gone through it and cannot find anything that would've been triggered these two random times. Hoping the t-log will shed some light but so far no dice.
Jul
9
awarded  Commentator
Jul
9
comment Sneaky rollback in SQL Server 2008 R2
Would t'were that it were so, but this is an automated system that only a select few have access to, and fewer have the ability to make changes to. And it happened again last night between 11 p.m. and 2:30 a.m. Is it possible that a corruption in the t-log would trigger a rollback of committed transactions? 'Cause these are committed, and they are rolling back.
Jul
8
comment Sneaky rollback in SQL Server 2008 R2
It's a set of nested SSIS pkgs and stored procs; each individual piece of the load has its own transaction wrapping it, with the exception of the bulk inserts. There are no nested transactions.
Jul
8
asked Sneaky rollback in SQL Server 2008 R2
Feb
13
comment SELECTing multiple columns through a subquery
Try the hints in this post: meta.stackoverflow.com/questions/156729/…
Feb
13
comment SELECTing multiple columns through a subquery
Do you have any sample data available?
Feb
13
answered SELECTing multiple columns through a subquery
Feb
5
comment Efficiently Filter Large Set With Disjunctions
Would it be possible to place your subquery into a temp table or table variable and build that way? With my larger tables, I sometimes get stung by subqueries. Covering indexes only take you so far.
Jan
14
accepted Restore only one datafile in SQL Server 2008 from partitioned database
Jan
11
asked Restore only one datafile in SQL Server 2008 from partitioned database
Sep
29
awarded  Yearling