Viewing 15 posts - 5,806 through 5,820 (of 49,571 total)
meilenb (5/23/2015)
Also, if you are debating join performance of a string vs. an int, maybe your just having the wrong conversation altogether.
Why?
Is there no value in knowing that...
May 23, 2015 at 11:42 am
xsevensinzx (5/22/2015)
May 23, 2015 at 3:32 am
SQL-DBA-01 (5/22/2015)
Problem is , if someone likes to password (for e.g.2peUj2Rj'jjS7'h) which has multiple single quotes, then only.....
Then use REPLACE.
May 22, 2015 at 2:27 pm
The obsfucation has lost data.
You said NCI2 is used, but the key column (Col4) is not filtered on in the query and hence SQL can't seek on it. However...
May 22, 2015 at 2:23 pm
Eirikur Eiriksson (5/22/2015)
May 22, 2015 at 12:49 pm
Can you post the table definition and CREATE INDEX for all three indexes please? I may only get around to looking at this in detail tomorrow.
May 22, 2015 at 12:32 pm
sql-lover (5/22/2015)
And I discovered that the existing Index needs two more columns to make it cover.
And you added two columns to the existing index? Or created a new one...
May 22, 2015 at 12:11 pm
sql-lover (5/22/2015)
But it's NOT optimal for my environment.
Well then no, the optimiser won't chose it. It's going to look for the most efficient index, if you're creating an index that's...
May 22, 2015 at 10:44 am
If SQL's not picking your index, it doesn't think that it's optimal. Can't say much more without seeing the execution plan.
May 22, 2015 at 10:31 am
Alvin Ramard (5/22/2015)
Gazareth (5/22/2015)
Jack Corbett (5/22/2015)
We do have white noise generatorsHuh?
Do we have them in any other colors? 😎
You laugh, but...
May 22, 2015 at 9:34 am
Woot, my latest editorial's published in this week's Database weekly!
May 22, 2015 at 9:27 am
BL0B_EATER (5/22/2015)
If that isn't enough I then feel really violated when everyone else's paperwork, notes, pens, pencils and burger king wrappers end up on my table.
I remember coming back from...
May 22, 2015 at 9:23 am
Reorganise does not update stats, you'll have to do it if you want them updated
May 22, 2015 at 8:05 am
Grant Fritchey (5/22/2015)
Maybe it would grow on me over time, but in short bursts it's painful.
It usually gets more painful over time, not less.
May 22, 2015 at 7:28 am
Viewing 15 posts - 5,806 through 5,820 (of 49,571 total)