This question is badly written, .. B is the most correct answer

Are you able to post your create index statements?

without looking at the execution plan it is hard to tell, but from the query one suggestion would be to have seperate...

There are a number of commercial log readers available that will read the LDF for you, I have not used these personally so I am not sure whether they would...

arup_kc (9/22/2009)

---

steveb. (9/22/2009)

---

You can do the same with IN

select name, value, version from #temp

where name in (select name as version from #temp group by name)

AND version in (select max(version)...

You can do the same with IN

select name, value, version from #temp

where name in (select name as version from #temp group by name)

AND version in (select max(version) as version from...

It is not entirely clear what you want to acheive but to give you a start ,this query will select the rows with the max version grouped for each...

you could create one plan to run a DB2 backup daily with conditional logic in the T-SQL backup code to run a DB1 backup if the day is Sunday

It looks like you have missed out a select on the update statement

UPDATE #Manufacturers

SET Manufacturer_Date = MIN(#ProductInfo.Product_Date)

FROM #Manufacturers

INNER JOIN #Products ON #Manufacturers.ManufacturerID = #Products.ManufacturerID

INNER JOIN #ProductInfo ON #Products.ProductID =#ProductInfo.ProductID

should be;

UPDATE...

This is not a good idea as it probably wont make the query any faster...

Depending on how large the varchar columns are you may get quicker results using Full-Text Indexes on these columns

http://msdn.microsoft.com/en-us/library/ms345119(SQL.90).aspx

Full-Text is efficient at searching a word from a...

database names on the server can be found with this query

SELECT name FROM sys.databases

as for the sa password, you will need to ask your DBA as I don't...

Without primary keys or any unique identifiers then what are you going to use to compare rows?

It seems like you may want to schedule a job to run on the database rather than use a trigger, as mentioned triggers have to be fired by inserts/updates/deletes.

Either...

you can cycle your error log with;

EXEC dbo.sp_cycle_errorlog

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

If you are using a job to send the results to a .txt file, the one alternative way would be to create a SSIS package to extract the...