Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 16,921 through 16,935 (of 66,712 total)

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

GilaMonster (7/31/2010)
Looks like the data transfer should be done around 6am this morning. Then some schema checks, some backups and outa here.

Doesn't sound like a good weekend but at least you'll make a few extra bucks. That's better than having to go thru this as a salary employee and getting nothing extra out of it. I've been there, in the engineering days. 🙁

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

GilaMonster (7/31/2010)
Alvin Ramard (7/31/2010)
GilaMonster (7/31/2010)
It's Sunday 1am and I'm recovering a 120 GB sql database from a month old backup and a collection of flat files. DBA? We don't need a DBA!
This kind of BS has gone on for too long. It's time to make the managers that make these bad decisions pay!!
At this point they are paying, round about $500/hour for the people they have on site fixing the mess. (and for those who think that's cheap, bear in mind the exchange rate and that costs of most things are a lot lower here than Europe/USA)
It's set them back a few million in total so far.

Does that include the cost of the loss of the most recent month's data?

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

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

Stefan Krzywicki (7/31/2010)
GilaMonster (7/31/2010)
Alvin Ramard (7/31/2010)
GilaMonster (7/31/2010)
It's Sunday 1am and I'm recovering a 120 GB sql database from a month old backup and a collection of flat files. DBA? We don't need a DBA!
This kind of BS has gone on for too long. It's time to make the managers that make these bad decisions pay!!
At this point they are paying, round about $500/hour for the people they have on site fixing the mess. (and for those who think that's cheap, bear in mind the exchange rate and that costs of most things are a lot lower here than Europe/USA)
It's set them back a few million in total so far.
Does that include the cost of the loss of the most recent month's data?

There won't be more than a couple days lost by the time I'm done. That's what the collection of flat files is for.

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

Are those flat files there for DR? Or were they loads of some sort?

TomThomson SSC Guru Points: 104773 More actions · Answer 5

GilaMonster (7/31/2010)
And for the weekend...
Please do my work for me: http://www.sqlservercentral.com/Forums/Topic961690-391-1.aspx
Want someone to email questions to: http://www.sqlservercentral.com/Forums/Topic961691-1550-1.aspx
I have 2 new SQL servers. What should I do? http://www.sqlservercentral.com/Forums/Topic961717-1549-1.aspx
Am outa here for the weekend.

I think the first one may have read somewhere that we want to see tables scripted and some code, and expressed himself badly with that "for your review". His "how to do it" is bizarre, so I commented on that - I'm not interested in looking his table definitions or his code because while the description in English is plainly wrong there's no hope of getting the code right (and the code and table definitions don't appear to cover the "rotation" requirement anyway, unless that's what the two rank columns are for).

Tom

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

Steve Jones - Editor (8/1/2010)
Are those flat files there for DR? Or were they loads of some sort?

Kinda the latter (don't want to get into more detail). Definitely no DR planning happening here.

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

Alvin Ramard (7/31/2010)
GilaMonster (7/31/2010)
It's Sunday 1am and I'm recovering a 120 GB sql database from a month old backup and a collection of flat files. DBA? We don't need a DBA!
This kind of BS has gone on for too long. It's time to make the managers that make these bad decisions pay!! The big question is: "How do we do it?"

Heh... and NOW you all understand the origin of pork chops! 😉 I sometimes describe them as "managerial flak". :hehe:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 8

bitbucket-25253 (7/31/2010)
nor when my use of cursors (excuse me Jeff) slowed things down to a crawl.

Heh... I [font="Arial Black"]KNEW [/font]there was a disturbance in the Force! 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

WayneS SSC Guru Points: 95460 More actions · Answer 9

GilaMonster (7/31/2010)
And for the weekend...
Want someone to email questions to: http://www.sqlservercentral.com/Forums/Topic961691-1550-1.aspx
Am outa here for the weekend.

I just had to submit my rates for this. 😀

Edit: Now, if I can just get someone to post about how reasonable those are...;-) :w00t:

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 10

WayneS (8/1/2010)
GilaMonster (7/31/2010)
And for the weekend...
Want someone to email questions to: http://www.sqlservercentral.com/Forums/Topic961691-1550-1.aspx
Am outa here for the weekend.
I just had to submit my rates for this. 😀
Edit: Now, if I can just get someone to post about how reasonable those are...;-) :w00t:

Heh... you must bring your own server, huh? 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

spaghettidba SSC Guru Points: 105732 More actions · Answer 11

Alvin Ramard (7/31/2010)
GilaMonster (7/31/2010)
Looks like the data transfer should be done around 6am this morning. Then some schema checks, some backups and outa here.
Doesn't sound like a good weekend but at least you'll make a few extra bucks. That's better than having to go thru this as a salary employee and getting nothing extra out of it. I've been there, in the engineering days. 🙁

OK, Alvin: stop watching me with that spy cam! 😛

BTW, my hourly rate is around 11 euros (14 dollars).

-- Gianluca Sartori

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 12

Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).

Wow! If that's actually true, that's WAY too low for someone of your level of talent, Gianluca. You need to have a look around and, no, you shouldn't have to move to get a better hourly rate.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

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

Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).

That's shocking. Why so low? What's the going rate for a dba in your area?

I've just Jobserved SQL Server DBA in Reading, England +- 25 miles, the result was 5 pages with an average £350 per day. Look around, confirm what you are worth. If you are earning significantly less then there has to be an awfully good reason.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 14

Jeff Moden (8/2/2010)
Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).
Wow! If that's actually true, that's WAY too low for someone of your level of talent, Gianluca. You need to have a look around and, no, you shouldn't have to move to get a better hourly rate.

Thank you for your kind words, Jeff. Unfortunately, my rate seems to be perfectly aligned with the market here. Looking at the job market in my area I should be happy to have a job.

I sometimes see 150K $/year DBA positions in the US and I wonder why I'm still here.

What exactly are you americans doing at work that makes you worth all that money?

-- Gianluca Sartori

spaghettidba SSC Guru Points: 105732 More actions · Answer 15

Chris Morris-439714 (8/2/2010)
Gianluca Sartori (8/2/2010)
BTW, my hourly rate is around 11 euros (14 dollars).
That's shocking. Why so low? What's the going rate for a dba in your area?
I've just Jobserved SQL Server DBA in Reading, England +- 25 miles, the result was 5 pages with an average £350 per day. Look around, confirm what you are worth. If you are earning significantly less then there has to be an awfully good reason.

There's an awfully good reason over all: I'm not a freelance.

It's not a good moment to start consulting. You get a lot of work, but nobody pays. I'm sure the bank will want to see the mortgage paid every month anyway.

-- Gianluca Sartori