Viewing 15 posts - 5,836 through 5,850 (of 8,416 total)
CirquedeSQLeil (2/26/2010)
Sad when they just won't relent - just keep pushing it. Not good.
I posted it there, and I'm posting it here:
http://meta.wikimedia.org/wiki/Don't_be_a_dick
Mr Corgi needs less of whatever he's been...
February 26, 2010 at 11:38 pm
Complete guide to posting on the forums: http://meta.wikimedia.org/wiki/Don't_be_a_dick
:laugh:
Let's move on.
February 26, 2010 at 11:35 pm
Appropriate indexes make all the difference, as does posting code that actually runs.
(You forgot the SET IDENTITY_INSERT statements, and the COLLATE clauses for the second table are missing))
-- Indexes required
CREATE...
February 26, 2010 at 11:29 pm
DanielP (2/26/2010)
If a table is getting inserted into via a stored procedure that inserts data using OPENXML, does the Table's Insert Trigger still fire or is it treated like bulk-insert?
Yes.
February 26, 2010 at 11:10 pm
A guess:
DECLARE @Employee
TABLE (
row_id INTEGER IDENTITY PRIMARY KEY,
...
February 26, 2010 at 11:09 pm
CirquedeSQLeil (2/26/2010)
Jeff Moden (2/26/2010)
I guess I'd get into trouble if I recommended that someone started Lithium treatment, huh?http://www.sqlservercentral.com/Forums/Topic873721-145-1.aspx
Probably, but didn't you just make that recommendation 😀
And you just quoted it...
February 26, 2010 at 10:58 pm
Jeff Moden (2/26/2010)
Me too! I guess I've cut way too far back on the coffee and pork chops.Cool code, Paul. Thanks.
Not quite so cool - it doesn't...
February 26, 2010 at 10:55 pm
Jeff Moden (2/26/2010)
Heh... poor ol' dynamic SQL... nobody loves it anymore.
Well maybe 'love' is too strong a word, but I do use it, hopefully appropriately.
Erland Sommarskog has a great guide...
February 26, 2010 at 10:52 pm
lmu92 (2/26/2010)
A recursive cte will cause performance issues on larger data sets.A common way to resolve this issue is the usage of FOR XML PATH...
Just to refine that a little,...
February 26, 2010 at 10:31 pm
Jeff Moden (2/26/2010)
Hmmmm.... not sure IIRC but I believe you can get most of what you need by looking up the ID for the procedure from sys.columns.
Not as far as...
February 26, 2010 at 10:16 pm
Abhijit More (2/24/2010)
February 26, 2010 at 9:59 pm
PL/SQL is Oracle.
SQL Server's batch language is T-SQL.
😛
February 26, 2010 at 9:54 pm
Ramesh Saive (2/26/2010)
February 26, 2010 at 9:51 pm
Hey Jeff,
Scalar T-SQL functions?! WHILE loops? I am genuinely shocked! :w00t:
The REPLACE solution can be made to run an order of magnitude faster if we use an in-line...
February 26, 2010 at 9:40 pm
Viewing 15 posts - 5,836 through 5,850 (of 8,416 total)