Viewing 15 posts - 5,806 through 5,820 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2015 at 11:42 am
xsevensinzx (5/22/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2015 at 2:23 pm
Eirikur Eiriksson (5/22/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
http://en.wikipedia.org/wiki/Colors_of_noise
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2015 at 9:34 am
Woot, my latest editorial's published in this week's Database weekly!
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2015 at 9:23 am
70-463 iirc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2015 at 8:15 am
Reorganise does not update stats, you'll have to do it if you want them updated
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 22, 2015 at 7:28 am
Viewing 15 posts - 5,806 through 5,820 (of 49,552 total)