Viewing 15 posts - 2,266 through 2,280 (of 4,080 total)
Have you thought about SQL Server Agent jobs, or just converting them to stored procedures?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 6, 2009 at 4:48 pm
SOM 😛
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 6, 2009 at 8:43 am
I don't worry about the rankings, Steve. I just worry about getting banned from SSC. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 6, 2009 at 8:19 am
Are insects minerals or vegetables?
Vegetables should really be used for table names.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 6, 2009 at 7:08 am
Thank you for clarifying that, Grant. I was up to 'Zebra' in my table names.
But I haven't started using dinosaur names or insect names...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 6, 2009 at 6:34 am
You're absolutely right, Steve. At that number of rows, hardly anything makes a noticeable difference.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 6, 2009 at 6:26 am
Or, how about this? The cte does the grouping like a temp table, but without any logging overhead.
;with cte as (
SELECT d.name,
COUNT(DISTINCT a.ID) AS DistinctIDs,
SUM(DISTINCT...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 5, 2009 at 7:55 pm
The example using a set of SELECT statements linked by UNION ALLs is a single INSERT of the set of all rows. The other example executes a single...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 5, 2009 at 7:41 pm
I'm not sure exactly what you mean by basing an index on a stored procedure. Can you give us a little more concrete example of what 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
October 5, 2009 at 7:38 pm
Barry, for some reason the music from "Twilight Zone" keeps running through my head now.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 3, 2009 at 1:42 pm
Have a great weekend guys!
Roy, near as I can tell the conversation following Lynn's dynamic tally table article has been diverting posts away from The Thread.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 2, 2009 at 3:39 pm
I've had a lot of moments like that in here, Matt 🙂 I'm not sure if it equates to +1 wisdom, or +1 intelligence, but one day...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 2, 2009 at 3:29 pm
INLINE table-valued functions are essentially views with parameters.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 1, 2009 at 2:18 pm
Sounds like you need to get with your dba and check permissions.
__________________________________________________
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 30, 2009 at 6:52 am
The question itself is obscure, so why not?
__________________________________________________
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 29, 2009 at 4:57 pm
Viewing 15 posts - 2,266 through 2,280 (of 4,080 total)