you can obtain this information simply by querying the sys.dm_os_process_memory DMV. The physical_memory_in_use column indicates total memory usage

Read this articles.

Sql Server profiler:

http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step

Using perfmon:

http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

Below error message itself tells that what correction needs to be done.

Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp...

Please read this.

http://www.google.co.in/url?q=http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx&sa=U&ei=ZkZUT_TKEMPnrAfLgdXWBw&ved=0CBUQFjAB&sig2=xGqzu3ciPprNQ30wx_VLVw&usg=AFQjCNFV561opnT_bpNlR_hMUh7VhqmXEA

You can not truncate the table if any column is referred by any other table like primary and foreign key relation.

you have to first delete the data from foreign key...

Check this link.

http://support.microsoft.com/kb/285100/en-us

Check this link.

http://connect.microsoft.com/SQLServer/feedback/details/351315/books-on-line-succesfully-installed-are-not-accessible

Vahid.Ch (3/3/2012)

---

hi there,I want to search mdb files in specific path.

following query select all of files in "..\Microsoft SQL Server\MSSQL10_50.SPR2\MSSQL\DATA\.." path.

SELECT name, physical_name AS current_file_location

FROM sys.master_files

but how can...

Here is the script.

http://sqldbpool.com/2010/03/27/script-to-fix-and-list-out-orphan-users-on-all-the-databases-on-server/

You can increase the timeout value by below command.

ALTER DATABASE XXXXX SET PARTNER TIMEOUT 30

The default mirroring time out value is 10 seconds. You need to increase this number if you have more and more database transactions.

Please post the execution plan to analyze the query.

Check this.

http://msdn.microsoft.com/en-us/library/ms345120(v=sql.90).aspx

replication and cdc are totally different.Replication is used to populate the data from one database to other the database. But in CDC it captures both old and new data...

THis blog may help to understand the deadlock graph.

http://weblogs.sqlteam.com/mladenp/archive/2008/05/21/SQL-Server-2005-Immediate-Deadlock-notifications.aspx