Are the posted questions getting worse?
-
GilaMonster (10/18/2012)
Brandie Tarvin (10/18/2012)
Jeff Moden (10/17/2012)
Jeez!!! I just went through interviewing another candidate. Resume says that, in the last 5 years, he designed databases, spent time normalizing/denormalizing depending on whether or not is was a reporting database or not, wrote stored procedures and triggers, but couldn't define what normalization is, couldn't explain why he used IDENTITY columns as PK's, insisted that you don't need a unique column on reference tables (enum tables, etc), and adds to the recent collection of "experts" that don't know the name of the function in SQL Server to get the current date and time through T-SQL.I think the worst part of that statement is the fact that he claims to be a database designer but can't explain why he made the choices he made (RE: using identity).
Aren't people at least supposed to know why they make the choices they do?
"The dice rolled a 4, so I used an identity column."
Ahhh. He's using the wrong GM screen. That was a typo. The errata for the screen says a 4 is an XML column.
-
Brandie Tarvin (10/17/2012)
Excuse me a moment while I crow again. My new Shadowrun adventure "Sacrificial Limb" (the first book I've written as a solo author) came out last week from Catalyst Game Labs[/url] in PDF (with print pre-orders being taken).And a few days later, I got my first review[/url]. 4 out of 5 stars, mostly positive. I'm absolutely stoked about the last line which says "...Sacrificial Limb is as much fun to read through as it is to play, and will definitely be a talking point both in the metaplot of the Sixth World and on Shadowrun oriented websites/forums for some time to come."
SQUEE. :w00t:
Congrats!
:hehe:
-
Stefan Krzywicki (10/18/2012)
Gianluca Sartori (10/18/2012)
Stefan Krzywicki (10/17/2012)
dwain.c (10/17/2012)
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!I've turned off the automatic updates for just that reason. Annoying at best, disastrous at worst.
Wiindows can remind me and then I do it at my leisure.
I've done it twice. Company-wide settings override it.
I had the same issue at my previous company.
I ended up adding NET STOP "Automatic Updates" at startup.
It worked.
Hmmm... Maybe I'll give that a try. Thanks!
I did that once. I happened to have a sysadmin that was on top of things and he came asking me why. He had been tracking who had been updated and who had not.
Hands slapped but got a policy changed.
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 -
SQLRNNR (10/18/2012)
Stefan Krzywicki (10/18/2012)
Gianluca Sartori (10/18/2012)
Stefan Krzywicki (10/17/2012)
dwain.c (10/17/2012)
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!I've turned off the automatic updates for just that reason. Annoying at best, disastrous at worst.
Wiindows can remind me and then I do it at my leisure.
I've done it twice. Company-wide settings override it.
I had the same issue at my previous company.
I ended up adding NET STOP "Automatic Updates" at startup.
It worked.
Hmmm... Maybe I'll give that a try. Thanks!
I did that once. I happened to have a sysadmin that was on top of things and he came asking me why. He had been tracking who had been updated and who had not.
Hands slapped but got a policy changed.
Fair point.
After all, if there's a policy you'd better respect it and ask for a change if something doesn't fit your needs.
-- Gianluca Sartori
-
Gianluca Sartori (10/18/2012)
SQLRNNR (10/18/2012)
Stefan Krzywicki (10/18/2012)
Gianluca Sartori (10/18/2012)
Stefan Krzywicki (10/17/2012)
dwain.c (10/17/2012)
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!I've turned off the automatic updates for just that reason. Annoying at best, disastrous at worst.
Wiindows can remind me and then I do it at my leisure.
I've done it twice. Company-wide settings override it.
I had the same issue at my previous company.
I ended up adding NET STOP "Automatic Updates" at startup.
It worked.
Hmmm... Maybe I'll give that a try. Thanks!
I did that once. I happened to have a sysadmin that was on top of things and he came asking me why. He had been tracking who had been updated and who had not.
Hands slapped but got a policy changed.
Fair point.
After all, if there's a policy you'd better respect it and ask for a change if something doesn't fit your needs.
Tried that. Amazing how often IT is lumped in with the rest of a company, as though their needs wouldn't be any different.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
Stefan Krzywicki (10/18/2012)
Gianluca Sartori (10/18/2012)
SQLRNNR (10/18/2012)
Stefan Krzywicki (10/18/2012)
Gianluca Sartori (10/18/2012)
Stefan Krzywicki (10/17/2012)
dwain.c (10/17/2012)
Stefan Krzywicki (10/17/2012)
I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I can note everything I have open and make sure I can get back to that setup after the reboot. With an automatic reboot, everything is just gone. It is all saved, but closed and I have to remember what I had open. Bah!I've turned off the automatic updates for just that reason. Annoying at best, disastrous at worst.
Wiindows can remind me and then I do it at my leisure.
I've done it twice. Company-wide settings override it.
I had the same issue at my previous company.
I ended up adding NET STOP "Automatic Updates" at startup.
It worked.
Hmmm... Maybe I'll give that a try. Thanks!
I did that once. I happened to have a sysadmin that was on top of things and he came asking me why. He had been tracking who had been updated and who had not.
Hands slapped but got a policy changed.
Fair point.
After all, if there's a policy you'd better respect it and ask for a change if something doesn't fit your needs.
Tried that. Amazing how often IT is lumped in with the rest of a company, as though their needs wouldn't be any different.
Yeah - those kinds of policies are no fun.
I'm in favor of the Net Stop in that case and performing manual updates.
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 -
A few years back, my team had the biggest problem with an auto policy that shut down our PCs in the middle of the night. It took us forever to get an exception to that policy.
The only reason we got it was because we argued that if the servers went down in the middle of the night and we had to get online in a hurry, the company could lose money waiting for us to drive into work instead of being able to remote in.
It's interesting how fast policies get changed when money is involved and how they don't get changed for any other argument.
-
Brandie Tarvin (10/18/2012)
A few years back, my team had the biggest problem with an auto policy that shut down our PCs in the middle of the night. It took us forever to get an exception to that policy.The only reason we got it was because we argued that if the servers went down in the middle of the night and we had to get online in a hurry, the company could lose money waiting for us to drive into work instead of being able to remote in.
It's interesting how fast policies get changed when money is involved and how they don't get changed for any other argument.
+1
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 -
Soon I shall be logging out of SSC for a week of much needed R&R. I know you'll miss me. 😀
So, to help you cherish fond memories, I've attached some photos of things I hope to see or have already done while traveling in the south of Thailand.
http://i1252.photobucket.com/albums/hh569/dwaincamps/Travel%20Thailand/phang1.jpg">
My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]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 -
Stuart Davies (10/18/2012)
Stefan Krzywicki (10/17/2012)
Brandie Tarvin (10/17/2012)
It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.Young fella, do you even know what a chicken hawk is?
As long as I know you know, it doesn't matter if you know you know. You knowing I know you know should satisfy you since if I know you know, even if I know you don't know you know, you get the job, you know?
But also don't forget that:- We know there are known knowns: there are things we know we know. We also know there are known unknowns: that is to say we know there are things we know we don't know. But there are also unknown unknowns — the ones we don't know we don't know
Rumsfeld, right?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
-
...and now to spend the rest of the day working on a "we needed this impossible report on 9/1 but forgot to prioritize it, can you do this right away" ticket. lah dee dah
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
-
dwain.c (10/19/2012)
Soon I shall be logging out of SSC for a week of much needed R&R. I know you'll miss me. 😀Have a splendid holiday Mr C - you've rather earned it over the last few weeks 😉
[font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]For better assistance in answering your questions, please read this[/url].
Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
-
Threadizens!
Who will be at Connections in Vegas? Steve and I will be. Anyone else?
And then, the week after is the Summit. Oi or is it Oy or do both apply?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
I have a question and if anyone could point me in the right direction I'd appreciate it. I've been banging my head against a wall trying to figure this one out.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams -
Brandie Tarvin (10/18/2012)
Stuart Davies (10/18/2012)
Stefan Krzywicki (10/17/2012)
Brandie Tarvin (10/17/2012)
It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.Young fella, do you even know what a chicken hawk is?
As long as I know you know, it doesn't matter if you know you know. You knowing I know you know should satisfy you since if I know you know, even if I know you don't know you know, you get the job, you know?
But also don't forget that:- We know there are known knowns: there are things we know we know. We also know there are known unknowns: that is to say we know there are things we know we don't know. But there are also unknown unknowns — the ones we don't know we don't know
Brilliant!
Best summarized by:
(of course, the stuff you know you know slice is too big here, but you get the idea)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2
Viewing 15 posts - 38,131 through 38,145 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply