Viewing 15 posts - 12,091 through 12,105 (of 22,214 total)
If you notice, that's a link. If you click it, it should give you more information.
August 11, 2011 at 5:17 am
Stuart Davies (8/11/2011)
Brandie Tarvin (8/10/2011)
This one is giving me heartburn. I almost ran something in Production that was...
August 11, 2011 at 5:12 am
Matt Miller (#4) (8/10/2011)
Grant Fritchey (8/10/2011)
August 10, 2011 at 1:26 pm
Ninja's_RGR'us (8/10/2011)
Grant Fritchey (8/10/2011)
August 10, 2011 at 8:30 am
I agree. The DTA is a very dangerous tool and it's suggestions can be problematic, in the extreme. After reading Gail's articles, get a copy of my book. It'll take...
August 10, 2011 at 8:22 am
sal-295209 (8/10/2011)
can anyone give me some guidelines (tips and tricks) on fine tuning sql server 2008 r2 database ? my email is sali2610@hotmail.comThank You
Take a look at my signature line....
August 10, 2011 at 8:20 am
No real way around this. The whole idea of hints to take away control from the optimizer. One of the many reasons I'm not in favor of using hints.
August 10, 2011 at 8:08 am
That's a huge topic. I'd like to suggest you take a look at a book, SQL Server Team-Based Development. It's free (unless you want to get a printed copy). I...
August 10, 2011 at 8:07 am
With only scripts, there's little you can do in terms of monitoring. Monitoring, as a concept, implies gathering data continually in order to respond to the information gathered or to...
August 10, 2011 at 7:18 am
In general it's either the query, the statistics or the indexes. Take a look at the predicate values in the properties of the scan. It'll tell you what it's searching...
August 10, 2011 at 7:13 am
SQL Server is going to take all the memory you give it. 2gb out of 16gb is probably just fine, but if you feel it's not, or there seem to...
August 10, 2011 at 7:11 am
maruthipuligandla (8/9/2011)
Thanks for the reply..
Can you please let me know how to overcome this, i want to know from your practises because you are SQL DBA..
Also you suggested me to...
August 10, 2011 at 6:31 am
narasimhareddy.dba (8/9/2011)
There are no job in old server but we are getting the alerts from dbmail or sqlmail. please assist on this.
We're trying, but we're not there, so we can't...
August 10, 2011 at 6:22 am
You can't overcome all the disadvantages. The primary problem is not using this datatype as the primary key. The primary problem is using this data type as the clustered index....
August 9, 2011 at 6:10 am
Lowell (8/9/2011)
Subjective Adapts covered the DBCC commands pretty well.
I dunno, would you say that...
August 9, 2011 at 6:06 am
Viewing 15 posts - 12,091 through 12,105 (of 22,214 total)