SQL Server Rant
-
Marc Clifton wrote: Tools are great. It's great having the power and control that EM provides. But what the tool doesn't do is tell you how you should use it. Noooo! Don't you dare back down on this! You were right the first time, it is excessively, overly complex for a modern software product.
SPCA--we're here to inquire about the health of Dr. Schroedinger's catJohn Cardinal wrote: You were right the first time, it is excessively, overly complex for a modern software product. While I grant you that it could be improved for the smaller databases, having just finished a 2 year project dealing with 1500 tables, 400K lines of C++ code and 800 GB of storage I want the control to be able to tune the product to the nth degree. What holds true for a 10MB database doesn't hold true for a 1TB database. But just talking about the tool, I've gotten to the point where I don't use SEM because I know the specific information I want and don't need or want all that GUI getting in the way of the information I seek.
-
Oh, I absolutely do know what is going on behind the scenes Terry. I've used T-SQL for years and years. Sure it's easy to go from building your Model T to buying one off the lot and thinking to yourself "Gee, all I have to do is turn this crank and release this hand brake and away I go". But surely there comes a day when that Model T becomes a Honda Civic? ;)
SPCA--we're here to inquire about the health of Dr. Schroedinger's catFunny you should mention building a Model T because I'm building one in my shop. :D Making a streetrod out of a 1926 Model T Tudor Sedan.
-
Anders Molin wrote: C++ lets you do all the dangerous stuff, The compiler, as a tool, tries its hardest to protect you from doing stupid things though. If I say: if (a=b) ... I get a warning about an assignment. if I say: double d=5.0; int a=d; I get a warning about precision loss. If I say: double d; int a=d; I get a warning about an unassigned variable being used. That's what I mean about the tool doing something HELPFUL! An this isn't just naive programmer problems--these warnings exist because people make mistakes and typos. All I'm saying that EM could go a lot further in providing warnings, to use your analogy, like the way the C++ compiler does. Anders Molin wrote: So... You are using the handholding VB of SQL-Server admins The functionality is almost identical, in a much better designed application. And something that SQL Server is STILL missing, after all these years, is the SEQUENCE feature, that Oracle has. Not having that ability in SQL Server can be very annoying at times. Marc Latest AAL Article My blog Join my forum!
Well Marc, Some programmer I know told me he spent 2 days debugging a
for (int i = 0; i < 20; i++);
Thats the kind of stuff I mean. Or something like this
int i[10]
//fill some values into i here
int *c = i;
for (int k = 0; k < 20; k++)
{
SomeFunction(*(c++));
}Compiles fine, and works fine, but suddenly, bang, application crashed because of a overwrite. Thats the kind of things I was talking about... - Anders Money talks, but all mine ever says is "Goodbye!" My Photos[^]
-
Funny you should mention building a Model T because I'm building one in my shop. :D Making a streetrod out of a 1926 Model T Tudor Sedan.
-
Michael A. Barnhart wrote: Sounds like a great start for a new article. Lessons learned --> SQL server for programmers. Yeah. I certainly learned my lesson. When adopting a new technology (we've been using an Access DB for years on this product and never had these kind of problems, of course we had other problems), anyways, when adopting a new technology, search for "Lessons Learned" on the Internet first! Marc Latest AAL Article My blog Join my forum!
Marc Clifton wrote: when adopting a new technology, search for "Lessons Learned" on the Internet first! Or take a quick course on SQL Administration or possibly browse a book on the topic ;) I think when people move to SQL Server they have been working with MS Access or some form of ODBC and find that things are much different in the server world. The first time you boot up Enterprise manager looking for your forms or query tabs and wonder how to get to the data ;) And I think that log size limit problem has hit about everyone. You automatically take it that setting the size means it will compress and not go over that amount, not that it is going to fill your event log with the fact the db log is now over the limit! Other things are ahead of you :-D A couple quick resources: http://www.sqlmag.com/[^] http://sqlservercentral.com[^] There is one more that I use more often but the url escapes me at the moment :-O Rocky <>< www.HintsAndTips.com
-
[rant] OK, I'll face it. I don't know what I'm doing. Maybe that's the real problem. Installed SQL Server at a client beta test site (thank goodness for that!), a couple weeks go by, and I discover that the log file has eaten up about 15 GIGABYTES of disk space. Was I doing backups? Of course! Was I doing backups of the TRANSACTION LOG? No. I didn't know I needed to. Backed up the database and reset the log file to 2MB, then set the log file backup schedule too. Customer calls this morning at 3AM (this is a live beta test site). They can't record anymore transactions because the log file is full. What? There it is, at 2MB. So, the log file that was growing astronomically, is now NOT growing. WTF? The "grow log file" checkbox is UNCHECKED! I didn't uncheck it! So how was it growing to begin with? And why, if I set a hard limit for the transaction log file, doesn't it just start dumping old transactions? What's the point of a hard limit if it throws its hands up in the air and gives up when it gets full? This product should CLEARLY WARN YOU of certain configurations that will lead to DISASTER. It should install with a configuration that DOES NOT CAUSE DISASTER weeks or months down the road. Got that, Microsoft? (I know, I know, it's my fault, I'm the one to blame for not knowing what I was doing.) Now I guess I'll read about how to properly install and configure SQL Server. I guess this is why DB admins can charge $150/hr. And while I'm in a ranting mood, why is the backup and restore procedure so complicated? I mean, I have to go through 5 levels (or so) of "advanced this", "advanced that" just to specify the friggin' file that I want restored!!! Some of you (yes, you know who you are) have said that the Enterprise Manager is a great tool. I think it's terrible. It's slow, awkward, and not user friendly. In fact, after working with Vale's MSDE Manager[^], I'm beginning to like it A LOT MORE than EM (except for that annoying licensing process). Maybe I'm just weak-willed. Maybe I'm not a "power user" and I just want a simple GUI to get a simple job done, like restoring a database to a different physical file without going through 10 dialogs. Maybe EM is too complicated for my simple mind. Maybe I need to raise my rates. [/rant] Marc Latest AAL Article
Well, as far as mainstream database go, SQL Server is still easier to get started with from scratch than DB2 or Oracle. I used one of the test boxes at work, which I knew SQL Server worked on happily, to do some trials with. I got DB2 to install, but I was buggered if I could figure out stored procedures at all. I think I needed to install a C compiler, and then do some voodoo. Oracle (9i) installed too, but I creating a database seemed to take a while. So I left it overnight. It had crashed by the following morning, having reached about 30%..... And after the shoddy, slow, crap (and Java) admin tools you get shipped with both of those databases, you'll welcome Enterprise Manager with open arms :-) -- Ian Darling "The different versions of the UN*X brand operating system are numbered in a logical sequence: 5, 6, 7, 2, 2.9, 3, 4.0, III, 4.1, V, 4.2, V.2, and 4.3" - Alan Filipski
-
Well, as far as mainstream database go, SQL Server is still easier to get started with from scratch than DB2 or Oracle. I used one of the test boxes at work, which I knew SQL Server worked on happily, to do some trials with. I got DB2 to install, but I was buggered if I could figure out stored procedures at all. I think I needed to install a C compiler, and then do some voodoo. Oracle (9i) installed too, but I creating a database seemed to take a while. So I left it overnight. It had crashed by the following morning, having reached about 30%..... And after the shoddy, slow, crap (and Java) admin tools you get shipped with both of those databases, you'll welcome Enterprise Manager with open arms :-) -- Ian Darling "The different versions of the UN*X brand operating system are numbered in a logical sequence: 5, 6, 7, 2, 2.9, 3, 4.0, III, 4.1, V, 4.2, V.2, and 4.3" - Alan Filipski
Ian Darling wrote: Oracle (9i) installed too, but I creating a database seemed to take a while. Yeah, Oracle really lost it with version 9. 7i and 8i were great. Then they turned Java. Ugh. Ian Darling wrote: And after the shoddy, slow, crap (and Java) admin tools you get shipped with both of those databases, you'll welcome Enterprise Manager with open arms True. I guess I should count my blessings, and while I'm at it, not criticize the mote in someone else's eye when I've got a plank in my own. Ah well. I guess I was in a ranting mood. Still, I feel like MS could really have made the EM shine. It's like the adage about "first impressions". It doesn't make a good first impression. Marc Latest AAL Article My blog Join my forum!
-
[rant] OK, I'll face it. I don't know what I'm doing. Maybe that's the real problem. Installed SQL Server at a client beta test site (thank goodness for that!), a couple weeks go by, and I discover that the log file has eaten up about 15 GIGABYTES of disk space. Was I doing backups? Of course! Was I doing backups of the TRANSACTION LOG? No. I didn't know I needed to. Backed up the database and reset the log file to 2MB, then set the log file backup schedule too. Customer calls this morning at 3AM (this is a live beta test site). They can't record anymore transactions because the log file is full. What? There it is, at 2MB. So, the log file that was growing astronomically, is now NOT growing. WTF? The "grow log file" checkbox is UNCHECKED! I didn't uncheck it! So how was it growing to begin with? And why, if I set a hard limit for the transaction log file, doesn't it just start dumping old transactions? What's the point of a hard limit if it throws its hands up in the air and gives up when it gets full? This product should CLEARLY WARN YOU of certain configurations that will lead to DISASTER. It should install with a configuration that DOES NOT CAUSE DISASTER weeks or months down the road. Got that, Microsoft? (I know, I know, it's my fault, I'm the one to blame for not knowing what I was doing.) Now I guess I'll read about how to properly install and configure SQL Server. I guess this is why DB admins can charge $150/hr. And while I'm in a ranting mood, why is the backup and restore procedure so complicated? I mean, I have to go through 5 levels (or so) of "advanced this", "advanced that" just to specify the friggin' file that I want restored!!! Some of you (yes, you know who you are) have said that the Enterprise Manager is a great tool. I think it's terrible. It's slow, awkward, and not user friendly. In fact, after working with Vale's MSDE Manager[^], I'm beginning to like it A LOT MORE than EM (except for that annoying licensing process). Maybe I'm just weak-willed. Maybe I'm not a "power user" and I just want a simple GUI to get a simple job done, like restoring a database to a different physical file without going through 10 dialogs. Maybe EM is too complicated for my simple mind. Maybe I need to raise my rates. [/rant] Marc Latest AAL Article
I generally agree with you that Enterprise Manager is not that great (the backup/restore stuff is a pain in the !#$#). SQL Server, however, is IMHO, the easiest "real" database to install, setup and manage of all the "real" database contenders. I have worked with DB2, Oracle, Informix and several others that don't deserve a mention. DB2 is faster, but is much harder to configure and manage. Both DB2 and Oracle use awfull Java based tools that make Enterpise Manager look like the fastest, sleekest car on the planet. One serious question, though...What are you doing that generated 15GB of transaction log in a couple weeks that was being done with Access? I know many apps that can generate a log file like that, but none that could possibly run with Access. So seriously, what kind of app is it?
-
I generally agree with you that Enterprise Manager is not that great (the backup/restore stuff is a pain in the !#$#). SQL Server, however, is IMHO, the easiest "real" database to install, setup and manage of all the "real" database contenders. I have worked with DB2, Oracle, Informix and several others that don't deserve a mention. DB2 is faster, but is much harder to configure and manage. Both DB2 and Oracle use awfull Java based tools that make Enterpise Manager look like the fastest, sleekest car on the planet. One serious question, though...What are you doing that generated 15GB of transaction log in a couple weeks that was being done with Access? I know many apps that can generate a log file like that, but none that could possibly run with Access. So seriously, what kind of app is it?
Matt Gullett wrote: So seriously, what kind of app is it? Erm. This is the lounge. It's my club (*wink*) management software. While there's a lot of transactions going on, the majority of the "interaction" with the DB is managing state/status with updates. And when a club rakes in $120,000 to $200,000 a month, that's a lot of account updates. (two weeks was a bit of an exaggeration, come to think of it. But not by much...) Marc Latest AAL Article My blog Join my forum!
-
DBX-based databases. Trust me. :) -- Try walking in my shoes. You stumble in my footsteps.
...with non-standard indexfiles. AMEN brother :) And if the paths that I have followed/have tread against the flow/there is no need for sorrow I am coming home Return, Crüxshadows
-
Matt Gullett wrote: So seriously, what kind of app is it? Erm. This is the lounge. It's my club (*wink*) management software. While there's a lot of transactions going on, the majority of the "interaction" with the DB is managing state/status with updates. And when a club rakes in $120,000 to $200,000 a month, that's a lot of account updates. (two weeks was a bit of an exaggeration, come to think of it. But not by much...) Marc Latest AAL Article My blog Join my forum!
Having worked on a site that had > 1,000,000 unique users per week, I have a few suggestions. You might want to move to a more decentralized state management system. .net makes it really easy to create an encrypted cookie for managing state data. At the very least you can make sure you use a seperate state management database with the lowest transaction settings that SQL allows. -Andy Brummer
-
Having worked on a site that had > 1,000,000 unique users per week, I have a few suggestions. You might want to move to a more decentralized state management system. .net makes it really easy to create an encrypted cookie for managing state data. At the very least you can make sure you use a seperate state management database with the lowest transaction settings that SQL allows. -Andy Brummer
andy brummer wrote: .net makes it really easy to create an encrypted cookie Well, this isn't a .NET application, and it's not a web-based application. It's a straight forward C++ app in a client-server configuration. But thanks anyways--good advice for when I get into web-based development! Marc Latest AAL Article My blog Join my forum!
-
[rant] OK, I'll face it. I don't know what I'm doing. Maybe that's the real problem. Installed SQL Server at a client beta test site (thank goodness for that!), a couple weeks go by, and I discover that the log file has eaten up about 15 GIGABYTES of disk space. Was I doing backups? Of course! Was I doing backups of the TRANSACTION LOG? No. I didn't know I needed to. Backed up the database and reset the log file to 2MB, then set the log file backup schedule too. Customer calls this morning at 3AM (this is a live beta test site). They can't record anymore transactions because the log file is full. What? There it is, at 2MB. So, the log file that was growing astronomically, is now NOT growing. WTF? The "grow log file" checkbox is UNCHECKED! I didn't uncheck it! So how was it growing to begin with? And why, if I set a hard limit for the transaction log file, doesn't it just start dumping old transactions? What's the point of a hard limit if it throws its hands up in the air and gives up when it gets full? This product should CLEARLY WARN YOU of certain configurations that will lead to DISASTER. It should install with a configuration that DOES NOT CAUSE DISASTER weeks or months down the road. Got that, Microsoft? (I know, I know, it's my fault, I'm the one to blame for not knowing what I was doing.) Now I guess I'll read about how to properly install and configure SQL Server. I guess this is why DB admins can charge $150/hr. And while I'm in a ranting mood, why is the backup and restore procedure so complicated? I mean, I have to go through 5 levels (or so) of "advanced this", "advanced that" just to specify the friggin' file that I want restored!!! Some of you (yes, you know who you are) have said that the Enterprise Manager is a great tool. I think it's terrible. It's slow, awkward, and not user friendly. In fact, after working with Vale's MSDE Manager[^], I'm beginning to like it A LOT MORE than EM (except for that annoying licensing process). Maybe I'm just weak-willed. Maybe I'm not a "power user" and I just want a simple GUI to get a simple job done, like restoring a database to a different physical file without going through 10 dialogs. Maybe EM is too complicated for my simple mind. Maybe I need to raise my rates. [/rant] Marc Latest AAL Article
Ahhh... SQL Sever made it so simple to use a database that almost anyone can use it now, but it still has some traces of the old Sybase code... Try installing Oracle and applying the latest set of patches. Yes, just it. You'll understand what I mean. Trying to make bits uncopyable is like trying to make water not wet. -- Bruce Schneier By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
-
Ahhh... SQL Sever made it so simple to use a database that almost anyone can use it now, but it still has some traces of the old Sybase code... Try installing Oracle and applying the latest set of patches. Yes, just it. You'll understand what I mean. Trying to make bits uncopyable is like trying to make water not wet. -- Bruce Schneier By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
Daniel Turini wrote: Ahhh... SQL Sever made it so simple to use a database that almost anyone can use it now, but it still has some traces of the old Sybase code... Sort of in the same way that anyone can get into an SUV, turn the key, and start "driving". Look out! Daniel Turini wrote: Try installing Oracle and applying the latest set of patches. lol! I imagine it's pretty awful. Marc Latest AAL Article My blog Join my forum!