To be clear:

The min server memory and max server memory options are advanced options. If you are using the sp_configure system stored procedure to change these settings, you can change...

Echoing what Gail said, if you want to free up memory by changing what SQL Server uses you need to reduce max server memory until you get it to a...

@ipounder,

Well, my line of reasoning was as follows:

1) Backup compression of an already compressed database yields very little data reduction, as has been pointed out.

2) One of the...

Upon first reading the question, my reaction was also "Well, it obviously depends on information not given in the question."

Then I realized that wasn't an answer, and went with the...

You can query the default trace to find which databases have RESTORE VERIFYONLY commands run against them. You're limited to how far back the default trace goes, but since you're...

One funny note on the DENY VIEW ANY DATABASE bit: I once had a request to prevent a login from being able to view the names of any databases on...

In a situation like that described by the original poster, I would do the following:

1) Run the query shown by SQLSACT a couple times and check the percent_complete column for...

I've not worked with the Fusion array, but I've worked (and still work) with a lot of Nimbles. Quick bullet points from my experience:

1) Write performance is incredible (latency almost...

I do not believe it was a typo. Instead, the lack of 32-bit seems to have been specific to the CTP download. The CTP 2 download allows you to choose...

I have some Windows server 2012 + SQL Server 2012 combinations both in the lab and in production, and they work without issues (well, without this issue :-D).

I actually...

The following query is also helpful to see what user sessions are killing CPU, as user sessions that are not currently running will not clutter things up. It's served me...

It is not always so similar. If I had a stored procedure DeadLockDB.dbo.CauseDeadlockWithUpdate, that contained the statement

UPDATE DeadLockTable SET DeadLockFloat=RAND()*@HavocFactor

and that statement was involved in a deadlock when I...

What Service Pack and Cumulative Update are you on?

http://support.microsoft.com/kb/2733673

Cheers!

It's creating the backup command with single quotes around the database name, which causes the syntax error you are seeing. If you want to make sure the database name gets...

Two questions:

1) Does the SQL Server error log show a login failure for that login when you try to start the Agent?

2) The "Access Denied" error you received looks more...