Viewing 15 posts - 6,931 through 6,945 (of 9,715 total)
It sounds like either a network issue or a permissions issue. If you're not willing to look at Craig's questions and test them out for yourself to verify none of...
December 2, 2010 at 5:58 am
Certifiable.
Yeah. Couldn't resist that one. @=)
December 1, 2010 at 12:44 pm
JRUDE (12/1/2010)
My apologies. I had not read through all of the responses prior to posting my reply. Your explanation was very clear. Thank you for being kind.
No...
December 1, 2010 at 12:33 pm
Stefan Krzywicki (12/1/2010)
The LIKE '%[0-9]%' will return any string that has any number in it anywhere.
The NOT LIKE '%[^0-9]%' will return any string that has only numbers in it.
This is...
December 1, 2010 at 12:32 pm
JRUDE (12/1/2010)
Perhaps I'm missing something, but doesn't the following do the same thing in a more straightforward way (without the double negatives)?somecolumn like '%[0-9]%'
Go back and re-read the last two...
December 1, 2010 at 12:25 pm
We are feasting today upon Lemon Sponge Cake with Lemon frosting (as in lemon flavored frosting).
Scrumptious.
December 1, 2010 at 11:04 am
Maybe I'm off base here, but could the scan be caused by SQL Server pulling the data and then checking the permissions for each record to see if the user...
December 1, 2010 at 11:01 am
James Stephens (12/1/2010)
December 1, 2010 at 10:50 am
Maybe you have the plans misnamed, but "Without_repl_predicates" shows an Index scan (IndexScan Ordered="true") and the other plan shows the opposite??
Anyway, while I'm playing with this, try doing the first...
December 1, 2010 at 8:53 am
Greg Edwards-268690 (12/1/2010)
Brandie Tarvin (12/1/2010)
Greg Edwards-268690 (12/1/2010)
For the data warehouse - are you implying slowly changing dimensions?Although the 3 tables wouldn't seem necessary.
There are no really good standards for a...
December 1, 2010 at 8:45 am
Gianluca Sartori (12/1/2010)
None of these predicates need to access the tables, so why a scan?
Because you've got them all lumped together??? To my eyes, the code should say:
...
December 1, 2010 at 8:28 am
Gianluca Sartori (12/1/2010)
AND ({fn ISPALUSER('23320088-BB3F-46AC-905D-0F2A95181934')} = 1
...
December 1, 2010 at 8:15 am
I don't see ISPALUSER in BOL. Can you script that function out for me?
December 1, 2010 at 8:13 am
GSquared (12/1/2010)
December 1, 2010 at 6:54 am
Viewing 15 posts - 6,931 through 6,945 (of 9,715 total)