Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles,...

bitbucket-25253 (12/26/2011)

---

Gosh - if that is the definitive method then Lord help us...

Probably.

Yes, differential is all changes since the last full backup.

But most third party backup software does backups that count as "full" backups. Some don't (doing file-level backups instead), but...

You could use the Top () operator to do that.

declare @Rows int;

set @Rows = 5;

select top (@Rows) MyColumn

from dbo.MyTable

order by MyOtherColumn;

Yes. Just translate your Courses Purchased into hours in all cases, whether they buy hours directly or courses.

This sounds like homework or a test. Is it?

And you might make it worse. While Loops are...

The "badness" of a cursor is pretty mild compared...

If you want to restart SQL Server services (SQL Server, SQL Agent), you can do that from within SSMS, by right-clicking the appropriate item and selecting Restart.

Other services, you right-click...

I've seen this before.

The index was better for the rest of the query, and since SQL Server can't estimate into a scalar UDF, it decided to use that index. ...

Is the server local (same computer as Management Studio) or remote (different computer)?

If remote, is it on the same Windows domain as the computer with SSMS (Management Studio), or a...

update a set a.[did]='z' from locn a

join acs b on a.[lid]=b.[lid]

join aco c on c.[uid]=b.[uid]

where c.[type]='c'

You want a (locn) updated where a.did = 'd', per your description:

I want to update...

The client pcs could certainly be an issue. Could also be browser version issues, if the application is browser-based. Or could be a WINE vs Windows issue, if...

Costs in execution plans are, by and large, junk data. Use the I/O and time stats instead.

Another option would be to Outer Apply the sub-query, but that's likely to...

I have to admit, I spent a couple of minutes reading and re-reading the possible answers, trying to figure some way it could possibly be something I was missing. ...

tabinsc (12/27/2011)

---

Excellent question Jeff! I do have one question: If clustered index columns are auto-appended to nonclustered indexes, what if the nonclustered index is unique? Adding the...