Viewing 15 posts - 5,191 through 5,205 (of 5,685 total)
Think this would be a bit much as my signature?
CREATE TRIGGER trg_Celko ON vw_SSC_PostList FOR AFTER INSERT
AS
-- Go read the documents, inline comments are for sissies.
IF EXISTS (SELECT * FROM...
October 28, 2010 at 5:39 pm
You're looking at the difference of pre-allocated pages being re-used, if my understanding is accurate. Less prepwork for the engine.
SQL Server doesn't let you do pre-allocates inside the allocated...
October 28, 2010 at 5:31 pm
CELKO (10/28/2010)
Look up the COALESCE() function. Do not use the old Sybase museum ISNULL(). They are not quite the same and you can get screwed.
The museum piece is faster.
http://jerrytech.blogspot.com/2006/05/sql-2k-performance-isnull-vs-coalesce.html
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/performance-isnull-vs-coalesce.aspx
Is it...
October 28, 2010 at 5:20 pm
WayneS (10/28/2010)
Craig - I see you came through on your threat of a ST avatar! Seems appropriate, especially in the thread with Joes latest rant.
Sadly appropriate. Why is it...
October 28, 2010 at 4:06 pm
preensheen (10/27/2010)
John Rowan (10/26/2010)
Data Flow source adapters do allow for SP execution. Does attempting this give you an error?
Yes, i am trying to pass parameter and and everything correctly...
October 28, 2010 at 3:38 pm
mbender (10/28/2010)
I've just started using them as work tables, and have really enjoyed it. Normally we would do all the work in the...
October 28, 2010 at 3:32 pm
You can use a subquery the same way you can the inline TVF. Well, mostly. At a guess we just need to thin your code down a bit.
Are...
October 28, 2010 at 3:30 pm
Yep, not sure of the question here, though.
That's a NOT IN statement you're using, so it's checking to see if the id exists. When it exists, it's not included.
So,...
October 28, 2010 at 3:26 pm
you might be able to do it via profiler, but two commands in another query window while your first one calls the proc will be much easier, to the point...
October 28, 2010 at 3:24 pm
Sorry for that mbender. Joe Celko's the highly trained tourettes guy you usually leave locked in a back office at work and feed steaks and requirement documents in through...
October 28, 2010 at 3:21 pm
Hm, with all the Star Wars avatars around here I'm going to have to dig up a few Star Trek ones.
I believe the Picard Facepalm will be the first I...
October 28, 2010 at 1:39 pm
Is it good practice to use temp tables in a view...
Quick Answer: You can't. Views are single statement activities.
You can use cte's to help keep code readable. You...
October 28, 2010 at 1:33 pm
At a guess, it's probably waiting for a lock. Check while you run the process (exec proc) from a query window and then monitor that spid in sysprocesses. ...
October 28, 2010 at 1:31 pm
Stefan Krzywicki (10/28/2010)
Brandie Tarvin (10/28/2010)
Non-sequitur.Someone put eyeballs in my candy dish.
Honestly, I'd say that's much preferable to someone putting candy in your eyeball dish (sockets).
BAH! I always enjoy a...
October 28, 2010 at 11:43 am
Viewing 15 posts - 5,191 through 5,205 (of 5,685 total)