Joy!
-
I've just stopped smoking and drinking at the same time, I'm working on abominable VB6 and VBA code between Acess and SQL Server, so I took on a little job for extra money, and I've just received the script for the table I am to code a front end for. Field names have been changed to preserve confidentiality. The one redeeming point is that there is no code here, I get to insert fresh, sexy, new C# code. CREATE TABLE "dbo"."clientTable" ( "oneField" varchar(8000), "abotherField" varchar(8000), "andGgain" varchar(8000), "totalOf" varchar(8000), "21fields" varchar(8000), "like" varchar(8000), "this" varchar(8000), ... ... ) GO
INSERT INTO clientTable VALUES("a","b","c","d"....That's going to be fun - a database that's in negative numbers for normal form. I see that they don't want Unicode either; obviously because it takes up so much space:-D
Deja View - the feeling that you've seen this post before.
-
INSERT INTO clientTable VALUES("a","b","c","d"....That's going to be fun - a database that's in negative numbers for normal form. I see that they don't want Unicode either; obviously because it takes up so much space:-D
Deja View - the feeling that you've seen this post before.
"What's in a name?..." -- Bill S.
-
I've just stopped smoking and drinking at the same time, I'm working on abominable VB6 and VBA code between Acess and SQL Server, so I took on a little job for extra money, and I've just received the script for the table I am to code a front end for. Field names have been changed to preserve confidentiality. The one redeeming point is that there is no code here, I get to insert fresh, sexy, new C# code. CREATE TABLE "dbo"."clientTable" ( "oneField" varchar(8000), "abotherField" varchar(8000), "andGgain" varchar(8000), "totalOf" varchar(8000), "21fields" varchar(8000), "like" varchar(8000), "this" varchar(8000), ... ... ) GO
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row. SQL Server 2000, anyway. SQL Server 2005 might do something different since it now supports
varchar(max), but I think you actually have to use that syntax to get out-of-rowvarcharfields. SQL Server 2000 makes you use the slightly-differently-behavingtextdatatype, which confusingly can be set to be stored in the row if it's below a certain length of data. (If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)Stability. What an interesting concept. -- Chris Maunder
-
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row. SQL Server 2000, anyway. SQL Server 2005 might do something different since it now supports
varchar(max), but I think you actually have to use that syntax to get out-of-rowvarcharfields. SQL Server 2000 makes you use the slightly-differently-behavingtextdatatype, which confusingly can be set to be stored in the row if it's below a certain length of data. (If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)Stability. What an interesting concept. -- Chris Maunder
Mike Dimmick wrote:
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row.
No, but I have just received the refreshing news that we have carte blanch with the databases for our development. This is a small company, and they are actually running seven different databases on the same server! Not for too long I suppose.
-
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row. SQL Server 2000, anyway. SQL Server 2005 might do something different since it now supports
varchar(max), but I think you actually have to use that syntax to get out-of-rowvarcharfields. SQL Server 2000 makes you use the slightly-differently-behavingtextdatatype, which confusingly can be set to be stored in the row if it's below a certain length of data. (If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)Stability. What an interesting concept. -- Chris Maunder
Mike Dimmick wrote:
(If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)
Kramer did it.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
Mike Dimmick wrote:
I surely don't need to point out that if the sum of field lengths used exceeds 8000 bytes, SQL Server will refuse to insert the row.
No, but I have just received the refreshing news that we have carte blanch with the databases for our development. This is a small company, and they are actually running seven different databases on the same server! Not for too long I suppose.
There is nothing wrong with running seven different databases on the same server. SQL Server is designed to do that. It depends on your definition of "database", and it is the actual size of each database and the number of users which will determine your hardware requirement, not the "number of databases" which has almost no bearing on your hardware choices. The "not for too long" here is the lack of types in the tables. You obviously know the problem with that. Just don't go around in a small startup company telling people you need more hardware, or it will be you that's not around for too long. Tell them how to run all those databases on a cheaper server and get better performance out of it... and they'll give you a raise. Shouldn't be too much trouble to improve things, given where you're starting from.
"Quality Software since 1983!"
http://www.smoothjazzy.com/ - see the "Programming" section for freeware tools and articles. -
There is nothing wrong with running seven different databases on the same server. SQL Server is designed to do that. It depends on your definition of "database", and it is the actual size of each database and the number of users which will determine your hardware requirement, not the "number of databases" which has almost no bearing on your hardware choices. The "not for too long" here is the lack of types in the tables. You obviously know the problem with that. Just don't go around in a small startup company telling people you need more hardware, or it will be you that's not around for too long. Tell them how to run all those databases on a cheaper server and get better performance out of it... and they'll give you a raise. Shouldn't be too much trouble to improve things, given where you're starting from.
"Quality Software since 1983!"
http://www.smoothjazzy.com/ - see the "Programming" section for freeware tools and articles.In this case there is. My application had to do a cross-database query just to get user rights. This client only has one application, which uses all seven databases. I suspect they were all imported from Access at different times, without the benefit of qualified consultants like they have now.
-
In this case there is. My application had to do a cross-database query just to get user rights. This client only has one application, which uses all seven databases. I suspect they were all imported from Access at different times, without the benefit of qualified consultants like they have now.
I just see big dollar signs in a situation like that :)
"Quality Software since 1983!"
http://www.smoothjazzy.com/ - see the "Programming" section for freeware tools and articles. -
I just see big dollar signs in a situation like that :)
"Quality Software since 1983!"
http://www.smoothjazzy.com/ - see the "Programming" section for freeware tools and articles.Yes, me too, just barely visible over the horizon, but approaching :)
"A little learning is a dangerous thing; drink deep, or taste not the Pierian spring: there shallow draughts intoxicate the brain, and drinking largely sobers us again.", by Alexander Pope My Blog
-
I've just stopped smoking and drinking at the same time, I'm working on abominable VB6 and VBA code between Acess and SQL Server, so I took on a little job for extra money, and I've just received the script for the table I am to code a front end for. Field names have been changed to preserve confidentiality. The one redeeming point is that there is no code here, I get to insert fresh, sexy, new C# code. CREATE TABLE "dbo"."clientTable" ( "oneField" varchar(8000), "abotherField" varchar(8000), "andGgain" varchar(8000), "totalOf" varchar(8000), "21fields" varchar(8000), "like" varchar(8000), "this" varchar(8000), ... ... ) GO
-
Mike Dimmick wrote:
(If you smoke and drink at the same time, aren't you in danger of putting your cigarette out?)
Kramer did it.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
I do not know about Brady, but I have two hands. :laugh:
INTP "Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
-
I've just stopped smoking and drinking at the same time, I'm working on abominable VB6 and VBA code between Acess and SQL Server, so I took on a little job for extra money, and I've just received the script for the table I am to code a front end for. Field names have been changed to preserve confidentiality. The one redeeming point is that there is no code here, I get to insert fresh, sexy, new C# code. CREATE TABLE "dbo"."clientTable" ( "oneField" varchar(8000), "abotherField" varchar(8000), "andGgain" varchar(8000), "totalOf" varchar(8000), "21fields" varchar(8000), "like" varchar(8000), "this" varchar(8000), ... ... ) GO
Congrats on quitting! :-D My father did that too, when he decided that he did not like what he saw when looking in the mirror at his local bar. He put down his drink, threw away is cigarettes, and walked home. The last time I tried to seriously quit smoking I discovered exactly how much of a stimulant it was. I was driving to work, 45 minutes at the time, and drove off the side of the road. It turns out my coffee was not the only thing waking me up. As for drinking, my grandfather drank until his death at 92 and I expect to be doing the same; the drinking part, not the reaching 92 part. :laugh:
INTP "Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
-
Congrats on quitting! :-D My father did that too, when he decided that he did not like what he saw when looking in the mirror at his local bar. He put down his drink, threw away is cigarettes, and walked home. The last time I tried to seriously quit smoking I discovered exactly how much of a stimulant it was. I was driving to work, 45 minutes at the time, and drove off the side of the road. It turns out my coffee was not the only thing waking me up. As for drinking, my grandfather drank until his death at 92 and I expect to be doing the same; the drinking part, not the reaching 92 part. :laugh:
INTP "Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
Thanks, but I haven't quit yet, I've only started quitting. The drinking is only for a break, to give my poor body some rest. I was getting into a risky situation of drinking every night, to soften the ravages felt from the previous night. Then on weekends, Friday night made having more than a few beers on Saturday inevitable, and so on, and Monday mornings were just not good. The cigarettes I hope to see the end of permanently. I have stopped smoking before, for up to two years, and then the demon weed insidiously crept back into my life. I casual smoke here or there over a beer etc. but then I was much younger, and now that I'm 37 I feel it's time to really get rid of that poison.
-
Thanks, but I haven't quit yet, I've only started quitting. The drinking is only for a break, to give my poor body some rest. I was getting into a risky situation of drinking every night, to soften the ravages felt from the previous night. Then on weekends, Friday night made having more than a few beers on Saturday inevitable, and so on, and Monday mornings were just not good. The cigarettes I hope to see the end of permanently. I have stopped smoking before, for up to two years, and then the demon weed insidiously crept back into my life. I casual smoke here or there over a beer etc. but then I was much younger, and now that I'm 37 I feel it's time to really get rid of that poison.
Smart, very smart, sounds similar to my story. Quit smoking for 2 years and then started back up to piss someone off, my Ex. At 37 I was still playing pool and drinking every night for hours, but I was no longer enjoying that. I still like my glass of bourbon or some beer in the evenings, but rarely go out any more because I fall back into the old pattern and tend to stay tell closing. Suggestion: Take up running or long vigorous walks, during either and afterwards you normally do not want a smoke. It also gives you time to think without any distractions or you can just observe the world around, very relaxing if you ignore the garbage people leave along the roads and paths. Good Luck!
INTP "Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra