Viewing 15 posts - 1,291 through 1,305 (of 18,926 total)
Dev (11/14/2011)
That's why the join was not throwing a syntax error
So you are saying it's runtime / logical error...
No his problem is that he didn't reference BOTH tables...
November 14, 2011 at 5:34 am
Lavanyasri (11/14/2011)
I ran the below query and attached the output file with this mail .
select * from sys.dm_os_wait_stats .
Can you please look into...
November 14, 2011 at 5:25 am
Please upload the actual execution plan.
Sorts have way more than 1 use in plans ;-).
November 14, 2011 at 5:23 am
Dev (11/14/2011)
You don't have the 2nd table in the FROM
In fact there is no FROM clause in OP's query... 😉
Update dbo.table is an implied from if you really...
November 14, 2011 at 5:21 am
You don't have the 2nd table in the FROM
UPDATE
A
SET
A.Address1Original = CAP.Address1Original
, A.Address2Original = CAP.Address2Original
, A.Address3Original = CAP.Address3Original
...
November 14, 2011 at 5:07 am
GilaMonster (11/14/2011)
This: http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
And make sure to read this excellent comment at the end!
http://www.sqlskills.com/BLOGS/KIMBERLY/post/The-Tipping-Point-Query-Answers.aspx
:hehe:
November 14, 2011 at 4:33 am
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find that script. ...
November 14, 2011 at 4:30 am
Sab must return less rows.
An index seek + bookmark lookup is a very costly operation. It takes very little data returned to make a table scan more...
November 14, 2011 at 4:21 am
L' Eomot Inversé (11/13/2011)
SQL Kiwi (11/13/2011)
I really liked this question. Not least because I didn't have to read past answer possibility #1 to get my two points 🙂
Well, I'm...
November 13, 2011 at 5:16 pm
GilaMonster (11/13/2011)
That was funny. p.s. I suspect that thread is a case of 'Please confirm that I'm right' rather than 'Please advise me on the best approach'
You're right and keep...
November 13, 2011 at 5:11 pm
Here you go. I've wrapped the whole thing into a begin / rollback transaction.
Once you've validated that this works ok for you, change the rollback at the end to...
November 13, 2011 at 5:06 pm
bitbucket-25253 (11/13/2011)
sherifffruitfly (11/13/2011)
Most idiotic editorial I've ever seen.I hope your comment was made as a joke, for it was not ....
That would be called self fulflling prophecy :hehe:
November 13, 2011 at 10:53 am
UPDATE Base SET Col = Src.Col...
FROM from "192.200.101.131".ses.dbo.chequehead Src
INNER JOIN dbo.LocalTable Base
ON Src.id = Base.Id
WHERE Src.dateoperation >= DATEADD(D, 0, DATEDIFF(D, 1, GETDATE())) --yesterday midnight
-- This is useless unless you...
November 13, 2011 at 8:43 am
yes that should be fine.
Tx.
November 13, 2011 at 8:38 am
Viewing 15 posts - 1,291 through 1,305 (of 18,926 total)