October 21, 2014 at 7:01 am
spaghettidba (10/21/2014)
Hi!It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I want to start again.
I've been very busy during the last two years and something had to go.
Now that I'm back, I'm glad to see that the same good people are still the soul of this community.
However, I'm a bit scared of the quality of the questions, which seem to have turned even worse (to go back to the original topic of THE thread).
I'm even more scared about the extreme slowness of the site. It's nearly unusable as it is.
Is it just me or does it load slowly for everyone?
Welcome back!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 7:35 am
spaghettidba (10/21/2014)
Hi!It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I want to start again.
I've been very busy during the last two years and something had to go.
Now that I'm back, I'm glad to see that the same good people are still the soul of this community.
Good to see you back.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 21, 2014 at 7:42 am
Thanks Ed, Koen and Jason.
It feels good to be back 🙂
-- Gianluca Sartori
October 21, 2014 at 7:59 am
spaghettidba (10/21/2014)
Thanks Ed, Koen and Jason.It feels good to be back 🙂
Welcome back!!! Been quite a long time.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 21, 2014 at 8:04 am
spaghettidba (10/21/2014)
Hi!It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I want to start again.
I've been very busy during the last two years and something had to go.
Now that I'm back, I'm glad to see that the same good people are still the soul of this community.
However, I'm a bit scared of the quality of the questions, which seem to have turned even worse (to go back to the original topic of THE thread).
I'm even more scared about the extreme slowness of the site. It's nearly unusable as it is.
Is it just me or does it load slowly for everyone?
I've noticed you are back as we seem to pick the same threads to comment on. I don't know that the quality has gotten worse, I think there are fewer overall posts and most of the posts are by people who have very little understanding of or experience with SQL Server.
I've found that the slowness is pretty random. Some things are the same always and others like posting can be fast or slow and I haven't seen a pattern. The slowest thing I've seen has been loading posts from the link in notification emails.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 21, 2014 at 8:22 am
Lynn Pettis (10/20/2014)
I thought there was a forum for the Redgate tools but I can't seem to find it.What I was looking for was if there is a command line tool to convert a Redgate Backup file to a native SQL backup file. We use SQL Backup on our production servers but we don't always have Redgate Backup available to restore the backups to test VMs that we spin up at various times.
Not here.
But here: http://documentation.red-gate.com/display/SBU7/SQL+Backup+File+Converter
October 21, 2014 at 8:24 am
Good for you, Lynn. You coming back to the Springs, I assume?
October 21, 2014 at 8:26 am
Sean Lange (10/21/2014)
spaghettidba (10/21/2014)
Thanks Ed, Koen and Jason.It feels good to be back 🙂
Welcome back!!! Been quite a long time.
Thanks Sean
-- Gianluca Sartori
October 21, 2014 at 8:27 am
spaghettidba (10/21/2014)
Hi!It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I want to start again.
I've been very busy during the last two years and something had to go.
Now that I'm back, I'm glad to see that the same good people are still the soul of this community.
However, I'm a bit scared of the quality of the questions, which seem to have turned even worse (to go back to the original topic of THE thread).
I'm even more scared about the extreme slowness of the site. It's nearly unusable as it is.
Is it just me or does it load slowly for everyone?
Welcome back, ol' friend. The Force didn't feel right without you!
As to the quality of the questions and the problems presented, I've found that they represent what I've found in real life, as well. The economy here in the U.S. has gotten better and there's a real talent shortage, so many companies are hiring on an "if you show up for the interview, you have a job" basis. It's not yet as bad as the dot-com boom of the '90s but it's really sad because companies really need some high quality people that actually do understand data even in a NoSQL environment and they're not getting it. Instead, many people are now convinced that a database is just a place to store data.
I've just reviewed a brand new database made by a 3rd party vendor that we've hired. The BatchID column appears as an INT, an NVARCHAR(10), and an NVARCHAR(50) depending on what table you're in. The BatchID column also contains the same values as the BatchNumber column in other tables which is also the same as the Batch column in still other tables. One table has a single column index on every column and more than half the tables have no PK, clustered index, or even a unique index. When I made suggestions to change them all, the lead "developer" (lower case and in quotes for a reason) responded as follows...
I’m also not entirely sure I agree that every table needs to have a clustered PK (cross tables wouldn’t for example) nor would we always want to use the database to enforce referential integrity – sometimes we do this in the code instead of relying on the database. Sometimes we do things that aren’t perfect according to the way SQL server works simply because it doesn’t work the same in other DMBS systems, so we have to use the least common denominator.
Note that I included that the PK does NOT have to be the clustered index in my suggestions and gave some guidance on what would make a good clustered index.
This is also another reason why I say true portability is a myth.
Like Red Adair used to say, "[font="Arial Black"]If you think it's expensive to hire a professional to do the job, wait until you hire an amateur[/font]."
--Jeff Moden
Change is inevitable... Change for the better is not.
October 21, 2014 at 8:29 am
Jack Corbett (10/21/2014)
I think there are fewer overall posts and most of the posts are by people who have very little understanding of or experience with SQL Server.
Yes, I observed the same thing. I don't know why there are fewer posts. I don't think it is due to less people working with SQL Server. Maybe they're going elsewhere (ask.sqlservercentral? DBA.stackexchange? #sqlhelp?) . Probably Steve has an answer for that.
The slowest thing I've seen has been loading posts from the link in notification emails.
Same thing here.
-- Gianluca Sartori
October 21, 2014 at 8:32 am
spaghettidba (10/21/2014)
Jack Corbett (10/21/2014)
I think there are fewer overall posts and most of the posts are by people who have very little understanding of or experience with SQL Server.Yes, I observed the same thing. I don't know why there are fewer posts. I don't think it is due to less people working with SQL Server. Maybe they're going elsewhere (ask.sqlservercentral? DBA.stackexchange? #sqlhelp?) . Probably Steve has an answer for that.
The slowest thing I've seen has been loading posts from the link in notification emails.
Same thing here.
It's been a trend overall in many SQL sites that there are less questions. Maybe a change in attitudes or knowledge? More blogs found in searches? Not sure, but certainly it's disconcerting for me since I may have to go work for a living again.
Slowness is something here. We had some resource issues with networking at the ISP, and then implemented SPAM, which I think slows the post of answers. Looking at it, but I can't spend time on it until next week.
and welcome back, Gianluca.
October 21, 2014 at 8:37 am
Jeff Moden (10/21/2014)
The BatchID column appears as an INT, an NVARCHAR(10), and an NVARCHAR(50) depending on what table you're in.
Jeff, I don't remember creating a login for you on my server! Yet somehow, you must be there. 😉 Remember our conversation about 2.9 quintillion implicit casts and run time of 92 seconds reduced to 1.5 seconds?
Jeff Moden (10/21/2014)
Like Red Adair used to say, "[font="Arial Black"]If you think it's expensive to hire a professional to do the job, wait until you hire an amateur[/font]."
That quote is priceless.
October 21, 2014 at 8:39 am
Jeff Moden (10/21/2014)
Welcome back, ol' friend. The Force didn't feel right without you!
Thanks Jeff!
As to the quality of the questions and the problems presented, I've found that they represent what I've found in real life, as well. The economy here in the U.S. has gotten better and there's a real talent shortage, so many companies are hiring on an "if you show up for the interview, you have a job" basis. It's not yet as bad as the dot-com boom of the '90s but it's really sad because companies really need some high quality people that actually do understand data even in a NoSQL environment and they're not getting it. Instead, many people are now convinced that a database is just a place to store data.
I wish Italy had the same kind of problems... 🙁
I've just reviewed a brand new database made by a 3rd party vendor that we've hired. The BatchID column appears as an INT, an NVARCHAR(10), and an NVARCHAR(50) depending on what table you're in. The BatchID column also contains the same values as the BatchNumber column in other tables which is also the same as the Batch column in still other tables. One table has a single column index on every column and more than half the tables have no PK, clustered index, or even a unique index. When I made suggestions to change them all, the lead "developer" (lower case and in quotes for a reason) responded as follows...
I’m also not entirely sure I agree that every table needs to have a clustered PK (cross tables wouldn’t for example) nor would we always want to use the database to enforce referential integrity – sometimes we do this in the code instead of relying on the database. Sometimes we do things that aren’t perfect according to the way SQL server works simply because it doesn’t work the same in other DMBS systems, so we have to use the least common denominator.
Note that I included that the PK does NOT have to be the clustered index in my suggestions and gave some guidance on what would make a good clustered index.
This is also another reason why I say true portability is a myth.
Like Red Adair used to say, "[font="Arial Black"]If you think it's expensive to hire a professional to do the job, wait until you hire an amateur[/font]."
OMG!
Well, to be fair, I've always been seeing this kind of issues with database design from ISVs, no matter whether the economy was on a high or low.
-- Gianluca Sartori
October 21, 2014 at 8:41 am
Steve Jones - SSC Editor (10/21/2014)
More blogs found in searches? Not sure, but certainly it's disconcerting for me since I may have to go work for a living again.
Not my blog for sure. I'm glad it's not my fault 🙂
and welcome back, Gianluca.
Thanks!
-- Gianluca Sartori
October 21, 2014 at 8:42 am
Gianluca, where are you located in Italy?
Viewing 15 posts - 46,171 through 46,185 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply