Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 39,016 through 39,030 (of 66,712 total)

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

I've got a poster over at AskSSC that is utterly confusing me. He's either very unclear, or I'm very obtuse or some combination of the two. If anyone with an account over there can please take a look at this, I'd appreciate it. But please, let's just be helpful, not critical.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.

School cancelled.

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Steve Jones - SSC Editor (2/27/2013)
About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.
School cancelled.

I feel your pain Steve. We have been getting snow here more like what you are used to in Colorado. We have had close to 2 feet in the last 6 days. School is cancelled yet again today. Our office even closed for a couple of days. I hope the storm you had last night does not hit us.

The snow piles in the driveway yesterday were almost 4 feet high thanks to the snowplows keeping the streets clear. :w00t:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

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

Sean Lange (2/27/2013)
Steve Jones - SSC Editor (2/27/2013)
About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.
School cancelled.
I feel your pain Steve. We have been getting snow here more like what you are used to in Colorado. We have had close to 2 feet in the last 6 days. School is cancelled yet again today. Our office even closed for a couple of days. I hope the storm you had last night does not hit us.
The snow piles in the driveway yesterday were almost 4 feet high thanks to the snowplows keeping the streets clear. :w00t:

I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 5

Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?

Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr

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

Steve Jones - SSC Editor (2/27/2013)
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?
Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.
I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr

Thanks, I'll take a look

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

Lowell SSC Guru Points: 323518 More actions · Answer 7

Steve Jones - SSC Editor (2/27/2013)
Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.
I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr

wow we use Trello in our shop, and were talking about automating the creation of cards in parallel to our internal work order system.

this is well timed, thanks Steve

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

Lowell (2/27/2013)
Steve Jones - SSC Editor (2/27/2013)
Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.
I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr
wow we use Trello in our shop, and were talking about automating the creation of cards in parallel to our internal work order system.
this is well timed, thanks Steve

Cool, now you ask a question so I can get a perfectly timed answer. 🙂

I actually think I have a good start, but need to install or activate AJAX on the machine.

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

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 9

Lowell (2/27/2013)
Steve Jones - SSC Editor (2/27/2013)
Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.
I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr
wow we use Trello in our shop, and were talking about automating the creation of cards in parallel to our internal work order system.
this is well timed, thanks Steve

YW, let me know if it works. Passed it along to our group internally as well.

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

Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?

Have at look at these:

http://www.amazon.com/Expert-SQL-Server-2005-Development/dp/159059729X (not the 2008 version!)

http://www.amazon.com/Server-2005-Assemblies-Experts-Voice/dp/1590595661

If the target is SQL Server 2008:

http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer(v=vs.90).aspx

You might find this article interesting too:

https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (2/27/2013)
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?
Have at look at these:
http://www.amazon.com/Expert-SQL-Server-2005-Development/dp/159059729X (not the 2008 version!)
http://www.amazon.com/Server-2005-Assemblies-Experts-Voice/dp/1590595661
If the target is SQL Server 2008:
http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer(v=vs.90).aspx
You might find this article interesting too:
https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

Thanks! I'll take a look.

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

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

Paul White (2/27/2013)
Stefan Krzywicki (2/27/2013)
I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?
Have at look at these:
http://www.amazon.com/Expert-SQL-Server-2005-Development/dp/159059729X (not the 2008 version!)
http://www.amazon.com/Server-2005-Assemblies-Experts-Voice/dp/1590595661
If the target is SQL Server 2008:
http://msdn.microsoft.com/en-us/library/system.runtime.serialization.json.datacontractjsonserializer(v=vs.90).aspx
You might find this article interesting too:
https://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/

Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?

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

Revenant SSC-Forever Points: 42467 More actions · Answer 13

Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?

They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.

Edit: formatting of the quote.

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

Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?
They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.
Edit: formatting of the quote.

I believe it is also available in 3.5, but I can't include the reference in a C# or VB database project. I can in a Windows Forms project though. I think I need to re-register ServiceModel.exe

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

Revenant SSC-Forever Points: 42467 More actions · Answer 15

Stefan Krzywicki (2/28/2013)
Revenant (2/28/2013)
Stefan Krzywicki (2/28/2013)
. . .
Do you know how I get either System.Runtime.Serialization.Json or System.Web.Script.Serialization installed on my machine? I've run across implications that they're part of AJAX. Are they? Will they be available if I install AJAX or is there more I need to do?
They are available in Framework 4 and 4.5. You have to include the System.Runtime.Serialization assembly.
Edit: formatting of the quote.
I believe it is also available in 3.5, but I can't include the reference in a C# or VB database project. I can in a Windows Forms project though. I think I need to re-register ServiceModel.exe

I tried WCF projects in both VS 2010 and 2012 and they all have the assembly included in the template.

What type of project are you working with, Stefan?