Viewing 15 posts - 7,981 through 7,995 (of 49,571 total)
sqlenforcer (8/27/2014)
If there is fragmentation in some of the indexes being used in a multi-table join query, would that cause TEMPDB to grow?
No. Fragmentation has to do with...
August 28, 2014 at 2:34 am
brad.mason5 (8/27/2014)
I always thought .(dot) was important in my email but I guess it has no meaning.
Depends on the mail provider. My work email starts gail.shaw@ ... and if you...
August 28, 2014 at 12:56 am
ramana3327 (8/27/2014)
Mainly we need this for archiving purpose.
Again, why?
You can't partition across databases, so the 'old stuff into the archive database' can't be done with partitioning. Fast switching works when...
August 27, 2014 at 3:07 pm
Oh look, one of my pet peeves. Email validators
August 27, 2014 at 2:30 pm
You cannot block yourself.
What were the errors raised?
August 27, 2014 at 2:28 pm
Rather ignore that counter. It's useless. Even on a server that's under severe memory pressure it'll be sitting near 100%
August 27, 2014 at 2:27 pm
sqldriver (8/27/2014)
GilaMonster (8/27/2014)
sqldriver (8/27/2014)
I used to use this. Not perfect by any stretch but got most of the junk out.Does it flag this as invalid?
http://gmailblog.blogspot.com/2008/03/2-hidden-ways-to-get-more-from-your.html
It does.
Which is why I...
August 27, 2014 at 2:24 pm
sqldriver (8/27/2014)
I used to use this. Not perfect by any stretch but got most of the junk out.
Does it flag this as invalid?
http://gmailblog.blogspot.com/2008/03/2-hidden-ways-to-get-more-from-your.html
August 27, 2014 at 1:54 pm
I'd give you mine, but it wouldn't be of the slightest use because of where I live.
Salary depends as much on where you are in the world as experience.
August 27, 2014 at 10:40 am
Depends how accurate you want it.
Want a complete, perfect validation? Use DB_Mail to send an email and have the app ask for the sent code, or validate a clicked on...
August 27, 2014 at 7:48 am
For emphasis, since the people recommending nolock aren't mentioning the side effects
And please do some reading on the side effects of nolock before you consider using it anywhere.
It is not...
August 27, 2014 at 4:26 am
Interesting....
Let's hope that works. I would suggest a long, hard look at that IO subsystem as well. Sooner rather than later.
August 27, 2014 at 2:17 am
Eirikur Eiriksson (8/27/2014)
GilaMonster (8/27/2014)
Eirikur Eiriksson (8/26/2014)
Here is an alternative solution using CHARINDEXHow well does that work if you add 'grape' to the search list?
Good point, that will ferment into a...
August 27, 2014 at 2:12 am
Eirikur Eiriksson (8/26/2014)
Here is an alternative solution using CHARINDEX
How well does that work if you add 'grape' to the search list?
August 27, 2014 at 1:05 am
Viewing 15 posts - 7,981 through 7,995 (of 49,571 total)