Viewing 15 posts - 12,466 through 12,480 (of 22,214 total)
Steve Jones - SSC Editor (5/25/2011)
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
Is that for sure?...
May 25, 2011 at 4:28 pm
GilaMonster (5/25/2011)
Grant and I are talking Execution plans for a whole day at PASS Summit this year.You are all coming? Right?
WHOOP!
I'll be there.
May 25, 2011 at 3:43 pm
My initial take, based on the column name, was that you have clustered GUIDs, which are absolutely prone to fragmentation, but based on what you're telling us so far, it's...
May 25, 2011 at 10:29 am
river1 (5/25/2011)
Liquidacao.DESCPERIODO, Liquidacao.CODTLIQ1, Liquidacao.IMPTRIB, Liquidacao.CODDLIORIG, Liquidacao.TIPODLI, Liquidacao.CODCRORIG,
ISNULL(dbo.IMPOSTODESD.NUMIMPDESD, Imposto.NUMIMP) AS NUMIMP, Contribuinte.NOMECTB, Contribuinte.NIFCTB,
CCCredito.VALORCCCREDITO, SGTALiqData.NUMDU, SGTALiqData2.OrdemNotas, SGTALiqData.CODCR, SGTALiqData.DATAEXPIRACAO,
Liquidacao.CODANULA,...
May 25, 2011 at 7:39 am
GilaMonster (5/25/2011)
river1 (5/25/2011)
I undestarnd but still in 2000 that didn't happen and lthe table has only a few more rows...
SQL 2000 to SQL 2005 was a major change. not a...
May 25, 2011 at 7:36 am
There are changes to the query optimizer between 2000 and 2005. Because of this, you will see some changes in behavior. Most of the time you'll see improvements or no...
May 25, 2011 at 6:56 am
You need to look at what processes you're putting through tempdb. If it's growing that much, it's because it's being used, so you need to identify what it is that...
May 25, 2011 at 4:42 am
You might want to look up a process called log shipping. I think that will do what you need much easier than what you're talking about.
Also, you won't be able...
May 25, 2011 at 4:41 am
There are instances where a poorly written query performed adequately in 2000 but doesn't perform as well in 2005/2008. Usually fixing the issues with the query fixes the problem.
May 25, 2011 at 4:37 am
That's what it's basically doing, but it's doing it in a single command as opposed to two. Why do you ask?
May 25, 2011 at 4:35 am
Sorry, went off to bed. Looks like Gail answered all the questions already.
May 25, 2011 at 4:21 am
When a checkpoint occurs all the dirty pages, stuff that has changed, gets written to disk. I haven't looked at Diagnostic Manager for quite a while, but I imagine it's...
May 24, 2011 at 7:02 pm
Let me say up front, I hate the DTA. When it gives advice, it frequently gives bad advice.
That said, it sounds like you weren't connected to a database with all...
May 24, 2011 at 2:59 pm
Another vote for SQL Prompt Pro[/url]. I'd hate to live without that software.
However, you could try the Simple-Talk SQL Prettifier.
May 24, 2011 at 2:55 pm
Viewing 15 posts - 12,466 through 12,480 (of 22,214 total)