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...
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
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...
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...
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...
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...
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...
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...
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...
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?
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...
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...
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...
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...
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...
February 3, 2010 at 11:55 am
Viewing 15 posts - 34,231 through 34,245 (of 49,552 total)