Viewing 15 posts - 8,926 through 8,940 (of 49,571 total)
Jeff Moden (5/25/2014)
Eirikur Eiriksson (5/24/2014)
May 25, 2014 at 7:04 am
DO NOT create everything DTA suggests. Test the recommendations one by one, consider implementing any that help, ignore the rest.
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...
May 24, 2014 at 12:14 pm
Doctor Who 2 (5/24/2014)
SQLRNNR (5/21/2014)
Aeterna (5/19/2014)
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...
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...
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...
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...
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...
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,...
May 24, 2014 at 10:45 am
If you run RESTORE HEADERONLY on the backup file, what is the result?
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...
May 23, 2014 at 8:26 am
In that case, did you or someone else enable compression on the backups?
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?
May 23, 2014 at 5:08 am
Viewing 15 posts - 8,926 through 8,940 (of 49,571 total)