How will it affect performance? Not sure.

An int in 4 bytes, so 32 bits are available. You could bitmask, but I think the storage overhead for bits is minimal, they...

The indexing is a logged operation, so you end up with 2x index size (+ pad) when it's working, so I can see if doubling in size if you have...

use Datepart and be sure you know what your datefirst setting is. You can set any day to be the first day of the week.

I think you can also get...

Drop and recreate should use less log space.

Apr 8 I think was the SQL 2K mainstream support end. They'll do security patches, but if you find bugs, you need a support agreement to get support.

Their plan is...

Haven't seen that. Did you create the database before restoring? could the sizing have been wrong?

that message indicates that your network requests are not being responded to by the server. Either it's down, port is blocked (either way) or you are connecting on the wrong...

In that diagram, correct, but if I < J, then it would come before it.

Nope, totally fair question. I assume this is the Monday article this week.

The articles are proofread and often sent back to authors with ideas and suggestions for improvement. We run...

75 ft.

15 ft out the bedroom door, 20 ft across the hall and down 1/2 the stairs. 10 ft to get down around the corner and about 15ft back...

I like Dan's notes here, and it's likely an EMBA is more than a regular one, but I was thinking of a degree I could pursue while working and the...

Mike,

I think I'm missing your point. I think most job adverts get cobbled together by HR with feedback from techies. "What do they need to know?"

"SQL, backup, restore, etc."...

I've always wanted an MBA, but I realized about 8 or 9 years ago that the payback wasn't there. Shortly thereafter I started this site and perhaps got a business...

Agreed that you don't have to lower the bar, but this is a corporate program , like any other. Removing 100 MVPs in Dec and bringing back 20 impacts budgeting...

The question listed the category as SQL Server 2008, and it does not apply to other versions, as mentioned above. We do try to get the version listed where we...