Hello,

we have gotten feedback from application vendor saying that it is not a application bug but it is depened on the server capacity and different environment. Some copmanies can handle...

Hello,

The documents are stored on application side not database server but some meta data is stored in database. when moving a big folder like 4G forlder in the application, some...

SELECT tr.*

FROM sys.fn_trace_gettable

(CONVERT(VARCHAR(500),

...

I think the following statement will reduce contention rate in our environment

EXEC sp_configure 'show advanced options', 1;

RECONFIGURE WITH OVERRIDE;

EXEC sp_configure 'xp_cmdshell', 1;

RECONFIGURE WITH OVERRIDE;

SET @batStr = ' mkdir e:\doc';

EXEC('EXEC...

Thanks for your input! Is there a way to resolve this contention issue and use xp_cmdshell in user's application? In our environment, we cannot get sysadmin which is me to...

Thanks for your input! So my backup solution is ok even if some recent days' backup failed only if I have all logs backed up to date, I can still...

I have figured it out that remove SP1 is not from the screen in attachment. It is in View Update screen section in add/remove program part and choose only sql...

Hello,

I have upgraded my database to sql server 2012 SP1, now I need to test remove SP1 part only but still keep sql server 2012.

From Windows add/remove program I have...

Hello,

I want to upgrade SP1 under the same software root with Sql Server 2012 and if I want to remove it, can I only remove SP1 software but keep...