January 16, 2015 at 5:43 pm
Lynn Pettis (1/16/2015)
Sometimes trying to get answers from people is like pulling chicken teeth.
Heh... do like I do. I avoid the barnyard if I can. I don't try to pull chickens teeth, don't try to teach pigs to fly, don't ride jackasses, and if I walk into the lion's den, I try to make sure that I have enough pork chops to go around for everyone. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
January 16, 2015 at 10:04 pm
... Mark one off, 42 days on the calendar to go. 42 days on the calendar to go, 42 days to go, ...
January 17, 2015 at 6:31 am
Lynn Pettis (1/16/2015)
jasona.work (1/16/2015)
So, something good is finally going to happen on Monday.Well, not good for the wallet, but good overall, which is the important thing...
I'm going to get my home lab back!
A couple months back, we moved into a new house (much bigger than our old house, and a BASEMENT!) and I planned to set up my home servers in said basement. Except, we forgot to get extra outlets wired in before we closed. And I decided after moving in to chicken out on working in the electric panel to put in additional breakers...
So, Monday morning an electrician is coming out to put in a couple new circuits and outlets. One for my (eventual) workshop, one for the servers, and one for a dehumidifier. Once he's done, I'll be hooking my server PCs back in, fixing up their IPs, and probably spending the rest of the day updating the OSes...
They have been unhooked for quite a few months now...
They're a bit behind...
Jason
Sounds cool. I am looking at putting together a home lab when I return from Afghanistan, which by the way, I leave on February 28th if all goes as planned.
My lab is a couple home-brew servers (both Xeons) running Hyper-V 2012 with various VMs. What I need to look at doing soon though, is getting an MSDN subscription so I can keep up-to-date on the OS side of the fence.
Well, that's next on the agenda, I guess.
Time to check if my little 8-port switch has enough ports, used to be I also had my router to handle some of the network connections, now thanks to AT&T I've got to use it as a wireless AP on the second floor of the house...
January 17, 2015 at 11:02 am
New laptop, and new labs for me. Toshiba Z30 arrived yesterday, so setup begins today. Then I have to make the switch from Hyper-V back to VMWare (corp decision), so I get to migrate labs and VMs across.
Works for me as I like VMWare and it was a struggle moving to Hyper-V for me.
January 17, 2015 at 7:01 pm
... Mark one off, 41 days on the calendar to go. 41 days on the calendar to go, 41 days to go, ...
January 18, 2015 at 12:39 pm
I'm curious...
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 18, 2015 at 12:58 pm
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2015 at 3:42 pm
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
Maybe that's ok for some folks but that would constitute a huge NFW for me and the company I work for.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 18, 2015 at 4:55 pm
GilaMonster (1/15/2015)
Sean Lange (1/15/2015)
I am having a discussion with somebody who swears that using
EXISTS(select 1
is way faster than just select *. I know Gail has an article on her blog but I can't find it
That's because I don't have one.
I have on on using top(1) in EXISTS, that's all.
Easiest way to prove, other than with tests, is to show that SQL completely ignores the column list in an exists.
WHERE EXISTS (SELECT 1/0 FROM ....)
That is really cool Gail!
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
January 18, 2015 at 5:32 pm
GilaMonster (1/15/2015)
Sean Lange (1/15/2015)
I am having a discussion with somebody who swears that using
EXISTS(select 1
is way faster than just select *. I know Gail has an article on her blog but I can't find it
That's because I don't have one.
I have on on using top(1) in EXISTS, that's all.
Easiest way to prove, other than with tests, is to show that SQL completely ignores the column list in an exists.
WHERE EXISTS (SELECT 1/0 FROM ....)
Wow! What an awesome, super simple, irrefutable test/proof for that. Very cool. Thanks, Gail.
--Jeff Moden
Change is inevitable... Change for the better is not.
January 18, 2015 at 8:33 pm
... Mark one off, 40 days on the calendar to go. 40 days on the calendar to go, 40 days to go, ...
January 18, 2015 at 8:51 pm
Lynn Pettis (1/18/2015)
... Mark one off, 40 days on the calendar to go. 40 days on the calendar to go, 40 days to go, ...
As if you really need my help on this, but just in case you do:
SELECT '... Mark one off, '+x+' days on the calendar to go. '+x+' days on the calendar to go, '+x+' days to go, ...'
FROM (SELECT CAST(DATEDIFF(day, GETDATE(), '2015-02-28') AS VARCHAR(2))) a (x);
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
January 19, 2015 at 12:30 am
TomThomson (1/16/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.The question of today wasn't bad at all. A bit simple maybe (because there was this big discussion last week about aggregates and NULL, so I am amazed people still got it wrong). People just being pedantic over rows vs nulls.
How sad. I've written a few questions, many of them have had something wrong with them, and I've always been willing to accept that and try to correct them. Those who can't admit that they have made a mistake in formulating a question or an explanation are fools, and perhaps those who encourage people to take that attitude when they have displayed no such attitude and no inclination to adopt it, as you did here, are even worse fools.
Your comment (not Steve's) displays an attitude that says something like "let's not care if the questions and answers are misleading, we don't care if they mislead people who are still learning as long as they don't bother us experienced guys". I think that's disgraceful.
Your insult to those who point out the problems in the explanation is pretty disgraceful too, and based on your arrogance not on any facts, at least as far as I can see. I objected to Steve's explanation because it is likely to make people fail to understand what "exists(select(*))" means, not because I got the question wrong (I got it right, as will anyone with any knowledge of SQL SERVER) and I imagine that the people agreeing with my comment did so for the same reasons I had. Your unwarranted slur and your cavalier attitude to those who may be misled by a bad explanation have diminished my view of you.
edit: By the way, congrats. Well done - well deserved award.
My apologies if you were offended/insulted by my remark. It wasn't my intention.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 19, 2015 at 2:33 am
Koen Verbeeck (1/19/2015)
TomThomson (1/16/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.The question of today wasn't bad at all. A bit simple maybe (because there was this big discussion last week about aggregates and NULL, so I am amazed people still got it wrong). People just being pedantic over rows vs nulls.
How sad. I've written a few questions, many of them have had something wrong with them, and I've always been willing to accept that and try to correct them. Those who can't admit that they have made a mistake in formulating a question or an explanation are fools, and perhaps those who encourage people to take that attitude when they have displayed no such attitude and no inclination to adopt it, as you did here, are even worse fools.
Your comment (not Steve's) displays an attitude that says something like "let's not care if the questions and answers are misleading, we don't care if they mislead people who are still learning as long as they don't bother us experienced guys". I think that's disgraceful.
Your insult to those who point out the problems in the explanation is pretty disgraceful too, and based on your arrogance not on any facts, at least as far as I can see. I objected to Steve's explanation because it is likely to make people fail to understand what "exists(select(*))" means, not because I got the question wrong (I got it right, as will anyone with any knowledge of SQL SERVER) and I imagine that the people agreeing with my comment did so for the same reasons I had. Your unwarranted slur and your cavalier attitude to those who may be misled by a bad explanation have diminished my view of you.
edit: By the way, congrats. Well done - well deserved award.
My apologies if you were offended/insulted by my remark. It wasn't my intention.
I'm not taking anyone's sides (you're both grown up folks and can conduct your arguments without assistance) but I don't see anything offensive in Koen's or anyone else's comments. Moreover, 89% people getting it right is a good indication that the question was not worded poorly itself. I can see how the title *might* have mislead somebody, but the question per se was clear.
Tom, this is our water cooler and here you sometimes say things you wouldn't say anywhere else. Don't take offence for these little things.
-- Gianluca Sartori
January 19, 2015 at 5:27 am
Jeff Moden (1/18/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
I'm curious...How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel like it, why did you choose that route?
I for one do everything with VMs on my laptop.
Everyone say it with me...
AAAAAZZZZZZUUUUUURRRE!!!
Maybe that's ok for some folks but that would constitute a huge NFW for me and the company I work for.
Yeah, me too. They'd beat me with a stick if I did that.
Viewing 15 posts - 46,966 through 46,980 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply