MS SQL server licensing

semaphore said:
The fact that management studio is limited and the fact that it takes forever to load. But its cool, believe what you want. I use superior tools.
Click to expand...
You always use superior tools. If anyone uses something you don't, then it's crap.

Are you running on a P4? Can't understand what this long load time is you refer to. But it happens to you so suppose it must be the same for everyone?

Get over yourself man. You must be a real ball ache to work with.

Suffer from the God complex much?
 
Mike Smit said:
You always use superior tools. If anyone uses something you don't, then it's crap.

Are you running on a P4? Can't understand what this long load time is you refer to. But it happens to you so suppose it must be the same for everyone?

Get over yourself man. You must be a real ball ache to work with.

Suffer from the God complex much?
Click to expand...

Lol. Yeah must be my celeron processor. I'm entitled to my opinion of said crap software, even Arietans agree's, version 2005 was okay, I have no idea WTF they did to 2012 (might be because its bootstrapped with visual studio 2010, cant recall if they did that in 2005) because it just destroys any form of power you have left on your workstation. Even loads slowly on our server with 64gig of ram, but yeah must just be me. :erm:

No god complex, just stating there are far better management apps out there than that garbage microsoft released. I work with people that have a higher than average intelligence, so i rarely find myself having to hold anyone's hand.
 
Last edited:
semaphore said:
Lol. Yeah must be my celeron processor. I'm entitled to my opinion of said crap software, even Arietans agree's, version 2005 was okay, I have no idea WTF they did to 2012 because it just destroys any form of power you have left on your workstation. Even loads slowly on our server with 64gig of ram, but yeah must just be me. :erm:

No god complex, just stating there are far better management apps out there than that garbage microsoft released. I work with people that have a higher than average intelligence, so i rarely find myself having to hold anyone's hand.
Click to expand...
I have no problem with superior tools. Just disclose why you think they are. Completes your statement.

You burst in putting xyz down, and leave. I would honestly have a look if you had suggestions as I am always open to a better way of doing things, but you tend to rather put down others choices without offering an alternative.
Does not speak well to me.
 
semaphore said:
Lol. Yeah must be my celeron processor. I'm entitled to my opinion of said crap software, even Arietans agree's, version 2005 was okay, I have no idea WTF they did to 2012 (might be because its bootstrapped with visual studio 2010, cant recall if they did that in 2005) because it just destroys any form of power you have left on your workstation. Even loads slowly on our server with 64gig of ram, but yeah must just be me. :erm:

No god complex, just stating there are far better management apps out there than that garbage microsoft released. I work with people that have a higher than average intelligence, so i rarely find myself having to hold anyone's hand.
Click to expand...

I haven't used any other db tools for MS SQL because I haven't really felt the need to... so I am not going to comment on Management Studio vs the others.

What I am going to say however is that I thought your comment regarding load times was strange.. well because I haven't really noticed it being slow. So I timed it now... 5 seconds from click to full render. Am I missing something? I don't consider that slow by any standard. I'd wager that the other tools as long if not longer to load. But to be fair, any load time less than 10 seconds would be acceptable for me.
 
Last edited:
Mike Smit said:
I have no problem with superior tools. Just disclose why you think they are. Completes your statement.

You burst in putting xyz down, and leave. I would honestly have a look if you had suggestions as I am always open to a better way of doing things, but you tend to rather put down others choices without offering an alternative.
Does not speak well to me.
Click to expand...

I offered alternatives, perhaps look at the top of the page. I expressed why management studio is crap. I would agree its my hardware, if it didn't take 20 seconds to load on a server with 32 processors. Where others did not.

I find ms management studio lackluster in performance, functionality and database support. You are stuck with one database. If you're using only MS SQL then i guess its okay, if it doesnt take 30+ seconds to load cool. But other tools support close to all the databases out there and load in a fraction of the time. Yes some of them cost money, but you get what you pay for.
 
shogun said:
What I am going to say however is that I thought your comment regarding load times was strange.. well because I haven't really noticed it being slow. So I timed it now... 5 seconds from click to full render. Am I missing something? I don't consider that slow by any standard. I'd wager that the other tools as long if not longer to load. But to be fair, any load time less than 10 seconds would be acceptable for me.
Click to expand...

What version are you using?
 
semaphore said:
I offered alternatives, perhaps look at the top of the page. I expressed why management studio is crap. I would agree its my hardware, if it didn't take 20 seconds to load on a server with 32 processors. Where others did not.

I find ms management studio lackluster in performance, functionality and database support. You are stuck with one database. If you're using only MS SQL then i guess its okay, if it doesnt take 30+ seconds to load cool. But other tools support close to all the databases out there and load in a fraction of the time. Yes some of them cost money, but you get what you pay for.
Click to expand...
Opened Management Studio on my XPS 15 now. From click to login screen was 3.5 seconds. Login was another second or so after clicking Connect. You got something else wrong.

And yes - we are a MS house and that includes SQL Server. I have worked with MS SQL daily for the last 16 years and see no reason to change it - or its tools - right now. If you think there is better, I will look and see if it suits my purposes. But to outright tell people their choices are crap is just not cool.

Besides, throw in integration services, analysis services and reporting services and you got quite a powerful tool set available to you. Unfortunately not all available in the express edition.
 
Mike Smit said:
Opened Management Studio on my XPS 15 now. From click to login screen was 3.5 seconds. Login was another second or so after clicking Connect. You got something else wrong.
Click to expand...

Version?

And yes - we are a MS house and that includes SQL Server. I have worked with MS SQL daily for the last 16 years and see no reason to change it - or its tools - right now. If you think there is better, I will look and see if it suits my purposes. But to outright tell people their choices are crap is just not cool.
Click to expand...

I never said the database is ****, just the management tool. I've used MS SQL for close to 12 years, last 5 have been postgres, will never turn back again.

Besides, throw in integration services, analysis services and reporting services and you got quite a powerful tool set available to you. Unfortunately not all available in the express edition.
Click to expand...

Use neither of those, perhaps reporting services once, but we have our own internal reporting engine.


Point being, if its a small dev house or budget constraints postgres is a perfectly good option. We have over 190 branches with millions of records in it. Does not even bat an eye lid.
 
Last edited:
semaphore said:
Version?



I never said the database is ****, just the management tool. I've used MS SQL for close to 12 years, last 5 have been postgres, will never turn back again.



Use neither of those, perhaps reporting services once, but we have our own internal reporting engine.
Click to expand...

2012 was 3.5. Just tried 2008 R2 and was under 2 seconds.

And Ye - I get you are talking management studio. Me too. Just added in the bit extra for fluff.
 
Mike Smit said:
2012 was 3.5. Just tried 2008 R2 and was under 2 seconds.

And Ye - I get you are talking management studio. Me too. Just added in the bit extra for fluff.
Click to expand...

Don't have it installed anymore so can't check. Pg Admin loaded to fast i couldnt time it :P
 
Mike Smit said:
I am going to bite and check out Postgre. I looked years ago but it never bit. Worth another look I suppose.

BTW : You just splitting hairs now.
Click to expand...

Its not beneficial if you're heavily invested in those integration and reporting services.
 
Never had an issue with SQL Management Studio or Visual Studio, but then I've had SSD drives since they first came out and it's replaced by a newer and faster one every year.
 
Mike Smit said:
Besides, throw in integration services, analysis services and reporting services and you got quite a powerful tool set available to you. Unfortunately not all available in the express edition.
Click to expand...
SSRS is there but personally I prefer the less bulky active query builder.
 
semaphore said:
Its not beneficial if you're heavily invested in those integration and reporting services.
Click to expand...

There are plenty alternatives for BI and ETL, that's where I'd rather spend my money personally.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X