Viewing 15 posts - 8,926 through 8,940 (of 49,552 total)
Jeff Moden (5/25/2014)
Eirikur Eiriksson (5/24/2014)
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
May 25, 2014 at 7:04 am
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
May 24, 2014 at 4:58 pm
DO NOT create everything DTA suggests. Test the recommendations one by one, consider implementing any that help, ignore the rest.
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
May 24, 2014 at 2:50 pm
And the article on premature optimisation submitted. I may need to take leave the day it's published, so that I have time to reply to all the nasty comments that...
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
May 24, 2014 at 12:14 pm
Doctor Who 2 (5/24/2014)
SQLRNNR (5/21/2014)
Aeterna (5/19/2014)
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
May 24, 2014 at 12:04 pm
I usually change select into into a create table .... insert when tuning procedures, partially so I have the option of creating a clustered index, partially so I can keep...
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
May 24, 2014 at 11:56 am
To be honest, 10 million rows isn't particularly large. That's about what I put into tables when I'm doing query testing to get a good, but not huge, load.
Write your...
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
May 24, 2014 at 11:29 am
Steve Jones - SSC Editor (5/23/2014)
GilaMonster (5/23/2014)
http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage 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
May 24, 2014 at 11:24 am
Eirikur Eiriksson (5/23/2014)
Start by getting something working, test it against the requirements and improve if needed. This way, you can hopefully avoid another pitfall which is premature optimization.
Doing 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
May 24, 2014 at 11:22 am
Eugene Elutin (5/23/2014)
... SQL Server doesn't really support code reuse in a useful way...
I would say that it's very arguable statement...
😉
I'd take Grant's side in any such argument.
In general, it's...
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
May 24, 2014 at 10:47 am
1) Don't use task manager/resource monitor to check SQL's memory
2) The max server memory sets the buffer pool. SQL additionally uses a small amount of non-buffer memory for thread stacks,...
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
May 24, 2014 at 10:45 am
If you run RESTORE HEADERONLY on the backup file, what is the result?
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
May 23, 2014 at 8:30 am
SQLRNNR (5/23/2014)
GilaMonster (5/23/2014)
http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that...
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
May 23, 2014 at 8:26 am
In that case, did you or someone else enable compression on the backups?
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
May 23, 2014 at 7:11 am
The SQL parser/algebriser removes unnecessary tables from queries (unnecessary being ones which don't filter and don't return columns)
Are you sure that's what's causing the performance problems?
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
May 23, 2014 at 5:08 am
Viewing 15 posts - 8,926 through 8,940 (of 49,552 total)