Viewing 15 posts - 3,721 through 3,735 (of 49,571 total)
kudz (1/29/2016)
January 30, 2016 at 1:51 am
ffarouqi (1/29/2016)
In case if you do not mind me asking is there anything what we can do for these queries. Anything that can make this better.
Exactly the same problem (the...
January 30, 2016 at 1:42 am
You can, you're missing an END.
CASE WHEN ISNULL(oa.IsRetail,odr. IsRetail) = 1 THEN
...
January 29, 2016 at 12:49 pm
kudz (1/29/2016)
How do you guys would resolve this situation?
Probably by using one of the row-versioning isolation levels, especially if I don't have code to work through.
Do I have any...
January 29, 2016 at 12:40 pm
Since I wrote that article, it's already in my words.
Skim the first section and read the second section. You can skip the rest of it for now. The second...
January 29, 2016 at 11:43 am
I guess you missed the link.
GilaMonster (1/29/2016)
See - https://www.simple-talk.com/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/
January 29, 2016 at 11:16 am
Eirikur Eiriksson (1/29/2016)
Jeff Moden (1/29/2016)
GilaMonster (1/29/2016)
Jeff Moden (1/28/2016)
Rich Mechaber (1/5/2016)
January 29, 2016 at 10:27 am
Can you limit the table definitions to just the tables relevant to the query please, and include the index definitions.
Problem 1:
AND (@PickListGuid is NULL or PList.PickListGuid=@PickListGuid)
AND (@ProjectGuid is NULL or...
January 29, 2016 at 10:26 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
A year ago I was...
January 29, 2016 at 10:22 am
William Rayer (1/29/2016)
January 29, 2016 at 10:04 am
It is. SQL 2012 doesn't support compat more 80, so the restored database could not have been left in compat mode 80.
January 29, 2016 at 3:24 am
Jeff Moden (1/28/2016)
Rich Mechaber (1/5/2016)
January 29, 2016 at 2:39 am
"(table2.[type]<2 and table2.[type]>2)"
That will match precisely 0 rows, as type cannot be both less than 2 and greater than 2 at the same time. It's not equivalent to (table2.type !=...
January 29, 2016 at 2:27 am
Could be a bunch of things
The one that comes to mind looking at it is that the table isn't schema-qualified, hence SQL could think that different users = different objects...
January 29, 2016 at 2:16 am
Jeff Moden (1/28/2016)
Markus (1/28/2016)
That is the first release of SQL 2012.Look again. It's the RTM of 2014.
We don't know what it is because the OP hasn't posted the build...
January 29, 2016 at 2:09 am
Viewing 15 posts - 3,721 through 3,735 (of 49,571 total)