Believe it or not, Microsoft's online documentation (BOL) is suprisingly good.

I'm not sure what happed with your first restore attempt. It seems like you basically did the right thing....

I haven't seen that behavior, but I have bult manual log shipping programs with C#. But really, you could use almost anything. This might work better for you...

It's not a system database, is it? (Master, Model, MSDB or tempdb.) These can't be deleted.

If you SET CONCAT_NULL_YIELDS_NULL ON (which I believe is the default value, you should be able to accomplish this very easily:

select LastName + ', ' + firstname + isnull(' '...

select max(price)

from (

select top 100 price

from tab1

order by dates desc) a

You would be correct if there are spaces in the data. Although the question didn't state it, I assumed that the field was some type of varchar and that...

I didn't think it was a good idea. I was wondering if there were good reasons for it, but I guess in most cases, there aren't.

I was also struck...

DBCC DBREINDEX does update the statistics on the indexes being rebuilt.

Perhaps you need to review your indexing strategy. Also, are you sure that all indexes on all tables are...

You could create a temp table with your months, similar to the following:

select month

from #months

where month not in(

Select distinct b.month

from invoice a,

#months b

wheredatepart(mm, a.InvoiceDate) = month

)

I think a rule of thumb is to use joins whenever possible, but to test the plan if performance is not what you expect.

SQL Server can perform a join in...

quote:

---

why not

select * from syslogins

---

syslogins doesn't contain the password. I believe you...

If stars are meant to show the level of commitment/contribution to this forum and not necessarily the level of knowledge, perhaps the problem lies in the labels. Labels such...

Another approach is to use another table to hold your values. Then use a stored procedure to update the other table and get the last value. Always get...

What kind of SAN do you have? My experience is with an EMC Symetrics (RAID 1+0) connected by fiber. It was much, much faster than any internal disk....

Maybe I'm missing something. can't you just order by productiondate?