Also if you are not sure whether your performance issue is coming from SQLServer the you can check the system activity in either the performance monitor (perfmon.exe) or the task...

We have tried several Virtualisation tool (not for DB) but as application server consolidation and all of them have got a lot of peformance issues.

But what is your main reason...

Just a stupid question here: Would QA ans EM not be fine? Maybe together with some notification Service, alarms, mail sending like http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Personnaly I'm using http://www.sqldev.net/xp/sp_smtp_sendmail.htm for sending mails. It can send text or HTML mails, fast and reliable

But Sufian, you have also asked how it does that the number 2 ot the status field from the dbcc loginfo is moving from the file number 2 to the...

Also it depends how your table is actually fragmented (DBCC Showcontig).

If your table/index is very fragmented, then you will need more space for your tran log

As an alternatve solution tu the truncate table method you could also copy the "good" records to a new table (not temp table) drop the original table, then rename the...

http://www.sap.com

one of the biggest ERP.

On other hand those "poor" developers and consultants are earning like hell (except the poor DBA's)

There are consultant per...

a temptable is valid only for the session it is created. I menas that in separte session you can refrence under the same name the temptables.

If you absolutly want a...

Remi, It works!

As even worse, Every SAP system in every database is using the same implementation. So Is SAP used worldwide? YES! So every DBA running SAP has the same...

Sufian,

You cann't see any documentation about DBCC loginfo in the BOL because it is a so called "Undocumented" feature. It means It can be changed by MS without any notice.

On...

We have a large ERP system of 0,5+TB

When we are reindexing we are making a full backup then we swith to bulk logged, reindex, switch back to full recovery and...

I think I've won

The application is SAP. This table has "only" 266 columns.

BUT there is a stored procedure (still in SAP) which has...

Both are exactly the same speed just you use them differently

create proc XX

as

select count(*) from sysobjects where type = 'U'

go

create function YY ()

returns int

as

begin

return(select count(*) from sysobjects where type...

I wouldn't do the BCP out of SQLServer.

You should go the your preferred command prompt, check whether you can access to SQLServer, after you can issue the BCP command (maybe...