So, if I understand correctly, the only use of turning off xp_cmdshell is to remind database administrators that is company policy not to use xp_cmdshell.

I also read on MSDN that...

You could create a DNS alias (e.g. CNAME record) for each database which point to the correct server. E.g. for the Finance database on server DB1 create the DNS record...

I won't be surprised if they barely break even on this. Seriously.

If you are using SQL accounts then slowdowns are unlikely to be caused by different domains.

You should follow standard performance troubleshooting procedure. Run a trace using the profiler. Use the...

Okay, I have a few questions for a getting a better view of the situation (not sure actually if they could be relevant):

- Is the user account running the client...

SQL Server won't perform poorly just because its server computer is a member of the different domain than the client computer.

Authentication and hostname resolving might take a bit longer because...

Sigerson (11/27/2012)

How can you tell whether a Linked Server is read only. I looked for a 'read-only' flag...

One way to find unused objects is to look at index usage statistics. However, beware that some indexes are used less frequently e.g. monthly reports.

Do I understand correctly, the same delay will happen when failing over when using clustering or log shipping?

Hi Ksr,

First thing to do is explain your disk setup, so we can understand more about your system. You have already explained that the normally backups are written to a...

@celko,

Let me get this clear, so I'll understand you correctly. You can predict which kind of errors and design flaws someone makes in code, by someones preference to...

A trivial, but interesting question.

Those operators are semantically equivalent in Microsoft SQL Server.

<> is the standardized not equal operator. Most other SQL products implements this operator. IMHO it is...

In my opinion an expression like "x years y months" isn't a date but more like the .Net type TimeSpan. So I wouldn't advice you to convert it to dates.

I...

Another way to print a calendar using PIVOT:

CREATE FUNCTION CalenderUsingPivot

(

@BeginDate date

, @EndDate date

)

RETURNS @Calendar TABLE

(

Week tinyint

, Monday tinyint

, Tuesday tinyint

, Wednesday tinyint

, Thursday tinyint

, Friday tinyint

, Saturday tinyint

, Sunday tinyint

)

AS

BEGIN

DECLARE...

On Unix/Linux systems there is command called unix2dos which can convert LF text files to CRLF text files. Otherwise the same is possible with sed, awk, perl, etc.

Also most...