Viewing 15 posts - 11,206 through 11,220 (of 14,953 total)
clperez271172 (1/29/2009)
since I can do so that the logs of a dts keep in a specific table that is not that of sysdtspackageslog
I can't understand what you wrote.
January 29, 2009 at 2:39 pm
I like triggers. They make firearms much more user friendly than keyboards and mice would. 🙂
In my book, triggers have one good use, which is enforcing code at a...
January 29, 2009 at 2:37 pm
Bruce W Cassidy (1/29/2009)
GSquared (1/29/2009)
You'll fit right in. Just don't upset "The Thread".
[font="Verdana"]I'm too scared to even ask! Let me guess though... some sort of über-discussion that...
January 29, 2009 at 2:27 pm
Sounds like you're on the right track on that one.
January 29, 2009 at 2:20 pm
In that case, there's something up with the index and/or the execution plan. Have you tried running the query with a recompile?
January 29, 2009 at 2:18 pm
Bruce W Cassidy (1/29/2009)
Alvin Ramard (1/29/2009)
January 29, 2009 at 2:16 pm
Ouch! Yeah, that piece of code might work, but it hurts to look at!
;with Numbers (Number) as
(select row_number() over (order by object_id)
from sys.all_objects)
select dateadd(month, number, @StartDate)
from Numbers
where number <=...
January 29, 2009 at 2:14 pm
The key part of Jeff's question was "without resorting to a forum". Some of the questions the guy asked, like users connecting to the secondary server in a log-shipping...
January 29, 2009 at 1:46 pm
The best way to do that is to build a calendar table.
The second best way is to use a numbers table.
After that, it's a numbers CTE.
After that, recursion.
Are you in...
January 29, 2009 at 1:33 pm
Or it could be that the CTE is doing heavy lifting because the load is a big one.
There's nothing wrong with a piece of a query having more than its...
January 29, 2009 at 1:28 pm
Why not use IsNull for that?
sum(isnull(soi.ItemValue, 0))
January 29, 2009 at 1:23 pm
Well, they're very useful for certain things, and not very good at certain other things.
They are good at resolving recursive hierarchy data.
They are good at taking the place of derived...
January 29, 2009 at 1:21 pm
I've been a DBA for 8 years (will be 9 years in March), and my best cert is ... I don't have any. So, I really don't see them...
January 29, 2009 at 12:19 pm
Lynn! Your favorite is back!
http://www.sqlservercentral.com/Forums/Topic646268-19-1.aspx?Update=1
January 29, 2009 at 12:14 pm
In the DTS package, there is an option to turn on logging. Use that.
January 29, 2009 at 12:13 pm
Viewing 15 posts - 11,206 through 11,220 (of 14,953 total)