Ah, ok, so I understand... the parallelization is ever over all files in the file group.

We had a handle during the shrinking for hours on one of our data...

But if a table is stored in a few pages it can not spread into a lot files, I would like to analyze the table for this pages and find...

solved by myself...

Note 548221 - Temporary Files are created as sparse files

"--sparse=NEVER" is the keyword <> http://en.wikipedia.org/wiki/Sparse_file

PaulB-TheOneAndOnly (8/4/2012)

---

In the case of a stable database I would keep datafiles from growing automatically 'cause a transaction going crazy may blow up your file systems.

In the case of a...

Hi Durai, we don't use maintenance plans or auto create statistics. We use the build in auto update statistics for all objects and use manually daily an update for statistics...

perfect... [] solved my problem

it is hard coded in the job step

I know, but we would like to try and to compare with oracle the SAP performance. Could you please post the correct trace flag?

Thx for your hint, but we like to set up a global option; not to hint any executions.

cfradenburg (7/7/2011)

---

I'm not sure I agree with...

Developers (mostly in the beginning stages of their career) often tend to use OPTION (RECOMPILE) an an excuse for introducing more and more adhoc T-SQL into the application and...

implicit transactions is not active, user options is '0', is this correct?

http://connect.microsoft.com/SQLServer/feedback/details/616796/sql-2008-sp1-fails-to-install

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/d70411b5-5d68-4ead-a75a-c09a0f3f4183?prof=required

further error details:

2011-05-23 15:49:27.21 spid7s Error: 15002, Severity: 16, State: 1.

...

thx.. I will try this if enything else failes: http://msdn.microsoft.com/en-us/library/ms189625.aspx

I'm playing at the moment with the implicit_transactions setting:

http://sankarreddy.com/2010/02/get-the-server-level-default-connection-properties-for-sql-server-using-t-sql/

http://msdn.microsoft.com/en-us/library/ms189631.aspx > user options (http://msdn.microsoft.com/en-us/library/ms176031.aspx)

for...

We could at the moment not solve the problem. What is with a fresh installation. Can we uninstall the old MSSQL components, do a freh install of a named instance...

In the following blog the it is described I have to search for "Orphan" users. I found one entry in the master DB.

http://blogs.msdn.com/b/karthick_pk/archive/2010/11/18/sqlserver2008-script-level-upgrade-for-database-master-failed-because-upgrade-step-sqlagent100-msdb-upgrade-sql-encountered-error-574-state-0-severity-16.aspx

The MS article to sp_change_users_login describes

"Report"...

http://blogs.msdn.com/b/karthick_pk/archive/2010/11/18/sqlserver2008-script-level-upgrade-for-database-master-failed-because-upgrade-step-sqlagent100-msdb-upgrade-sql-encountered-error-574-state-0-severity-16.aspx

I executed this one:

use master

EXEC sp_change_users_login 'Report';

This script found a user, but what menas: "Check if there are Orphan users in system databases and fix them"

What...