Shark Energy (3/4/2010)

---

Thanks for the feedback. Our current server is a strange fish. Keeps up to date with replication every 30 minutes but only has a big transaction hit once...

To create a new blank database with the full schema I recommend the following:

1) Download and install SQL Compare from Redgate (trial edition is fully functional) and purchasing it is...

What you should be doing is:

CASE WHEN Item = 5 THEN (SELECT {column} FROM table WHERE ...)

ELSE 1

END

Nicholas Cain (3/4/2010)

---

You need to have at least one disk available that is not assigned elsewhere.

You can put all of the SQL resources on that one disk (obviously not recommended)...

As in all things, it depends 😉

Using Netapp as an example, you can present storage from different aggregates to your server and direct access to those different aggregates through different...

AlreadyPicked (3/4/2010)

---

Thanks, this is a nice tip but want I would really want is to log into the SQL Server Log without logging in the Windows Application Event Log.

Is that...

Here are a couple of options:

1) Use SSRS - create a report based on the stored procedure. From there, you can export to Excel or even schedule it to...

So, you basically removed yourself from sysadmin access because your login is a part of the BUILTIN\Administrators group.

A couple of options:

1) Connect with a known SQL account with sysadmin privileges...

Yes, you can disable those messages using a trace flag. See this article for further information: http://www.mssqltips.com/tip.asp?tip=1457

Well, I wouldn't say it was normal either - but I have seen it quite often. Mostly where the company wants to be able to deliver their product on...

Since maintenance plans are really just...

You need to run the following on that database and post the results here:

DBCC CHECKDB({your database}) WITH all_errormsgs, no_infomsgs;

What you posted before does not show the errors and we need...

Check to see if those databases have auto close enabled.

Marcia Q (3/2/2010)

---

Aeterna - Thanks!

klnsuddu - Take a look at Jeffery's post. Bulk_logged recovery mode doesn't matter with indexing.

To answer your question though - According to BOL...

You need to talk to the administrator of that system and find out where you can put your backup file so it will be accessible to that system. You...