Viewing 15 posts - 1,366 through 1,380 (of 4,080 total)
declare @sample table (rowkey int, row1 varchar(50), row2 varchar(50))
insert into @sample
values
(1, 'dog', 'duck'),
(2, 'dog', 'duck'),
(3, 'dog', 'duck'),
(4, 'cat', 'cow'),
(5, 'cat', 'cow'),
(6, 'cat', 'mouse'),
(7, '', 'mouse'),
(8, ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:36 am
Some clarification please. You are apparently asking two different questions.
(1) What percentage of rows have been filled in for a particular column?
and
(2) What is the total...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 8:06 am
Any opinions on just getting rid of say 40% of the data? If you're trying to get a hundred rows out of 150 million, cutting...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 7:54 am
Did you ever stop to consider that if a product couldn't make it in the marketplace that maybe all the great performance increases you read about were just hype? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 23, 2010 at 7:29 am
There's a Western Europe in your reality? It wasn't partitioned by the South African Empire and the Canadian Hegemony. Then invaded by the Kiwi Confederation?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 7:43 pm
Alvin, I keep trying to explain this to you.
DBCC TIMEWARP is fully documented... in approximately half the alternate realities in the multiverse.
Of course all the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 4:27 pm
My alltime favorite from despair.com.
http://www.despair.com/gettowork.html
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 7:22 am
Interview question?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 7:17 am
You're right, Gail, I was a bit sloppy this morning. May I blame it on lack of caffeine?
Since Stock.Status.ID was a primary key, I assumed there would...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 7:04 am
One other variation:
;with cte as (SELECT TOP 10 * FROM Stock.Register ORDER BY Stock.Register.id)
SELECT *
FROM cte
INNER JOIN Stock.Status ON cte.stock_status_id = Stock.Status.id
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 6:51 am
Like Gail said, you really need to see the whole picture including execution plans to understand what is going on. But while you are doing that, could you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 22, 2010 at 6:05 am
You can use the OUTPUT clause with DELETE to save the deleted rows, like this. (You can use #temp tables or even permanent tables instead of the table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 8:14 pm
Walton,
Please make a note of how Jim set up the problem with scripts to create and populate the tables. The volunteers who help out here...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 7:55 pm
Solo Cerveza, por favor.
They come in ONES?? :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 4:03 pm
You spin me round round, baby, right round....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 21, 2010 at 3:05 pm
Viewing 15 posts - 1,366 through 1,380 (of 4,080 total)