Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 6,211 through 6,225 (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

Lynn Pettis (6/29/2009)
Alvin Ramard (6/29/2009)
Roy Ernest (6/29/2009)
Can someone take a look at this issue?? I am bit lost on how to help this OP.
That's ok. It's just the usual behind the scene stuff.
Hey Alvin, looks like you got the wrong quote here... 😉

Thanks Lynn. I fixed it.

(I can't wait for my new glasses to be ready!!!)

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]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

When using the quote button anymore, I do two things. First, I refresh the page prior to clicking on the quote button. Second, reading the quote to be sure it is the one I was trying to quote. Seems if you click the quote button after someone else has posted a response that you don't have yet, it messes up the quote you get.

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

GilaMonster (6/29/2009)
The cross join in the subquery?

Dang! I stopped reading the code after the issues I posted...

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

Alvin Ramard (6/29/2009)
Lynn Pettis (6/29/2009)
Alvin Ramard (6/29/2009)
Roy Ernest (6/29/2009)
Can someone take a look at this issue?? I am bit lost on how to help this OP.
That's ok. It's just the usual behind the scene stuff.
Hey Alvin, looks like you got the wrong quote here... 😉
Thanks Lynn. I fixed it.
(I can't wait for my new glasses to be ready!!!)

Yep, know all that. I rushed and wasn't paying attention.

Thanks again Lynn.

--------------------------------

AND I DID IT AGAIN!!!!!!

I'm not fixing this one!!!!

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]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Lynn Pettis

SSC Guru

Points: 442467

June 29, 2009 at 3:52 pm

#1017271

:hehe:

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

Lynn Pettis (6/29/2009)
:hehe:

Lynn, refresh the page and look at my post above yours.

:blush:

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]

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 7

Alvin Ramard (6/29/2009)
Lynn Pettis (6/29/2009)
:hehe:
Lynn, refresh the page and look at my post above yours.
:blush:

😛

WayneS SSC Guru Points: 95460 More actions · Answer 8

Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... ) to Niagra Falls. Does anyone here know anything about this area? I'm looking for when it would be not so hot, but not too chilly. Also, what all is there to do/see besides the falls, on both sides of the border?

Thanks!

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

Okay, I'll admit it if I am wrong, but I'd really like a few others opinions on this one please.

My only problem is 30 years of experience just has my gut instincts pointing to the OS getting starved of memory due to the allocation of memory to the 3 instances of SQL Server.

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

Lynn Pettis (6/29/2009)
Okay, I'll admit it if I am wrong, but I'd really like a few others opinions on this one please.
My only problem is 30 years of experience just has my gut instincts pointing to the OS getting starved of memory due to the allocation of memory to the 3 instances of SQL Server.

No offence intended to anyone, but I've butted heads with someone in that thread a couple of times. Most recently on a corruption question where he was giving completely incorrect advice (emergency mode to rebuild a clustered index to fix corruption in said clustered index)

The problem there is VAS (virtual address space) fragmentation. Unfortunately, I don't know how to resolve it.

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

Paul White SSC Guru Points: 150467 More actions · Answer 11

GilaMonster (6/30/2009)
I've butted heads with someone in that thread a couple of times. Most recently on a corruption question where he was giving completely incorrect advice (emergency mode to rebuild a clustered index to fix corruption in said clustered index)

Me too - though the person in question hasn't engaged me in debate yet. I kept coming across posts with dubious/wrong/dangerous information and posted a number of corrections. I had expected a flame-fest, but the reaction was polite and accepting.

@Lynn

I followed your link since I have a fair amount of experience with VAS issues (fragmentation and pressure) to see if I could help. Read the thread over, looked at the logs, and posted a pretty detailed reply.

Once posted, I noticed I was in the SQL 2000 forums!!!! Bugger. I posted so much 2K5-specific stuff it's untrue.

Oh well! So much for my first visit to the 2K forums - I will have to remember to check next time 😎

Paul

PS I have yet to come across a system that ended up needing the -g switch, though I have removed many a /3GB switch!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

ps. One Orange Chip Points: 29422 More actions · Answer 12

Hey Guys, pls dont laugh at me but i was happy today to find myself amongst top 100 forum posters.:-D

Learnt lots from this site which forces me to stick here whenever i find time.

Thanks Steve for creating this site:-).

Pradeep Singh

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

Paul White (6/30/2009)
PS I have yet to come across a system that ended up needing the -g switch

I have. Previous company we had one server that was used for a lot of DTS packages to fetch data from various systems across the company, a couple of extended stored procs that fetched data from one of the mainframes and lots of scheduled jobs that used openquery to get data from even more places. It was a staging server and from there the main server (Monstrosity of an Itanium) would pick that data up and load it into the main DB.

It was 32 bit because one of the drivers was only 'stable' on 32 bit. We had -g set way up, somewhere around 780 iirc, and we still had to restart SQL every 2 weeks. With default -g, it would crash half way through the overnight jobs.

Memory leaks inside the SQL process space are no fun. Still better than the IA64 version of that driver that had a tendency to overwrite the thread stacks inside SQL.

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

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

Can someone send me a PM please. There looks like there's something buggy, every PM I've received in the last week has been from 'Anonymous' and has no profile associated.

If you do send a PM, please include your name.

Thanks

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 15

GilaMonster (6/30/2009)
Can someone send me a PM please. There looks like there's something buggy, every PM I've received in the last week has been from 'Anonymous' and has no profile associated.
If you do send a PM, please include your name.
Thanks

PM arriving.

Bye

Gianluca

-- Gianluca Sartori