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 «««3,9863,9873,9883,9893,990»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 9:27 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
Grant Fritchey (5/23/2013)
GilaMonster (5/22/2013)
Grant Fritchey (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?


Will an Arkansas tire thumper work?


No idea what one of those is, but I like the idea.


What, Google no workie?


Fraid not. Exceeded permissible quota of pigeons for the day. Additional seed ordered.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1456056
Posted Thursday, May 23, 2013 9:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:55 PM
Points: 2,656, Visits: 19,182
GilaMonster (5/22/2013)
Evil Kraig F (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?


Don't you own a katana?


Yes, but it'll damage the punching bag. The offending person is a little out of my reach.
The inference being that you wouldn't care so much about damage to the person?


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1456058
Posted Thursday, May 23, 2013 10:50 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
jcrawf02 (5/23/2013)
GilaMonster (5/22/2013)
Evil Kraig F (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?


Don't you own a katana?


Yes, but it'll damage the punching bag. The offending person is a little out of my reach.
The inference being that you wouldn't care so much about damage to the person?





Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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



  Post Attachments 
angel.gif (228 views, 379 bytes)
Post #1456102
Posted Thursday, May 23, 2013 11:02 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:31 PM
Points: 33,051, Visits: 15,159
Not that any of you care, but it's the last day of school.

I think I may be more happy than the kids to sleep in tomorrow.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1456115
Posted Thursday, May 23, 2013 11:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 7,112, Visits: 6,280
Steve Jones - SSC Editor (5/23/2013)
Not that any of you care, but it's the last day of school.


I care. It means less buses in my way driving home from work. @=)

And more kids playing in the neighborhood streets, oblivious to traffic. @=(

EDIT: Congratulations on surviving the school year and sleep well tomorrow morn, my friend. Except, don't you have horses to feed at the crack of dawn?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1456129
Posted Thursday, May 23, 2013 12:20 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 5:00 PM
Points: 22,992, Visits: 31,470
Steve Jones - SSC Editor (5/23/2013)
Not that any of you care, but it's the last day of school.

I think I may be more happy than the kids to sleep in tomorrow.


Not for everyone. My daughter still has school tomorrow, including a couple of finals still to take.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1456153
Posted Thursday, May 23, 2013 1:14 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: Yesterday @ 10:24 PM
Points: 3,997, Visits: 6,049
GilaMonster (5/23/2013)
jcrawf02 (5/23/2013)
GilaMonster (5/22/2013)
Evil Kraig F (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?


Don't you own a katana?


Yes, but it'll damage the punching bag. The offending person is a little out of my reach.
The inference being that you wouldn't care so much about damage to the person?




Don't you own a bokken?

And no... i'm not referring to the South African rugby team.


__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1456191
Posted Thursday, May 23, 2013 1:51 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:54 PM
Points: 42,434, Visits: 35,488
The Dixie Flatline (5/23/2013)
Don't you own a bokken?


Yes, they also have the tendency to damage punching bags. Edge is too narrow to use on a bag. Same with the jo.

And no... i'm not referring to the South African rugby team.


They're the Bokke...



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1456209
Posted Thursday, May 23, 2013 2:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:11 PM
Points: 12,876, Visits: 31,789


I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or not.

I just made a proof of concept CLR so that I could read a pop3 mailbox and return the results as an ITVF;
It works, and depending on my crappy mailserver's response times, i get , say the "latest" 25 emails in anywhere from 17 seconds to over two minutes.

If I was to slap out an article on it, do you think the articles focus should be on the tips and tricks of getting it to work(deep diving into the CLR code,external_access,trustworthy, why the CLR looks the way it does and requires fill functions/table definitions etc), or more on assuming they just install the assemblies, and how it could be used via TSQL?

I figure it might help the guys that like to cut boards with hammers like me, but I'm thinking the target audience is really people who want to run a script to install, and read their email box, and who cares what's under the covers.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1456210
Posted Thursday, May 23, 2013 2:15 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 13,062, Visits: 11,891
Lowell (5/23/2013)


I have a certain fondness for doing solutions in TSQL, or at least be centered around TSQL, regardless of whether it's the right tool for the job or not.

I just made a proof of concept CLR so that I could read a pop3 mailbox and return the results as an ITVF;
It works, and depending on my crappy mailserver's response times, i get , say the "latest" 25 emails in anywhere from 17 seconds to over two minutes.

If I was to slap out an article on it, do you think the articles focus should be on the tips and tricks of getting it to work(deep diving into the CLR code,external_access,trustworthy, why the CLR looks the way it does and requires fill functions/table definitions etc), or more on assuming they just install the assemblies, and how it could be used via TSQL?

I figure it might help the guys that like to cut boards with hammers like me, but I'm thinking the target audience is really people who want to run a script to install, and read their email box, and who cares what's under the covers.


I would love to read about the nitty gritty for this. Sounds like an article chock full of learning potential. Of course you would still need to have some details about how it could be used. Sounds like a great read to me!!!


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1456213
« Prev Topic | Next Topic »

Add to briefcase «««3,9863,9873,9883,9893,990»»»

Permissions Expand / Collapse