Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 26,851 through 26,865 (of 66,712 total)

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Some people really dont want to be helped do they :crazy:

http://www.sqlservercentral.com/Forums/Topic1116629-9-3.aspx#bm1117914

Clear Sky SQL
My Blog[/url]

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

Dave Ballantyne (6/1/2011)
Some people really dont want to be helped do they :crazy:
http://www.sqlservercentral.com/Forums/Topic1116629-9-3.aspx#bm1117914

Yeah...

I always wonder about the threads where someone asks for a bunch of information and the OP replies to one question, then the person asks for the rest of the information and the OP replies to one of them, ....

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

mazzz SSCertifiable Points: 6139 More actions · Answer 3

GilaMonster (6/1/2011)
I always wonder about the threads where someone asks for a bunch of information and the OP replies to one question, then the person asks for the rest of the information and the OP replies to one of them, ....

The RBAR way of asking a question...?

------------------------------------------------------------------------
Bite-sized fiction (with added teeth) [/url]

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 4

mazzz (6/1/2011)
The RBAR way of asking a question...?

QBAQ , i like it 🙂

Clear Sky SQL
My Blog[/url]

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

Dave Ballantyne (6/1/2011)
mazzz (6/1/2011)
The RBAR way of asking a question...?
QBAQ , i like it 🙂

:-P:-P:-P

CTE or Cursor?

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

Greg Edwards-268690 (6/1/2011)
Dave Ballantyne (6/1/2011)
mazzz (6/1/2011)
The RBAR way of asking a question...?
QBAQ , i like it 🙂
:-P:-P:-P
CTE or Cursor?

The person trying to respond quickly becomes the Cursor

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

WayneS SSC Guru Points: 95460 More actions · Answer 7

GilaMonster (6/1/2011)
Dave Ballantyne (6/1/2011)
Some people really dont want to be helped do they :crazy:
http://www.sqlservercentral.com/Forums/Topic1116629-9-3.aspx#bm1117914
Yeah...
I always wonder about the threads where someone asks for a bunch of information and the OP replies to one question, then the person asks for the rest of the information and the OP replies to one of them, ....

GilaMonster (6/1/2011)
Blood from a stone...

In this case, it seems like it would be easier getting blood from a stone than getting all of your questions answered...

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

Greg Edwards-268690 (6/1/2011)
Dave Ballantyne (6/1/2011)
mazzz (6/1/2011)
The RBAR way of asking a question...?
QBAQ , i like it 🙂
:-P:-P:-P
CTE or Cursor?

Definitely a while loop

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 9

Would you call this recursive?

WITH cte (Curse) AS

(

SELECT 'Dammit'

UNION ALL

SELECT Curse from cte

)

select Curse from cte

__________________________________________________

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 10

The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte

Yes - but just not enough

;

WITH cte (Curse) AS

(

SELECT 'Holy Mother of Pearl Batman'

UNION ALL

SELECT Curse from cte

)

select Curse from cte

OPTION (MAXRECURSION 0)

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 11

The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte

I'm more inclined to go with something like this:

DECLARE @numrows INT

,@TopRange INT

SET @TopRange = 1000

SET @numrows = ABS(CHECKSUM(NEWID()))%@TopRange+1

;

with curse (rownum,curse) AS (

SELECT 1,'Damnit'

UNION

SELECT 2,'Flip'

UNION

SELECT 3,'SHIP'

),rand1 as (

SELECT TOP (@numrows)

RowNum = ROW_NUMBER() over (order by (Select 1))

,SomeInt = ABS(CHECKSUM(NEWID()))%@TopRange+1

FROM Master.dbo.SysColumns t1

CROSS JOIN Master.dbo.SysColumns t2

)

Select cc.curse

from rand1

CROSS APPLY (

Select TOP (@numrows) SomeInt,RowNum

from rand1

) ct

CROSS APPLY

(SELECT rownum,curse FROM curse) cc

ORDER BY NEWID()

Insert your random cursors where you wish, change the variables and attach speech to the output.

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

Jim Murphy SSCertifiable Points: 6263 More actions · Answer 12

The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte

Brings me back to the beginning of my days (pun intended). A different language entirely:

10 Print "I'm not a Re-Curser but I am a Re-Cursor."

20 GOTO 10

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Jim Murphy (6/1/2011)
The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte
Brings me back to the beginning of my days (pun intended). A different language entirely:
10 Print "I'm not a Re-Curser but I am a Re-Cursor."
20 GOTO 10

HAHA

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 14

Insert your random cursors where you wish, change the variables and attach speech to the output.

Shut the front door....

__________________________________________________

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 15

The Dixie Flatline (6/1/2011)
Insert your random cursors where you wish, change the variables and attach speech to the output.
Shut the front door....

May have to shut it for quite a long time 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