Viewing 15 posts - 196 through 210 (of 279 total)
a colleague used to have a personal account with these guys that he was pleased with (they offer a corporate/workgroup account according to the FAQs under "How it works")
June 9, 2009 at 8:21 am
Grant Fritchey (4/21/2009)
The one thing no one seems to have mentioned is the selectivity of the data. J
"selectivity" - that's the word, it's been driving me crazy all day trying...
April 21, 2009 at 8:30 am
If it's only selects, and you have the space for more indexes, I'd certainly consider adding them.
Of course, as with all these things: testing, testing, testing 🙂
Edit: and of course...
April 21, 2009 at 4:25 am
If you have a lot of inserts/updates/deletes happening, then you could take a hit as each index would have to be updated when these happen.
Also you would have increased filesize...
April 21, 2009 at 4:08 am
That looks very handy - thanks!
April 8, 2009 at 12:39 am
I grew up in Greece and, back when I was a student, the mere mention that I was studying Mathematics would elicit "Oh, so you'll want to become a teacher...
April 7, 2009 at 11:55 pm
Thanks very much Adi, very useful!
April 2, 2009 at 8:48 am
Clifton Collins (4/1/2009)
April 2, 2009 at 5:58 am
It can take a while to run, and as far as I've noticed, you can't run contains() queries while it's populating (ie, they return no data)
I think if you right...
March 31, 2009 at 8:31 am
Update:
I have now found this:
http://www.sqlservercentral.com/scripts/Administration/62801/
sp_depends will fail to display correct information if there have been changes in views / tables /stored procs (dropping / recreating etc).
Seems a bit of a...
March 31, 2009 at 5:55 am
I don't spend too much time at work on the SN sites, although they have made me late for work on occasion! We work flexible hours here, so it's not...
March 30, 2009 at 11:10 am
Jeffrey Williams (3/27/2009)
March 30, 2009 at 4:20 am
Thanks very much Jeffrey
Jeffrey Williams (3/27/2009)
1) Disable all NC indexes
a) Leave clustered...
March 27, 2009 at 10:03 am
Grant Fritchey (3/27/2009)
Ordering the data helps.
If you're using GUID's, make sure you use sequential guids and...
March 27, 2009 at 6:22 am
Viewing 15 posts - 196 through 210 (of 279 total)