Check this nice article for server level inventory.

http://www.sqlservercentral.com/articles/64016/

We have just upgraded one of our dev server.. still exploring the 2012.. Nice article thanks.

Check This.

http://blogs.technet.com/b/josebda/archive/2009/03/31/sql-server-2008-i-o-performance.aspx

I am also having two different resume for developer and administrator. When I am trying for development post I give emphasize on development duties but I also keep some...

Use of BCP.

http://msdn.microsoft.com/en-us/library/ms162802.aspx

By modifying the log file directory wont create any issue. here is the steps.

http://www.mssqltips.com/sqlservertip/1774/move-sql-server-transaction-log-files-to-a-different-location-via-tsql-and-ssms/

Using SSMS.

http://blogs.msdn.com/b/davidlean/archive/2009/09/20/tip-ssms-script-your-entire-table-including-the-data-a-hidden-gem.aspx

blocking gets cleared automaticaly or you have to manually kill the blocked transaction?

I also encounterd same issue we left the killed\rollback transaction for a weak but no progress at all than we decided to recycle the SQL services. After restart that spid...

If you are using maintenace plan then there is a option to exclude the offline databases and also if you have made any customized script in that also alter the...

Its might be like in your code old database name is used that's why your application is connecting the old one only. so find out the issue in your application.

beejug1983 (4/10/2012)

---

Hi All,

How can I give permissions to login to start SQL Agent job? I have a login which have no special permissions it has only public role and mapped...

If you are doing restore then obviously no one can access the database. its better to start the the refresh activity by keeping database in single user mode.

I think you can try with yourself as all maintenance configurationcan be easily done by maintenance plan wizard.

http://msdn.microsoft.com/en-us/library/ms191002.aspx

Are you installing on cluser node on stand alone?