1. yes, the log size would decrease with frequency of backups

2. truncate only clears the space and does not unallocate the space

3. if you want to free up disk space,...

I had a situation where a 3rd party app was deployed and the database was stuck in recovery/readonly simultaneously and attempting to drop/detach/recover or otherwise change the state of the...

I'm not sure if it can cross domains or not, but double-take has been working well for us. It replicates at the filesystem level and we use it to replicate...

select c.name as reportname, d.name as datasourcename from catalog c inner join datasource d on

c.itemid = d.itemid

you will have multiple rows per report if you use more than one datasource...

this should at least get you started

select * from catalog c inner join datasource d on

c.itemid = d.itemid

I've seen arguments both ways, but I always recommend trying both solutions yourself, checking query plans, and deciding which is better in your situation. I suspect both will produce the...

select a.column1, b.column1 from table1 a,table2 b where a.column2 = b.column4

technically, it's a join, but doesn't use the join keyword. This style of join is going to be deprecated, so...

It depends on the query and what you are sorting on. If you already have a particular query in mind, I would try it both ways and see what one...

I believe that would only affect order by clauses and sorting.

if the values in the table are only Null, , then you could use coalesce to return the first non null value it finds.

I use SSMS 2008 and run against a server group. I execute master.dbo.xp_readerrorlog against the server group and pipe the results into a table and then I filter out the...

I would try it on a 2005 box. It appears that your version of litespeed is not compatible with SQL 2008.

create all the logins from your old server to your new one. Be sure to fix any orphans too.

yeah, I know it sounds strange, but I think I remember this one, but like I said, it's been a while since I have run 2000. If you are in...

Are you in a position where you can reboot the machine? I have heard of instances where analysis services causes SPs to fail, and after a reboot sometimes they work....