Viewing 15 posts - 3,571 through 3,585 (of 5,843 total)
Jaimie, please don't post to threads that were started 2.5 years ago . . . 🙂
March 1, 2011 at 7:32 am
1) sp_whoisactive
2) search web for glenn berry sql server DMV. here is one for 2008, he has another for 2005. lots of goodness here: http://sqlserverperformance.wordpress.com/2009/05/21/sql-server-2008-diagnostic-script/
March 1, 2011 at 7:29 am
sqldba_icon (2/27/2011)
Thanks Jeff. I am very positive memory is not an issue, how can i measure if AUTO stats is causing an issue?
1) set up a to-disk (to avoid GUI...
March 1, 2011 at 7:27 am
Craig Farrell (2/25/2011)
TheSQLGuru (2/25/2011)
And what is your preference when you notice that an index gets fragmented from 0% to say 90% after 24hrs? Do you reorganize it on a daily...
February 25, 2011 at 11:26 am
And what is your preference when you notice that an index gets fragmented from 0% to say 90% after 24hrs? Do you reorganize it on a daily basis or set...
February 25, 2011 at 8:54 am
grahamc (2/25/2011)
If you are doing DML statements, it is normally quite handing to have a PRIMARY KEY declared on the TEMP(#) table
I disagree with this. I cannot count the...
February 25, 2011 at 8:49 am
For a small number of rows you won't see any signifiacnt performance diference,
That is absolutely not true in all cases. Take a table where 50% of the rows...
February 25, 2011 at 8:47 am
SKYBVI (2/24/2011)
10gb is fine for a 340 gb prod db, i know that.
But my manager doesn't like that.
I told her many reasons for...
February 24, 2011 at 6:53 am
Synonym is what you want. I will note that your usage of cross-server data access brings with it HORRIBLE performance consequences.
February 24, 2011 at 5:22 am
Any web search will turn up umpteen blogs, forum posts, articles, etc about FULL RECOVERY mode and having to do some form of transaction log backup to keep the tlog...
February 24, 2011 at 5:20 am
I HIGHLY recommend you leave it at 10GB. That is pretty small given a 340GB production database, and also small in comparison to disk sizes these days. Do...
February 24, 2011 at 5:19 am
if you think that query should do an index seek and bookmark lookup to return your results, then do this:
SET STATISTICS IO ON
GO
select ... from mytable with (index=yourNCindexnamehere) where ...
show...
February 23, 2011 at 12:53 pm
Grant Fritchey (2/21/2011)
. . . many of the ORM tools that are out there are so problematic.
Understatement of the week at least, perhaps the month! 😀
ORMs are BAD BAD...
February 23, 2011 at 12:50 pm
There are at least a dozen things that can be done suboptimally or just plain wrong when you have SQL Server files on SAN storage. If you are talking...
February 23, 2011 at 12:46 pm
You hit my question Jeff: what if the rule is "delete characters 1-n where n is the position of the first underscore"? i.e.
AB_mmmmm_somestuff = mmmmm
EEE_yyyyy_somestuff = yyyyy
_ppppp_somestuff =...
February 22, 2011 at 6:47 am
Viewing 15 posts - 3,571 through 3,585 (of 5,843 total)