Viewing 15 posts - 3,241 through 3,255 (of 5,841 total)
I would say to stop using maintenance plans altogether. Get the awesome free mx package from ola.hallengren.com
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 15, 2011 at 8:27 am
similar to that
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 10:50 am
I have collected a huge array of tools, scripts, etc. in my 15 years with SQL Server. I REALLY need to do a "tools I use" session for SQL...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 9:29 am
properly designed code is the way to avoid procedure cache bloat. ORMs are HORRIBLE about this, as are poorly coded middle tier constructs (even ADO.NET).
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:50 am
Perry Whittle (7/12/2011)
RAID10 can offer fast reads depending upon the controller used. Modern RAID10 arrays will read from all online disks to improve performance
Good point Perry, and one which most...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:47 am
LutzM (7/13/2011)
Frankie-464050 (7/12/2011)
Thanks for the link. Any way to get around this via hints or ?Yes. Read the article Gail pointed you at. 😉
Use the hard-coded value! ...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:45 am
1) definitely beware DTA
2) dbsophic has a tool that is much better. they have a freebie trace analyzer too.
3) The BEST way to accomplish what you want is to...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:44 am
get rid of unnecessary data. index btree depth could be reduced 1 or even 2 levels, saving 8-16KB page IO for EVERY INDEX SEEK. Believe you me that...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:42 am
MickyD (7/12/2011)
Can someone confirm if I have this correct ?
I want to allocate a specific amount of available memory to 1 SQL instance.
SQL 2005 64 bit
6 instances on the...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:38 am
get the free tool SQLJOBVIS.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 13, 2011 at 8:36 am
Actually I much prefer FtF for the first stage of any significant engagement too. But for "hey, this one thing is broken and I need help on it now"...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 12, 2011 at 8:05 am
Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 12, 2011 at 6:48 am
rfr.ferrari (7/11/2011)
after all comments/posted in this discussion, i have a question to pei zhu and kevin with relation the proposed scene, what i said in begin of discussion, is...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 12, 2011 at 6:47 am
Ninja's_RGR'us (7/11/2011)
sdelachapelle (7/11/2011)
Hi, thanks for the proposal but I work in Paris 😉Close enough! :w00t:
I'm 10 minutes away from the airport in case of emergency!
HAH - I am 0 minutes...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 12, 2011 at 6:42 am
Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 12, 2011 at 6:37 am
Viewing 15 posts - 3,241 through 3,255 (of 5,841 total)