Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 26,041 through 26,055 (of 66,738 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

The Dixie Flatline (4/28/2011)
Haiku
Listen... can you tell?
Someone is using cursors.
Hear the pork chops fly!

How could you hear my puter from there?

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 2

Jason, it's easy.

Use DBCC TimeWarp's

New parameters.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the new parameters so i can spy on others too 😉

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 4

Steve Jones - SSC Editor (4/28/2011)
Since I have the collective braintrust here, and you're posting technical stuff.
I posted a note about understanding your access patterns for data, meaning hitting tables how often and how concurrently. In the past I've gleaned this from Trace, and from knowing most of the queries in the application. However I wonder if there is a better way to do this in DMVs and if anyone else has a resource that might help someone understand how to track/measure the impact they are having on individual objects with queries.

I've usually gone after concurrency and usage via lock reviews. They're heavy handed traces though, and will not show you nolock'ers. Combine that with proc/batch calls by spid from your traces and you can usually dig through enough to find problem children, but I'm afraid I don't have a better way.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 5

SQLRNNR (4/28/2011)
Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the new parameters so i can spy on others too 😉

Recursive knowledge:

Learning TIMEWARP through TIMEWARP.

A jump to the left.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

The Dixie Flatline (4/28/2011)
SQLRNNR (4/28/2011)
Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the new parameters so i can spy on others too 😉
Recursive knowledge:
Learning TIMEWARP through TIMEWARP.
A jump to the left.

So you can use TIMEWARP in a CTE?

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

Stefan Krzywicki (4/28/2011)
The Dixie Flatline (4/28/2011)
SQLRNNR (4/28/2011)
Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the new parameters so i can spy on others too 😉
Recursive knowledge:
Learning TIMEWARP through TIMEWARP.
A jump to the left.
So you can use TIMEWARP in a CTE?

In a while

In a cursor

On a plane

And in a train

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

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 8

Craig Farrell (4/28/2011)
Steve Jones - SSC Editor (4/28/2011)
Since I have the collective braintrust here, and you're posting technical stuff.
I posted a note about understanding your access patterns for data, meaning hitting tables how often and how concurrently. In the past I've gleaned this from Trace, and from knowing most of the queries in the application. However I wonder if there is a better way to do this in DMVs and if anyone else has a resource that might help someone understand how to track/measure the impact they are having on individual objects with queries.
That's about what I was thinking. No good way to do it.
Anyone want to write a "how to gather this data" article?
I've usually gone after concurrency and usage via lock reviews. They're heavy handed traces though, and will not show you nolock'ers. Combine that with proc/batch calls by spid from your traces and you can usually dig through enough to find problem children, but I'm afraid I don't have a better way.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 9

SQLRNNR (4/28/2011)
Stefan Krzywicki (4/28/2011)
The Dixie Flatline (4/28/2011)
SQLRNNR (4/28/2011)
Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the new parameters so i can spy on others too 😉
Recursive knowledge:
Learning TIMEWARP through TIMEWARP.
A jump to the left.
So you can use TIMEWARP in a CTE?
In a while
In a cursor
On a plane
And in a train

You can use it on your box.

You can use it with a fox.

You can make it block out spam.

It can do anything, Sam I Am

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 10

SQLRNNR (4/28/2011)
In a while
In a cursor
On a plane
And in a train

Although a nice work of art, I think Gail does a much better job.

I'll try (humor inspired by "The Joust" by Gail Shaw"):

Slipped on a cursor

Stumbled into a while

xp_send_DBChainMail

Stepped on a pile

.... and died. Reluctantly.

Ya, we'd better leave this stuff to Gail.

Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

The Dixie Flatline (4/28/2011)
SQLRNNR (4/28/2011)
Stefan Krzywicki (4/28/2011)
The Dixie Flatline (4/28/2011)
SQLRNNR (4/28/2011)
Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new version with the new parameters so i can spy on others too 😉
Recursive knowledge:
Learning TIMEWARP through TIMEWARP.
A jump to the left.
So you can use TIMEWARP in a CTE?
In a while
In a cursor
On a plane
And in a train
You can use it on your box.
You can use it with a fox.
You can make it block out spam.
It can do anything, Sam I Am

nice to see you back on the forums.

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 12

[Jim].[dba].[Murphy] (4/28/2011)
SQLRNNR (4/28/2011)
In a while
In a cursor
On a plane
And in a train
Although a nice work of art, I think Gail does a much better job.
I'll try (humor inspired by "The Joust" by Gail Shaw"):
Slipped on a cursor
Stumbled into a while
xp_send_DBChainMail
Stepped on a pile
.... and died. Reluctantly.
Ya, we'd better leave this stuff to Gail.

Probably a good idea 😀

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 13

A bit of narcissism drove this, but I hit a whaaaaa type of site.

This site takes another site and completely frames it in its own advertising and stuff.

http://news.comrite.com/en/newsposts/39235

That points to a direct page of my Job Posting article... for SQL Server. Down to requiring my SQL Server login.

Wierd.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 14

The Dixie Flatline (4/28/2011)
Haiku
Listen... can you tell?
Someone is using cursors.
Hear the pork chops fly!

Freakin' awesome. 😀

--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: 1004414 More actions · Answer 15

heh... I think I've done this once here before but since everyone is in such a poetic mode... sung to the tune of "Row, row, row your boat"...

[font="Arial Black"]No, no, no you don't,

Loop with any class!

Merrily! Merrily! Merrily! Merrily!

Set-based saved my _____![/font] 😀

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