Viewing 15 posts - 36,841 through 36,855 (of 49,563 total)
In SQL, only one table may follow the UPDATE keyword.
Take a look at Books Online for the UPDATE .. FROM syntax. Access doesn't have that form of the update statement.
August 25, 2009 at 8:01 am
villersk (8/25/2009)
I've seen the query optimiser make some seriously bad decisions....I don't think this one is soo bad.
It can, in most cases that's due to badly written queries or...
August 25, 2009 at 7:43 am
http://msdn.microsoft.com/en-us/library/ms188929.aspx
BEGIN TRANSACTION
Arguments
transaction_name
Is the name assigned to the transaction. transaction_name must conform to the rules for identifiers, but identifiers longer than 32 characters are not allowed. Use...
August 25, 2009 at 7:37 am
What I was talking about above is a loop join. 100000 seeks against the dimension table, then all those lookups to the cluster to get the row.
Generally hints are not...
August 25, 2009 at 7:26 am
Try removing the quotes from around UserName, both in the order by and the select statement.
August 25, 2009 at 7:05 am
August 25, 2009 at 7:04 am
villersk (8/25/2009)
What I was driving at, though, is that the merge syntax doesn't seem to allow index hints on the target table.
Did you try using the OPTION clause?
perhaps the scan...
August 25, 2009 at 7:00 am
Why do you think the seek will be more efficient? If SQL does a seek on the NC index, it will have to do one seek for each matching value...
August 25, 2009 at 6:44 am
kumar99ms (8/25/2009)
Is it possible to delete T-log file what happed ?
Sure it's possible, just not while the DB is in use. Doing so is asking for a damaged and...
August 25, 2009 at 6:39 am
Dave Ballantyne (8/25/2009)
Hope there should of been a question mark after that Gail 🙂
Perhaps, as I cannot state for certain, but that's what it looks like. At attempt to obscure...
August 25, 2009 at 6:31 am
Paul Randal (8/25/2009)
@Gail Yup - especially in Enterprise Edition. And yes, anything with write-access to SQL memory can cause this.
Interesting... What, other than in-process drivers and extended stored procs could...
August 25, 2009 at 6:19 am
When a query runs, needs to use statistics and those statistics are out of date. For what makes stats out of date, see Adi's post.
August 25, 2009 at 4:58 am
Dave Ballantyne (8/25/2009)
Go on then , im curious, how does it help security ?
Security by obscurity.
August 25, 2009 at 4:57 am
August 25, 2009 at 3:11 am
Viewing 15 posts - 36,841 through 36,855 (of 49,563 total)