Based on the following link, there is no way to change the default-trace file size and number of log files; is that correct?

http://www.eggheadcafe.com/software/aspnet/32855710/default-trace-logs--increase-size.aspx

Thanks, it turns out default trace is being used behind the scenes for the SSMS report.

I have the following query from the profiler trace:

select ObjectName

, ...

Jeffrey Williams-493691 (2/22/2011)

---

There is a standard report that you can use to see these changes. The report is the schema change history report - just run that and you...

SQLkiwi (2/23/2011)

---

Craig Farrell (2/23/2011)

---

Thanks Paul, I was worried I was barking up the wrong tree. Apparently I was in the wrong forest. 🙂

I'm going to need to read that...

Here is a good link and a query from that link I have found very useful:

http://www.simple-talk.com/sql/database-administration/investigating-transactions-using-dynamic-management-objects/

--Assessing transaction log impact

--http://www.simple-talk.com/sql/database-administration/investigating-transactions-using-dynamic-management-objects/

SELECT

DTST.[session_id],

DES.[login_name] AS [Login Name],

DES.[program_name] AS [Program Name],

DB_NAME (DTDT.database_id) AS...

The degree of parallelism setting applies to individual operators in a query plan, eg. a hash-match operator could itself be spreading its work over several processors. Since a query plan...

No problem, BTW a quick thing to do to find out what may be using sp_configure is to script out all...

gemisigo (2/22/2011)

---

Thank you very much, Perry, that should do the job. Besides, I've learnt a bunch of things from it, I've just started using the Profiler.

Two more questions though....

I saw this link that describes a very similar issue, this time with the IF EXISTS clause.

Are we looking at some bizarre behavior from the query engine here?

http://www.sqlservercentral.com/Forums/Topic957634-338-1.aspx

AlexSQLForums (2/9/2011)

---

what does this return:

WHILE EXISTS

(

SELECT top 1 NULL

FROM dbo.tmp1 TMP (NOLOCK)

...

When I run this on my server I get that virtual_memory_reserved_kb = 6,322,496, or...

Thank you, I will look at these.

BTW, I have some scripts I use to automate SSAS-db restores from production to the D/R server as a nightly job. I use powershell with SQL Server 2008 AMO. See...

Vivien Xing (1/28/2011)

---

Marios Philippopoulos (1/27/2011)

---

Vivien Xing (5/7/2008)

---

I sent a feedback to Microsoft. Package version feature will be considered for the next major release. If you have any comments...

Vivien Xing (5/7/2008)

---

I sent a feedback to Microsoft. Package version feature will be considered for the next major release. If you have any comments to add on, here...