Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,3274,3284,3294,3304,331»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 6:40 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 15,738, Visits: 28,146
GilaMonster (3/12/2014)
Am I slow today, or was this a little tricky to figure out? http://www.sqlservercentral.com/Forums/Topic1550137-1292-1.aspx


No, that one was weird.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1550197
Posted Wednesday, March 12, 2014 7:02 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:10 PM
Points: 4,346, Visits: 3,399
dwain.c (3/11/2014)

Are the posted questions lately dripping with entitlement?

Yes, they seem to have that attitude. Provide no DDL, no data, scant specs and sometimes don't even ask a question. Well, where's the response? It should have been posted already, so let's state the same thing a couple more times and post the same question in another thread.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1550211
Posted Wednesday, March 12, 2014 7:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:12 PM
Points: 1,249, Visits: 6,699
Ed Wagner (3/12/2014)
dwain.c (3/11/2014)

Are the posted questions lately dripping with entitlement?

Yes, they seem to have that attitude. Provide no DDL, no data, scant specs and sometimes don't even ask a question. Well, where's the response? It should have been posted already, so let's state the same thing a couple more times and post the same question in another thread.


Or like this
I don't feel they understood AVG as they claimed.
And then we bring it upon ourselves supplying a CTE.
I like that they supplied some data and ddl, but then supply an example in Excel using another set of data.
Maybe I'm wrong, but I still think the user would have been better off with the basics.
A good handle on them takes you pretty far.
Post #1550238
Posted Wednesday, March 12, 2014 4:13 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.


__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1550446
Posted Wednesday, March 12, 2014 4:15 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:32 PM
Points: 21,755, Visits: 15,459
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.


Dear expert, you should drop your database.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1550449
Posted Wednesday, March 12, 2014 4:18 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:43 PM
Points: 3,667, Visits: 8,006
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.

I'm sure we can help. Here's a possible solution for you:
Solution to almost any problem



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1550450
Posted Wednesday, March 12, 2014 4:46 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.


Dear expert, you should drop your database.


Okay, I dropped the database but it still doesn't work. Someone on another website says I should do a backup, but wouldn't tell me how. Would you agree that this is a good idea? If so, could you give me instructions? If you don't agree, could you talk to him about this for me?











__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1550453
Posted Wednesday, March 12, 2014 4:53 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:32 PM
Points: 21,755, Visits: 15,459
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.


Dear expert, you should drop your database.


Okay, I dropped the database but it still doesn't work. Someone on another website says I should do a backup, but wouldn't tell me how. Would you agree that this is a good idea? If so, could you give me instructions? If you don't agree, could you talk to him about this for me?



hmmm, maybe try formatting the Z drive where your data files are.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1550459
Posted Wednesday, March 12, 2014 6:08 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 3,648, Visits: 5,328
Luis Cazares (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.

I'm sure we can help. Here's a possible solution for you:
Solution to almost any problem


BWAHAHAHAHAHAA!

Nice one Luis!



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1550481
Posted Wednesday, March 12, 2014 6:30 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:43 PM
Points: 3,667, Visits: 8,006
dwain.c (3/12/2014)
Luis Cazares (3/12/2014)
The Dixie Flatline (3/12/2014)
I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that it doesn't work.

I'm sure we can help. Here's a possible solution for you:
Solution to almost any problem


BWAHAHAHAHAHAA!

Nice one Luis!

I've been tempted to do something like this several times (I might have done it).

In another order of ideas, today I had a good experience to prove your quote about indexing and cat food. A process with an insert and update to the same table was taking almost 2 hours to finish and the update used 90 minutes. After trying to create an index that would work for this query, I proposed to remove the update and include the value in the insert. The insert didn't take longer and we could deliver the information one and a half hour faster each day.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1550485
« Prev Topic | Next Topic »

Add to briefcase «««4,3274,3284,3294,3304,331»»»

Permissions Expand / Collapse