Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 22,051 through 22,065 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

GSquared (12/1/2010)
WayneS (11/30/2010)
To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!
My resume is put together as a marketing piece. I have a summary of the "top points" at the top, and it includes items like "Published author on an SQL DBA professionals site", with the URLs for my articles here, and "Presenter at SQL DBA professional group" and the topics and dates covered.
Which reminds me. Jack, I work in Orlando now. Let me know if you want me to present anything to your group again this winter. Was fun doing that last year.

Definitely interested in having you come and speak. FYI, there will be 2 groups in the Orlando area starting in January. OPASS which will be meeting in Lake Mary (about 10 minutes Northeast of the previous location) and MagicPASS which will be meeting in Celebration. Kendal Van Dyke is leading the new group. We are both meeting the week of January 17 with Kevin Kline as the featured speaker. MagicPASS will be meeting on Wednesday the 19th and OPASS will meet either Tuesday or Thursday (we still haven't worked that out). After January we both will be looking for speakers.

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Gianluca Sartori (12/1/2010)
Heeeelp!!! Is any of you familiar with replication?
http://www.sqlservercentral.com/Forums/Topic1028498-291-1.aspx
One of our contractors installed an application that relies on merge replication and now that performance is ugly, they called me to fix it.
And I know nothing about replication...

Just stuck the link out on twitter using the #sqlhelp hash tag. Hopefully someone will get to it. I know at least one replication expert on twitter.

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

Brandie Tarvin (12/1/2010)
Greg Edwards-268690 (12/1/2010)
For the data warehouse - are you implying slowly changing dimensions?
Although the 3 tables wouldn't seem necessary.
There are no really good standards for a versioned DW or even a versioned DB. Lots of people have lots of suggestions, but few have any decent solutions.

It depends somewhat on what the users need and expect.

And if you get too complicated, will the users even understand how to use it properly?

Currency always seems to bring an interesting wrinkle into things.

Especially when you have a lot of different ones being used that change daily.

We usually find that some columns are best frozen, some always updated with current value, and some with both a frozen and a current column meets most of the needs and is easily understood by the business.

So it depends.....

Greg E

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

Jack Corbett (12/1/2010)
Gianluca Sartori (12/1/2010)
Heeeelp!!! Is any of you familiar with replication?
http://www.sqlservercentral.com/Forums/Topic1028498-291-1.aspx
One of our contractors installed an application that relies on merge replication and now that performance is ugly, they called me to fix it.
And I know nothing about replication...
Just stuck the link out on twitter using the #sqlhelp hash tag. Hopefully someone will get to it. I know at least one replication expert on twitter.

Great! Thank you, Jack.

They're rolling out this new project and they didn't take performance tests before.

I was asked to stop everything I was doing to take a look at this mess. Grrrrr!!!!! :angry:

-- Gianluca Sartori

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

GilaMonster (11/30/2010)
Alvin Ramard (11/30/2010)
I'm still not sure about the number of records this might returned.
Who knows? Unless I'm missing something, it's a cross join between T2 and T3 (there's no limitation between those tables) and a double-triangular join between T1 and T2 and T1 and T3.

Just for giggles - if you were to do with a 100-row tally table aliased 3 times, you end up with something in the ball park os 1.7M rows. Do it for 1000 rows, you get something like 167M rows. Even if you have a different data distirbution, that query is a ticking timebomb.

So much for n-ary expressions.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Chad Crawford (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Will there be virtual doughnuts and virtual pizza?

Yes - lots of them too. Eat until you feel you can eat no more. Just remember the pizza and doughnuts are calorie free!!

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

WayneS SSC Guru Points: 95460 More actions · Answer 7

Chris Morris-439714 (12/1/2010)
WayneS (12/1/2010)
Chris Morris-439714 (12/1/2010)
WayneS (11/30/2010)
To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!
Good Lord Wayne you're morphing into Karthik :unsure:
Even after googling this, I'm still not sure if this is good or bad... :unsure:
Ah Wayne, a little misunderstanding, my apologies. He's a regular poster aka the "PhD Candidate", here's a typical post. Inputs are welcome! 😛

So, whatcha trying to say 'bout me?:w00t::w00t::-D;-)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Tom.Thomson (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
The 744 pixel wide image doesn't really fit well unscaled in a 670 pixel wide slot.

I know. That is a pain of the wordpress plugin. I scaled it down to 670 and then published it. Lo and behold the published version jumps to 744 again.

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 SSC Guru Points: 281334 More actions · Answer 9

GilaMonster (12/1/2010)
You know there's a problem when...
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
The Chief Enterprise Architect
The CIO

Hmmm - you are talking about the Client right, not my employer?

Same thing is occurring at my place - spread out over a month.

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 SSC Guru Points: 281334 More actions · Answer 10

Lynn Pettis (12/1/2010)
GilaMonster (12/1/2010)
You know there's a problem when...
In the last 2 weeks there have been three resignations at current client:
The senior developer (leaving only 2 permanent developers)
The Chief Enterprise Architect
The CIO
Hey Gail, apply for the CIO position, then they'd have to listen to you!
<ducks and runs>

It doesn't pay enough.

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 SSC Guru Points: 281334 More actions · Answer 11

Tom.Thomson (12/1/2010)
Brandie Tarvin (12/1/2010)
Tom.Thomson (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
The 744 pixel wide image doesn't really fit well unscaled in a 670 pixel wide slot.
I had the same problem. I don't even know what the meeting's about because I couldn't read it.
Oh, you can just right-click on the image and select "look at the image on its own" on the menu (not sure of the exact phrasing - my browser menus aren't in English - but that's what it means). Then you will get the whole image.

Fixed now. I scaled it down further (590 pixel wide) and it balloons up to the right size.

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

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 12

CirquedeSQLeil (12/1/2010)
Tom.Thomson (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
The 744 pixel wide image doesn't really fit well unscaled in a 670 pixel wide slot.
I know. That is a pain of the wordpress plugin. I scaled it down to 670 and then published it. Lo and behold the published version jumps to 744 again.

What plugin are you using? When I'm putting images in my WordPress, I scale them to the size I want and WordPress offers additional scaling. Are you using WordPress to upload or are you directing it to a separately uploaded image?

I can provide a link to one of the blogs where I use images if you'd like.

--------------------------------------
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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

David Burrows (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
Anyone know if there will be a recording available, 2.30AM is a tad late for me 🙁

Yes, it will be recorded. If there are no difficulties with technology like we had last month then the recording will be made available.

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 SSC Guru Points: 281334 More actions · Answer 14

Stefan Krzywicki (12/1/2010)
CirquedeSQLeil (12/1/2010)
Tom.Thomson (12/1/2010)
CirquedeSQLeil (11/30/2010)
For any that might be interested in an opportunity to heckle a threadizen, check this out[/url].
The 744 pixel wide image doesn't really fit well unscaled in a 670 pixel wide slot.
I know. That is a pain of the wordpress plugin. I scaled it down to 670 and then published it. Lo and behold the published version jumps to 744 again.
What plugin are you using? When I'm putting images in my WordPress, I scale them to the size I want and WordPress offers additional scaling. Are you using WordPress to upload or are you directing it to a separately uploaded image?
I can provide a link to one of the blogs where I use images if you'd like.

Using wordpress to upload directly. The scale feature in wordpress is what I used to resize the image. After resizing and the image looking right in the preview it ballooned up when I published the article.

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

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 15

WayneS (12/1/2010)
Chris Morris-439714 (12/1/2010)
WayneS (12/1/2010)
Chris Morris-439714 (12/1/2010)
WayneS (11/30/2010)
To all the Threadizens that have presented - how have you incorporated this public speaking into your resume? Examples would be great!
Good Lord Wayne you're morphing into Karthik :unsure:
Even after googling this, I'm still not sure if this is good or bad... :unsure:
Ah Wayne, a little misunderstanding, my apologies. He's a regular poster aka the "PhD Candidate", here's a typical post. Inputs are welcome! 😛
So, whatcha trying to say 'bout me?:w00t::w00t::-D;-)

Nah mate you're off the hook - first thing you did was Google it 😀

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden