Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 29,131 through 29,145 (of 66,749 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.

Posted. Overall, I am quite pleased with TVPs

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

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

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.

They've come in really handy a number of times for me.

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

GSquared SSC Guru Points: 260824 More actions · Answer 3

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.

Incredibly useful. Big improvements possible in performance, maintainability, and speed+ease of development.

Just the uses with multi-select option boxes and related objects in applications, that alone makes them worthwhile.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

FYI - we need only 866 posts to reach 30K

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 5

Thx Stephan, Gus and Jason for the input.

Thread needs only 865 posts to hit 30K and I need 80 posts to hit 3K. Who will reach first, the thread or me? 😉

I say the thread. 😀

-Roy

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Roy Ernest (8/18/2011)
Thx Stephan, Gus and Jason for the input.
Thread needs only 865 posts to hit 30K and I need 80 posts to hit 3K. Who will reach first, the thread or me? 😉
I say the thread. 😀

My money is on the thread.

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

Paul White SSC Guru Points: 150468 More actions · Answer 7

Ninja's_RGR'us (8/18/2011)
Please post your results with the version(s) you tested on.

Added my contribution.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

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

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.

I see it as the first step needed for ORM and RDBMS to start liking each other again.

- 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

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

SQLRNNR (8/18/2011)
Roy Ernest (8/18/2011)
Thx Stephan, Gus and Jason for the input.
Thread needs only 865 posts to hit 30K and I need 80 posts to hit 3K. Who will reach first, the thread or me? 😉
I say the thread. 😀
My money is on the thread.

I'll put two bits and my $.02 on the thread. I'll even toss in the penny I got for my thoughts, relatively sure the person needed a refund anyway.

- 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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 10

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.

Never used them. I think that they are a good idea, but I think that there is a need for a more generic implementation. I'm not sure how they'd work, but...

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jeff Moden SSC Guru Points: 1004436 More actions · Answer 11

Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.

I've never used them. I've always used something else because they didn't use to be available. Not sure I'd actually use them, either, beccause of the following restriction...

Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine.

... and because if the data is already in SQL Server somewhere, I don't need to pass a TVP for that information to a stored procedure.

Admittedly, it's a bit of a personal predjudice but I also don't care for the idea of having to build a user datatype just to use a TVP. It's yet another thing to change if a slight modification to the data needs to be made.

Yeah... I know... I've gotta open up my mind and go play with the darned things. 😛 Heh... THEN I'll be able to bad mouth them! :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: 1004436 More actions · Answer 12

Evil Kraig F (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I see it as the first step needed for ORM and RDBMS to start liking each other again.

BWAAAA-HAAAAA!!!!! Now, all we need is a first step for me to like ORM's. 😛

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Jeff Moden (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available. Not sure I'd actually use them, either, beccause of the following restriction...
Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine.
... and because if the data is already in SQL Server somewhere, I don't need to pass a TVP for that information to a stored procedure.
Admittedly, it's a bit of a personal predjudice but I also don't care for the idea of having to build a user datatype just to use a TVP. It's yet another thing to change if a slight modification to the data needs to be made.
Yeah... I know... I've gotta open up my mind and go play with the darned things. 😛 Heh... THEN I'll be able to bad mouth them! :hehe:

For us, we were using them to hold 100s and 1000s of records coming in from a webapp of data that was not yet in the database. The old method was to send an xml array to a proc and have SQL do the bulk of the work there. Then we tried delimited strings. Then we went to the TVP idea and saw a marked improvement (over xml we went from 15 min down to 50ms to load 800 records). It was significant for us.

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

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

SQLRNNR (8/18/2011)
Jeff Moden (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available. Not sure I'd actually use them, either, beccause of the following restriction...
Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine.
... and because if the data is already in SQL Server somewhere, I don't need to pass a TVP for that information to a stored procedure.
Admittedly, it's a bit of a personal predjudice but I also don't care for the idea of having to build a user datatype just to use a TVP. It's yet another thing to change if a slight modification to the data needs to be made.
Yeah... I know... I've gotta open up my mind and go play with the darned things. 😛 Heh... THEN I'll be able to bad mouth them! :hehe:
For us, we were using them to hold 100s and 1000s of records coming in from a webapp of data that was not yet in the database. The old method was to send an xml array to a proc and have SQL do the bulk of the work there. Then we tried delimited strings. Then we went to the TVP idea and saw a marked improvement (over xml we went from 15 min down to 50ms to load 800 records). It was significant for us.

I knew the XML method was going to be an absolute "snot slug" for performance but that 50ms to "load 800 records" using a TPV has definitely peaked my interest. Thanks, Jason.

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

Almost forgot to ask... how many "fields" did you have per "record" and what was the average length of each record in bytes for the delimited string method you were using? I'm, of course, asking so I can set up a test. Thanks again, Jason.

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