Viewing 15 posts - 7,981 through 7,995 (of 49,552 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...
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
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...
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
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...
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
August 27, 2014 at 3:07 pm
Oh look, one of my pet peeves. Email validators
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
August 27, 2014 at 2:30 pm
You cannot block yourself.
What were the errors raised?
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
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%
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
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...
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
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
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
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.
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
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...
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
August 27, 2014 at 7:48 am
Are you sure you need partitioning?
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
August 27, 2014 at 7:19 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...
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
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.
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
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...
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
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?
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
August 27, 2014 at 1:05 am
Viewing 15 posts - 7,981 through 7,995 (of 49,552 total)