Viewing 15 posts - 12,331 through 12,345 (of 22,214 total)
Yeah, Dan has it right. If you filter on columns from the OUTER table in the WHERE clause you will get an INNER JOIN. The trick is to move those...
June 13, 2011 at 12:31 pm
It was running for years with no issues at my previous employer.
June 13, 2011 at 9:30 am
In addition to videos which can be incomplete, I'd suggest getting a copy of Kalen Delaney's book "SQL Server 2008 Internals." It's a must own.
June 13, 2011 at 9:28 am
If you really have lots of fields not used by other processes and a table as wide as that, I think you'd be better off looking at some form of...
June 13, 2011 at 9:28 am
Since that's an estimated plan not an actual plan it's hard to know for sure, but it looks like the table has a cardinality estimate of about 1 million...
June 13, 2011 at 9:21 am
I'm curious what performance issues you've seen with Red Gate SQL Monitor?
I work for the company and we're constantly trying to improve the product. If you have some specific...
June 13, 2011 at 8:29 am
How do you mean? Do you want alerts when there are errors? You can configure this using Alerts in SQL Agent.
June 13, 2011 at 8:27 am
No, something else must be occurring. I'm with the Ninja, I'd need to plan to understand.
Just a guess, you added the index and then reran the query? Unless you...
June 13, 2011 at 8:25 am
Why are you trying to drop one of the system procs? I'd leave that alone.
June 13, 2011 at 5:30 am
GilaMonster (6/13/2011)
Anyone noticed that we now have pretty pictures as well as alphabet soup? http://www.sqlservercentral.com/Forums/Topic1123813-359-1.aspx
The soup has been strained though. Improvements.
June 13, 2011 at 4:53 am
John Mitchell-245523 (6/13/2011)
June 13, 2011 at 3:58 am
If all you're looking for is a count of statements, I'd go with just pulling the data out of performance monitor then. It's standard set of data. As long as...
June 13, 2011 at 3:43 am
I can't tell you what backward recovery is, never heard of that one.
Rollback or rollforward is referring to transactions. A rollback on a transaction is to undo whatever that transaction...
June 12, 2011 at 8:15 am
aaa-322853 (6/12/2011)
I wanted to provide somekind of update to where my findings have led me, any feedback is welcome as always.
So I posted...
June 12, 2011 at 6:06 am
You can use the Data Collector if you have Enterprise edition. That will collect disk usage for you and is built into SQL Server.
June 12, 2011 at 5:00 am
Viewing 15 posts - 12,331 through 12,345 (of 22,214 total)