Viewing 15 posts - 9,826 through 9,840 (of 14,953 total)
Generally depends on how you did the backups, and why you're restoring.
April 23, 2009 at 1:53 pm
That looks fine. The Common Files (X86) part is just for anything 32-bit that SQL needs. It's usual when installing on 64-bit boxes.
You don't need BOL and client...
April 23, 2009 at 1:52 pm
Steve Jones - Editor (4/23/2009)
That's an interesting technique. With VMWare/Virtual PC, you could easily set one of these up. Hmmm, I think I see an editorial here.
If you're talking about...
April 23, 2009 at 1:49 pm
If you search for those things in Google, it appears to cap at 32 on Enterprise, and 4 on Standard.
April 23, 2009 at 1:45 pm
You can't place a check constraint directly on a UDT. (That's actually come up twice this afternoon on this site.)
You can create a table of valid values and use...
April 23, 2009 at 1:38 pm
Good point, Timothy.
April 23, 2009 at 1:35 pm
In that case, you're almost going to have to handle it row-by-row. You might be able to build an algorithm for splitting it that would work on the whole...
April 23, 2009 at 1:33 pm
I made it up as a conversation-starter for interview situations. Hand someone a laptop with this on it, ask them what they would do. Make it clear that...
April 23, 2009 at 11:34 am
It looks like the quotes are around a consistent set of columns, in your example. If that's so, then OpenRowSet with an XML-typle configuration file should be able to...
April 23, 2009 at 11:17 am
From what you're describing, you can achieve that pretty easily with a pivot table, either in SSRS or in Excel.
April 23, 2009 at 11:11 am
You could probably get exactly what you want with a CLR data type. Those can have pretty much as complex of rules as you want, at the cost of...
April 23, 2009 at 11:10 am
There's more to it than might meet the eye at a glance. There are the obvious violations of normal form, data typing, etc., but how many will even check,...
April 23, 2009 at 11:02 am
Greg Edwards (4/23/2009)
Bob Hovious (4/23/2009)
Why isn't there an SQL equivalent to Iron Chef? That would make for an interesting competition. ...
April 23, 2009 at 10:10 am
That works too. Lower ROI (due to paying for 2 upgrades in 2 years instead of 1), but potentially lower risk.
April 23, 2009 at 9:43 am
That error comes from the table, not the proc directly. Check field sizes in the table.
April 23, 2009 at 9:41 am
Viewing 15 posts - 9,826 through 9,840 (of 14,953 total)