Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 22,036 through 22,050 (of 66,712 total)

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

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 1

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

And now we know why the Project from Hell has been pushed back. @=)

This is the time to ask for a raise, methinks. Not only for the trouble they've been causing you, but for the "You don't want a major brain-drain, you'd best make it really worth my while to stay" argument.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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

I sense the fire under the pressure cooker might get bigger.

The last 2 - seems like you have a car with no steering wheel.

Greg E

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

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

I think I've worked there.

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Brandie Tarvin (12/1/2010)
And now we know why the Project from Hell has been pushed back. @=)

I wish it were that logical. Business user (person screaming for app for months) is the one who requested a delay.

This is the time to ask for a raise, methinks.

Ask? What is this ask? I'm a consultant. "As of Jan 1st, the new hourly rate will be ....", and negotiate from that perspective.

Honestly, best thing now will be to find another client or two. An increase is not going to help tolerate this place.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 5

Greg Edwards-268690 (12/1/2010)
For the data warehouse - are you implying slowly changing dimensions?
Although the 3 tables wouldn't seem necessary.

Yes and no. The way that slowly changing dimensions are implemented in SQL don't work for our needs. Not only do we need to track changes for columns as they happen, we need to keep a versioned history, so that we can go back financially and see what item was in which state when it happened. I don't remember the exact details, but when I went to create our DW, we had a huge issue with foreign and primary keys. Namely that we had to create a whole bunch that didn't exist and even then, it didn't solve the problem of how to track and update our history tables.

After much research, I discovered we needed a Type 6 / Hybrid data warehouse. (See this wiki link for what I'm referring to: http://en.wikipedia.org/wiki/Slowly_changing_dimension) Unfortunately, SSIS doesn't appear to support that type of SCD, so we coded everything by hand in stored procedures.

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's kind of hit or miss here. So, yes, I could see a situation where 3 tables are a necessary evil of a versioned DW. But I will also admit I'm playing Devil's Advocate on the issue just because I can and not because I've actually done it or would condone such a setup. I'd have to hear the business case on it first.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 6

GilaMonster (12/1/2010)
Brandie Tarvin (12/1/2010)
This is the time to ask for a raise, methinks.
Ask? What is this ask? I'm a consultant. "As of Jan 1st, the new hourly rate will be ....", and negotiate from that perspective.

Hee.

GilaMonster (12/1/2010)
Honestly, best thing now will be to find another client or two. An increase is not going to help tolerate this place.

Probably best for your sanity, stress levels, and overall health. Wouldn't want you to end up in the hospital like Jack did. Walk away while you can.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 7

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

Rats... ship... sinking?

"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

GSquared SSC Guru Points: 260824 More actions · Answer 8

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.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

WayneS SSC Guru Points: 95460 More actions · Answer 9

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?

Just the pizza - but since it's virtual, we'll be having virtual drinks also! 😀

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

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

GSquared (12/1/2010)
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.

Whoot! Any chance of you getting up to Jacksonville next year? We'd love to have you.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

WayneS SSC Guru Points: 95460 More actions · Answer 11

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:

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

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:

Bad. Karthik aka our PhD candidate. Famous for lots of really vague, unresearched questions, many of them totally off topic.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

spaghettidba SSC Guru Points: 105732 More actions · Answer 13

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

-- Gianluca Sartori

David Burrows SSC Guru Points: 65142 More actions · Answer 14

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 🙁

Far away is close at hand in the images of elsewhere.
Anon.

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

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

^{“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