August 5, 2015 at 7:30 am
WayneS (8/5/2015)
dwain.c (8/4/2015)
SQLRNNR (8/4/2015)
WayneS (8/4/2015)
Sean Lange (8/4/2015)
yb751 (8/4/2015)
Raise your hands if you like Entity Framework...then I'll know who to shoot!Sorry just needed two seconds to vent. :crazy:
I'm sure like anything else it can be fine when implemented properly. Problem is the devs here had carte blanche long before I showed up and I'm feeling the pain. Troubleshooting performance problems with those statements are a HUGE pain!
</rant>
I know just enough about EF to totally despise it. One of our previous developers brought a "query" to my desk once that EF wrote for them. They used profiler to get the actual query and confirmed it did in fact return the correct results. He knew I am pretty savvy at finding ways of scraping performance out of queries so he asked me to look at it and see if I could "work my magic" on it. This thing was nearly 800 lines and had over 100 subqueries (many of them nested 7-10 layers deep).
I told him that I would be happy to fix it for him. I hit Ctrl - N and asked him what the query needs to return. 😛
That's the best way to deal with ORM. Just saying...
Second that notion.
To bastardize a great quote: "ORMs are the root of all evil."
Then there's this: What ORMs have taught me: just learn SQL
My favorite:
ORMs: The fastest way to a slow database.
Heh heh. Thank you for that one, Wayne. I'm going to have to use that with a couple of people I know who just love their ORM. 😉
I keep telling them that I've never seen an ORM generate an efficient query and that there's no substitute for learning SQL, but they insist that ORMs make things so much easier for them. These are the same people who don't understand why their site is having performance problems. Maybe this will have an impact, because nothing else has.
August 5, 2015 at 7:33 am
Eirikur Eiriksson (8/5/2015)
Koen Verbeeck (8/5/2015)
I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the end of the year.You can vote here and karma will be with you if you vote for me as well 😀
+1
😎
+1
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2015 at 7:37 am
WayneS (8/5/2015)
Eirikur Eiriksson (8/5/2015)
Koen Verbeeck (8/5/2015)
I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the end of the year.You can vote here and karma will be with you if you vote for me as well 😀
+1
😎
+1
Voted. I guess my karma can stay with me for another day. 😉
_______________________________________________________________
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/
August 5, 2015 at 7:39 am
Luis Cazares (8/4/2015)
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Steve Jones - SSC Editor (8/4/2015)
Since we're all piling on the behavior of others, I was wondering.Is there value in getting the questions/knowledge that people lack in interviews published? Not really as a cheat sheet, but as a way to surface that knowledge that interviewers think is important. I suspect it would be a long list, so it's unlikely that anyone could just memorize all the answers.
However even if they did, I think they'd be learning.
I was actually thinking to try and collect a list of things from interviewers and put a session together. I meet so many 101 people at events, they might benefit from a session that guides them towards learning a few things first.
You could take a look at this stuff from Wayne.
http://blog.waynesheffield.com/wayne/archive/2012/06/interview-questions/
Okay, I'm hoping he changed is lab after posting that blog. The lab as described would be the easy part. Now, some of the questions he mentioned in the in-person interview, there are a few I may have some difficulty with answering. Guess I need to do some research!
You'd be surprised how many can't survive the lab.
From the description in his blog, it just seems easy to me. Of course I am not in the pressure cooker actually working the lab during an interview process.
I wouldn't mind giving it a shot just to see how I'd do.
The lab might be very easy for the threadizens. I wonder if it extra points would be achieved for going directly to Wayne's article on creating a comma delimited list.
I have to admit that I wouldn't be able to answer some questions.
If you can go directly to that article, without using an internet search, I'd just have to give that question to you.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2015 at 7:43 am
WayneS (8/5/2015)
Luis Cazares (8/4/2015)
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Steve Jones - SSC Editor (8/4/2015)
Since we're all piling on the behavior of others, I was wondering.Is there value in getting the questions/knowledge that people lack in interviews published? Not really as a cheat sheet, but as a way to surface that knowledge that interviewers think is important. I suspect it would be a long list, so it's unlikely that anyone could just memorize all the answers.
However even if they did, I think they'd be learning.
I was actually thinking to try and collect a list of things from interviewers and put a session together. I meet so many 101 people at events, they might benefit from a session that guides them towards learning a few things first.
You could take a look at this stuff from Wayne.
http://blog.waynesheffield.com/wayne/archive/2012/06/interview-questions/
Okay, I'm hoping he changed is lab after posting that blog. The lab as described would be the easy part. Now, some of the questions he mentioned in the in-person interview, there are a few I may have some difficulty with answering. Guess I need to do some research!
You'd be surprised how many can't survive the lab.
From the description in his blog, it just seems easy to me. Of course I am not in the pressure cooker actually working the lab during an interview process.
I wouldn't mind giving it a shot just to see how I'd do.
The lab might be very easy for the threadizens. I wonder if it extra points would be achieved for going directly to Wayne's article on creating a comma delimited list.
I have to admit that I wouldn't be able to answer some questions.
If you can go directly to that article, without using an internet search, I'd just have to give that question to you.
I could do it on 2 clicks if I'm logged in to Chrome. It'll take more steps if that's not available.
Of course, I don't needed anymore, but I keep the bookmark for easy sharing. 😉
August 5, 2015 at 8:22 am
WayneS (8/5/2015)
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Lynn Pettis (8/4/2015)
SQLRNNR (8/4/2015)
Steve Jones - SSC Editor (8/4/2015)
Since we're all piling on the behavior of others, I was wondering.Is there value in getting the questions/knowledge that people lack in interviews published? Not really as a cheat sheet, but as a way to surface that knowledge that interviewers think is important. I suspect it would be a long list, so it's unlikely that anyone could just memorize all the answers.
However even if they did, I think they'd be learning.
I was actually thinking to try and collect a list of things from interviewers and put a session together. I meet so many 101 people at events, they might benefit from a session that guides them towards learning a few things first.
You could take a look at this stuff from Wayne.
http://blog.waynesheffield.com/wayne/archive/2012/06/interview-questions/
Okay, I'm hoping he changed is lab after posting that blog. The lab as described would be the easy part. Now, some of the questions he mentioned in the in-person interview, there are a few I may have some difficulty with answering. Guess I need to do some research!
You'd be surprised how many can't survive the lab.
From the description in his blog, it just seems easy to me. Of course I am not in the pressure cooker actually working the lab during an interview process.
I wouldn't mind giving it a shot just to see how I'd do.
Like I mentioned in the blog, I'm looking for a set-based answer. 99% are a while loop.
And Lynn... I have a special lab, just for you. Want to take it?
Only if I get to do the standard one first. 😀
But of course, anything to challenge myself and sharpen my skills is welcome.
August 5, 2015 at 8:37 am
SQLRNNR (8/4/2015)
Steve Jones - SSC Editor (8/4/2015)
Since we're all piling on the behavior of others, I was wondering.Is there value in getting the questions/knowledge that people lack in interviews published? Not really as a cheat sheet, but as a way to surface that knowledge that interviewers think is important. I suspect it would be a long list, so it's unlikely that anyone could just memorize all the answers.
However even if they did, I think they'd be learning.
I was actually thinking to try and collect a list of things from interviewers and put a session together. I meet so many 101 people at events, they might benefit from a session that guides them towards learning a few things first.
You could take a look at this stuff from Wayne.
http://blog.waynesheffield.com/wayne/archive/2012/06/interview-questions/
I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think I'd pass the lab but I'd use the internet, expecially for the delimited string work. I've done it multiple times, but not regularly enough that I remember how, I just look it up.
I can't believe Wayne used Active/Active and Active/Passive. Allan Hirt would have a aneurysm.
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
August 5, 2015 at 8:42 am
Luis Cazares (8/5/2015)
Eirikur Eiriksson (8/5/2015)
Brandie Tarvin (8/5/2015)
I am shattered, y'all. Just shattered.I'll be in the back of the Tent in the Desert, crying my eyes out for a while.
c'est la vie
😎
I read that it's only a marketing trick to promote their new TV show.
I'm so surprised, one cannot even trust the media any more!:hehe:
😎
August 5, 2015 at 9:09 am
Jack Corbett (8/5/2015)
I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think I'd pass the lab but I'd use the internet, expecially for the delimited string work. I've done it multiple times, but not regularly enough that I remember how, I just look it up.
I'm in the same boat as you with the building a delimited string from multiple rows. I just consult my previous code.
A similar situation applies to date math, which I've tested nearly to death. I do some of the more frequent ones from memory, but I also have Lynn's page[/url] bookmarked when I can't remember one of them. It's one of my most useful pages I keep on hand at all times.
August 5, 2015 at 9:17 am
Ed Wagner (8/5/2015)
Jack Corbett (8/5/2015)
I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think I'd pass the lab but I'd use the internet, expecially for the delimited string work. I've done it multiple times, but not regularly enough that I remember how, I just look it up.I'm in the same boat as you with the building a delimited string from multiple rows. I just consult my previous code.
A similar situation applies to date math, which I've tested nearly to death. I do some of the more frequent ones from memory, but I also have Lynn's page[/url] bookmarked when I can't remember one of them. It's one of my most useful pages I keep on hand at all times.
That one is so useful I created a proc to return the code so I don't even have to open a browser. 😀
_______________________________________________________________
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/
August 5, 2015 at 9:18 am
dwain.c (8/4/2015)
SQLRNNR (8/4/2015)
WayneS (8/4/2015)
Sean Lange (8/4/2015)
yb751 (8/4/2015)
Raise your hands if you like Entity Framework...then I'll know who to shoot!Sorry just needed two seconds to vent. :crazy:
I'm sure like anything else it can be fine when implemented properly. Problem is the devs here had carte blanche long before I showed up and I'm feeling the pain. Troubleshooting performance problems with those statements are a HUGE pain!
</rant>
I know just enough about EF to totally despise it. One of our previous developers brought a "query" to my desk once that EF wrote for them. They used profiler to get the actual query and confirmed it did in fact return the correct results. He knew I am pretty savvy at finding ways of scraping performance out of queries so he asked me to look at it and see if I could "work my magic" on it. This thing was nearly 800 lines and had over 100 subqueries (many of them nested 7-10 layers deep).
I told him that I would be happy to fix it for him. I hit Ctrl - N and asked him what the query needs to return. 😛
That's the best way to deal with ORM. Just saying...
Second that notion.
To bastardize a great quote: "ORMs are the root of all evil."
Then there's this: What ORMs have taught me: just learn SQL
I have heard that very quote.
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
August 5, 2015 at 9:19 am
Jeff Moden (8/4/2015)
SQLRNNR (8/4/2015)
Jeff Moden (8/4/2015)
I think before we get into interview questions, it would be much better to define what a DBA/Developer needs to be, know, and do.I remember a post that someone made several years ago that pretty well had it down pat. I was going to add it to my briefcase but I apparently forgot. IIRC, the post was about job descriptions and what was posted in one of the posts on that thread was just brilliant. I wish I could find it again.
Would it be a post in this article?
THAT would be the one! Great discussion after a great article. Thanks for finding it, Jason!
For those that want to know, the exact post on that thread that I was looking for can be found here.
http://www.sqlservercentral.com/Forums/FindPost1456698.aspx
The article for that discussion thread is also awesome. It's a must read in my book and I'm glad that Jason re-found it for me.
I happened to remember Craig talking about it and I enjoyed that article.
Happy to be of service!
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
August 5, 2015 at 9:23 am
Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Jack Corbett (8/5/2015)
I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think I'd pass the lab but I'd use the internet, expecially for the delimited string work. I've done it multiple times, but not regularly enough that I remember how, I just look it up.I'm in the same boat as you with the building a delimited string from multiple rows. I just consult my previous code.
A similar situation applies to date math, which I've tested nearly to death. I do some of the more frequent ones from memory, but I also have Lynn's page[/url] bookmarked when I can't remember one of them. It's one of my most useful pages I keep on hand at all times.
That one is so useful I created a proc to return the code so I don't even have to open a browser. 😀
Oh, I like that idea!
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
August 5, 2015 at 9:26 am
Jack Corbett (8/5/2015)
SQLRNNR (8/4/2015)
Steve Jones - SSC Editor (8/4/2015)
Since we're all piling on the behavior of others, I was wondering.Is there value in getting the questions/knowledge that people lack in interviews published? Not really as a cheat sheet, but as a way to surface that knowledge that interviewers think is important. I suspect it would be a long list, so it's unlikely that anyone could just memorize all the answers.
However even if they did, I think they'd be learning.
I was actually thinking to try and collect a list of things from interviewers and put a session together. I meet so many 101 people at events, they might benefit from a session that guides them towards learning a few things first.
You could take a look at this stuff from Wayne.
http://blog.waynesheffield.com/wayne/archive/2012/06/interview-questions/
I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think I'd pass the lab but I'd use the internet, expecially for the delimited string work. I've done it multiple times, but not regularly enough that I remember how, I just look it up.
I can't believe Wayne used Active/Active and Active/Passive. Allan Hirt would have a aneurysm.
Maybe they're in quotes for a reason... to see if I'll be corrected on the proper terminology.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 5, 2015 at 9:36 am
SQLRNNR (8/5/2015)
Sean Lange (8/5/2015)
Ed Wagner (8/5/2015)
Jack Corbett (8/5/2015)
I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think I'd pass the lab but I'd use the internet, expecially for the delimited string work. I've done it multiple times, but not regularly enough that I remember how, I just look it up.I'm in the same boat as you with the building a delimited string from multiple rows. I just consult my previous code.
A similar situation applies to date math, which I've tested nearly to death. I do some of the more frequent ones from memory, but I also have Lynn's page[/url] bookmarked when I can't remember one of them. It's one of my most useful pages I keep on hand at all times.
That one is so useful I created a proc to return the code so I don't even have to open a browser. 😀
Oh, I like that idea!
You mean like this? 😉 I pulled it from my dba database. It's sometimes easier to just hit the page.
ALTER procedure [dbo].[CommonDates]
as
BEGIN
SELECT Description, SQL
FROM (VALUES('DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)', 'Beginning of this day'),
('DATEADD(day, DATEDIFF(day, 0, GETDATE()) + 1, 0)', 'Beginning of next day'),
('DATEADD(day, DATEDIFF(day, 0, GETDATE()) - 1, 0)', 'Beginning of previous day'),
('DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0)' , 'Beginning of this week (Monday)'),
('DATEADD(week, DATEDIFF(week, 0, GETDATE()) + 1, 0)', 'Beginning of next week (Monday)'),
('DATEADD(week, DATEDIFF(week, 0, GETDATE()) - 1, 0)', 'Beginning of previous week (Monday)'),
('DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)' , 'Beginning of this month'),
('DATEADD(month, DATEDIFF(month, 0, GETDATE()) + 1, 0)', 'Beginning of next month'),
('DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 1, 0)', 'Beginning of previous month'),
('DATEADD(quarter, DATEDIFF(quarter, 0, GETDATE()), 0)' , 'Beginning of this quarter (Calendar)'),
('DATEADD(quarter, DATEDIFF(quarter, 0, GETDATE()) + 1, 0)', 'Beginning of next quarter (Calendar)'),
('DATEADD(quarter, DATEDIFF(quarter, 0, GETDATE()) - 1, 0)', 'Beginning of previous quarter (Calendar)'),
('DATEADD(year, DATEDIFF(year, 0, GETDATE()), 0)' , 'Beginning of this year'),
('DATEADD(year, DATEDIFF(year, 0, GETDATE()) + 1, 0)', 'Beginning of next year'),
('DATEADD(year, DATEDIFF(year, 0, GETDATE()) - 1, 0)', 'Beginning of previous year')
) x(SQL, Description);
END;
go
I think I'm not the only one who really appreciates that page.
Viewing 15 posts - 49,876 through 49,890 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply