Hello,

They should not have been able to delete the LDF unless they stopped the service. First step should be to find out what the Tech did. I regularly use the...

Hello,

My recollection is that if the recordset is going to be large then a temp table may out perform a table variable. If it is a performance issue consider...

Hello,

If you go Union go SEIU or Teamsters. Another good step would be to cut way back on H1 Visas in the US. Ban Canadians and put quotas on...

Hello,

I would restore the first DB and change the name in the Restore as Blank as the new name and then once it was created I would DTS the other...

Hello Mike,

There may be an easier way but I would take the simple old fashioned approach. Restore a backup under a different name. Script the indexes. Chop everything else out...

Hello,

I do not want to be too simplistic. This is not a Christian vs. Muslim thing. I have had the pleasure of vacationing in Iran 3 times in the last...

My apologies cliffb,

I did not mean to suggest that you did. It was just the thought of it I was responding...

Hello,

England has had a policy of allowing considerable latitude for political refugees. Men have been allowed to publicly side with Al Qaeda even when they are wanted criminals with...

Hello,

The London attacks are regrettable and my prayers go out for the survivors. The sad part is that the UK has allowed London to be a Safe Haven for terrorists...

Hello Steve,

Being a D.B.A. in regards to the database is like being the father of a 13 year old girl. Your job is to protect her and keep her pure....

Hello,

The basis of Relational database theory is founded on two mathematical principles, Set Theory and Predicate Logic. When we make a SQL statement such as "Select * From BushEnemiesList" we...

Hello,

I inherited a Database where someone set it to reindex all the tables. At least in my db many tables contained static data and reindexing was a waste of time....

Hello,

I checked my notes for this and here is what I had

Processor Queue Length

• System: Processor Queue Length.
• The optimum Queue Length is 2 x (number of processors)

So run a Perfmon...

Hello,

I think a composite key is a likely bet. However I also noticed that you are not completely qualifying your filter criteria. try adding "Product.CompanyID = @IDCompany" to the where...

Hello Chiranjib Chowdhury,

Obviously the objection to cursors is performance. Now when I picture passing the results of each loop of the cursor to another stored procedure in a parameter I...