Viewing 15 posts - 50,116 through 50,130 (of 59,078 total)
Just curious... Max size for INT is over 2 billion... that should handle your 10 million rows quite nicely for 214 tables. Why would you need unique numbers for...
June 10, 2008 at 7:06 am
Steve,
The link to "IT Project Failure" is broken.
On the subject of IT Project Failure... how often is it that IT is the one that "designs" a project? Normally, it's...
June 10, 2008 at 4:58 am
Heh... I've gotta agree there... 2 billion is usually more than enough, never mind 4 billion... what is it that you're storing?
June 9, 2008 at 9:31 am
Peso (6/9/2008)
If I hadn't, both you and me would present a working solution. What a waste...
June 9, 2008 at 7:59 am
Peso (6/9/2008)
I see that now.I responded to a PM and saw that OP posted same question on the forums.
Didn't notice the version.
Thanks for the feedback, Peter... Op seems happy with...
June 9, 2008 at 7:39 am
Nicely done, Peter! I'm still kinda new to the 2005 world and I keep forgetting about stuff like that...
heh... especially on a 2k forum 😉
June 9, 2008 at 6:59 am
Heh... yeah... 648 of them were me trying to figure out your problem... 😉
I could make it 651 ya know... 😀
June 9, 2008 at 6:54 am
I would think that a Linked Server would be able to do that... Search for it in Books Online for the details. They're pretty easy to make.
June 9, 2008 at 1:09 am
The default declaration for NUMERIC (also known as DECIMAL) is 18,0 and takes 9 bytes to store. The max precision for NUMERIC at 9 bytes is 19,0 so if...
June 9, 2008 at 12:51 am
Nicely done, Gus... Can't wait for the others!
June 9, 2008 at 12:19 am
Who does the pivoted data start out? In a spreadsheet or in a table?
If it's in a spreadsheet and you can't unpivot it there for some reason, then I'd...
June 8, 2008 at 7:35 pm
Yes... it's so the system doesn't have to wait until your insert is done before anyone else can do an insert. If your insert fails (or you change your...
June 8, 2008 at 7:25 pm
Viewing 15 posts - 50,116 through 50,130 (of 59,078 total)