Viewing 15 posts - 27,856 through 27,870 (of 39,769 total)
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...
July 10, 2008 at 12:10 pm
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...
July 10, 2008 at 12:08 pm
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...
July 10, 2008 at 12:06 pm
Drop and recreate should use less log space.
July 10, 2008 at 12:05 pm
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...
July 10, 2008 at 12:05 pm
Haven't seen that. Did you create the database before restoring? could the sizing have been wrong?
July 10, 2008 at 11:38 am
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...
July 10, 2008 at 11:37 am
In that diagram, correct, but if I < J, then it would come before it.
July 10, 2008 at 10:51 am
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...
July 10, 2008 at 10:50 am
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...
July 10, 2008 at 10:29 am
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...
July 10, 2008 at 10:17 am
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."...
July 10, 2008 at 7:44 am
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...
July 10, 2008 at 7:40 am
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...
July 10, 2008 at 7:23 am
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...
July 10, 2008 at 7:16 am
Viewing 15 posts - 27,856 through 27,870 (of 39,769 total)