Viewing 15 posts - 9,031 through 9,045 (of 15,381 total)
This sounds like a data driven subscription. http://msdn.microsoft.com/en-us/library/ms159762.aspx
March 19, 2013 at 9:00 am
Here is the other thread. http://www.sqlservercentral.com/Forums/Topic1432700-1633-1.aspx
March 19, 2013 at 8:55 am
Minnu (3/19/2013)
when i insert a record into particular table, cascading is happening,
i want to know the cascading details, i.e.. in backend some records are updating, inserting in to another...
March 19, 2013 at 8:53 am
Jeff we have seen this same loop in several threads in the last day or two. Chris posted a great solution on one of them that got rid of the...
March 19, 2013 at 8:05 am
Probably the easiest way to import this type of thing is with SSIS. Check out the stairways series here. http://www.sqlservercentral.com/stairway/72494/%5B/url%5D
March 19, 2013 at 7:39 am
Try this thread. http://www.sqlservercentral.com/Forums/Topic800068-146-1.aspx
Seems they walked through a number of issues with dbmail including the error you ran into.
March 18, 2013 at 9:12 pm
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1432424-149-1.aspx
March 18, 2013 at 9:09 pm
Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1432424-149-1.aspx
March 18, 2013 at 9:08 pm
Sergiy (3/18/2013)
That's how you code CSS, that's how CTE code is formed.
Why it's not in...
March 18, 2013 at 9:04 pm
Sergiy (3/18/2013)
Sean Lange (3/18/2013)
Yes I don't think there is a clear cut advantage for either approach as far as performance is concerned. I think it boils down to preference.
If you...
March 18, 2013 at 8:55 pm
Sergiy (3/18/2013)
Sean Lange (3/18/2013)
Of course a CTE can use tempdb. Just like a temp table, if the memory pressure is too much it will absolutely start writing data to tempdb.
Hmm...
I...
March 18, 2013 at 3:29 pm
michielbijnen (3/18/2013)
Thanks! That was the trick!Answers are very simple, sometimes!
Cursors are notoriously slow. There are times when they are the best choice but from what you have posted it does...
March 18, 2013 at 3:21 pm
Sergiy (3/18/2013)
Sean Lange (3/18/2013)
March 18, 2013 at 3:02 pm
Most developers used to wrire "CSS style" code.
CTE fits there patterns and allows not to learn SQL-specific best practices.
That's why it's so popular.
What does that mean? What is "CSS style"...
March 18, 2013 at 2:42 pm
Extra typing always makes anything more complex.
By definition.
Actually by definition that makes it more verbose. Verbosity is not the same thing as complex.
But if to ingnore our personal preferences -...
March 18, 2013 at 2:38 pm
Viewing 15 posts - 9,031 through 9,045 (of 15,381 total)