I agree with HTH, i know it could be challenging because DBA job is comparitively a higher rated job.

Becuase you would be managing some company's customer data may be.

So,...

would you pls elaborate that how could physical disk counters like reads/Sec and Writes/Secs as you mentioned could help you analyse memory issue.

To...

Ideally, the statistics need to be updated or are updated :

1. When you do alot of DMLs in your tables or indexed views.

2. If the schema changes happen on your...

There is no easy solution to it. you have to capture the perfmon data to get a clear picture of whether or not you have some memory bottleneck on your...

Helical Joan2 (5/12/2011)

---

Hello, I am doing a backup, but it has error:

DB_backup_20110512063314', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Cannot open backup device...

Sourav-657741 (5/8/2011)

---

Database Shrink job doesn't run during the time of Rebuild Of the Indexes. The strategy is:

1. First the Database Bkp job runs.

2. Second the T-Log bkp job is kept...

Try out this ..

create table #temp_table

( a datetime)

go

insert into #temp_table (a) values (getdate())

insert into #temp_table (a) values (getdate()+.10)

insert into #temp_table (a)...

laparicio (5/7/2011)

---

I have two views that i need to get some info from

I need a query that give the following results:

item, description, qty, and the cost

here is the vies:

vPickDetails(customer_number,company_name,item_number,description,picked_quantity,creation_date)

vInventoryCost(inventory_id,quantity,item_number,description,cost)

will...

Pl. post your question appropriately and as lowell mentioned share the trigger code with us to get a better help on your issue.

Regards,

Sachin

Sorry but i contradict on...

matthew.peters (5/8/2011)

---

Hello

I have been monitoring the following counter SQLServer: General Statistics\User Connections through performance monitor but the user connection count is lower than the number of rows returned by sysprocesses,...

Sorry . but this is not a SQL SERVER 2000 Forums and with no wrong intentions. I myself know the security loop holes in sql server 2000 .

I provided...

Just...

As i mentioned earlier even if you have select permisions on the system views which by default a public...

forsqlserver (5/5/2011)

---

Thanks...

But I want to just confirm that will Mirroring be OK or Not?

How Do I check this? If I create database snapshot of Mirror datasbase but I dont...