Viewing 15 posts - 34,231 through 34,245 (of 49,552 total)
Jack Corbett (2/3/2010)
lmu92 (2/3/2010)
Totally Off-topic:Did you notice? Jack is "SSCrazy Eights" now.
Congrats from across the ocean!
Thanks for noticing. I was actually hoping to hit it in 2009, but I...
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
February 4, 2010 at 2:11 am
Indeed.
Usually I'd suggest the following indexes for something like this.
Name, Deleted
<another searched field>, Deleted
..
Deleted
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
February 4, 2010 at 2:10 am
rotkehlchen105-kak (2/3/2010)
Another comment/question to obi wan:
Obi-wan? If you're referring to me, the avatar is Qui-gon Jinn.
What if read committed snapshots are enabled across the board?
No difference as...
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
February 4, 2010 at 2:03 am
Prakash Heda (2/3/2010)
though there are scenerio where many columns are in select clause, making covering index too big or crossing character limit...
There's no character limit to included columns in SQL...
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
February 4, 2010 at 1:59 am
Digs (2/3/2010)
But I do filter on DeletedLIKE
SELECT NAME FROM <tbl>
WHERE Deleted = 0
That's fine. There's an index with a leading column of 'deleted', so any query that filters on...
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
February 3, 2010 at 2:46 pm
njdouglas (2/3/2010)
Do MS ever audit in the UK? Been in this game a while now and never know them to go a knocking....
My company got audited last year, and...
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
February 3, 2010 at 2:41 pm
EdA ROC (2/3/2010)
We haven't been on the same page for a while. I was using this table as a simple example and you've been looking at it too literally.
I've been...
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
February 3, 2010 at 2:38 pm
Elliott W (2/3/2010)
I have looked over the docs and I don't think I agree with that interpretation. It is my feeling that SQL Express was meant to not require...
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
February 3, 2010 at 2:20 pm
You can, but it's a waste of space, may degrade insert/update/delete performance, increases the time of maintenance jobs. really not a good idea.
The index that you have just on deleted...
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
February 3, 2010 at 2:17 pm
"I am working in a project nearing to its deadline. I am not having enough time/patience to read books now."
http://www.sqlservercentral.com/Forums/Topic856967-1291-1.aspx
Seriously, where are all the idi^H^H^H novice-type people coming 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
February 3, 2010 at 1:12 pm
sprabhakaran.karuppaih (2/3/2010)
Since, I am working in a project nearing to its deadline. I am not having enough time/patience to read books now.
That project will take you far longer...
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
February 3, 2010 at 1:07 pm
Digs (2/3/2010)
SCANS are better than SEEKS
You might want to read again.
A scan is like taking the telephone directory and reading every single page to find the phone number for Mr...
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
February 3, 2010 at 1:03 pm
Digs (2/3/2010)
Or should the composite be like this (Deleted,Name)- Ref example above, as deleted field is very important.
Yup, think that's the better approach.
Index Scan
Index Seek
Whats the...
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
February 3, 2010 at 12:58 pm
EdA ROC (2/3/2010)
I'm not sure what you mean by "which is more selective on its own?"
I answered that in my last post
Most of the time I will execute the following...
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
February 3, 2010 at 12:55 pm
I'm curious. How did you determine that they were PFS pages, not GAM/SGAM? Something about the page ID or is it the size of the range of pages that can't...
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
February 3, 2010 at 11:55 am
Viewing 15 posts - 34,231 through 34,245 (of 49,552 total)