September 21, 2009 at 6:30 pm
Roy Ernest (9/21/2009)
So the standard will be pretty high...
Well it is called SQL Server Standard 😀
Atlantis Interactive - SQL Server Tools
My blog[/url]
Why I wrote a sql query analyzer clone
September 21, 2009 at 7:23 pm
Roy Ernest (9/21/2009)
Damn... Thats pretty good. 🙂 So the standard will be pretty high... Then my article is probably going to be rejected... :hehe:
I'm not sure how high the standard will be. Look at who they have running the silly thing.
"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
September 22, 2009 at 4:57 am
How much can you receive for aricles posted here?, just out of comparision 😀
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 22, 2009 at 5:35 am
Silverfox (9/22/2009)
How much can you receive for aricles posted here?, just out of comparision 😀
Less, but the article length requirement here is not as long. You don't go through a technical editing process. You don't go through a copy editing process... In short, you'll earn that other money and if you break it down on a hourly basis... You get paid more here.
"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
September 22, 2009 at 8:34 am
SSC pays $25.00 for each published article. The last two articles I have had published here were done for free as I had originally published them on sswug.org, which pays more but actually provides much less exposure.
My "Deleteing Large Number of Records" article, for instance, has had 1082 views on sswug.org since being published on 5/26/2009 compared to 16,500 since being published here on SSC on 9/15/2009. My other article, "The Dynamic Tally or Numbers Table", republished today on SSC has had 624 views since being published on 6/1/2009 on sswug.org compared to 1,685 view already here.
You have to decide which is more important. I still want to write for sswug.org, but I also want to write for ssc as well. I will have balance what I write and for whom. The content of these last two articles I really felt should have had better exposure than the got on sswug.org because of the content.
September 22, 2009 at 8:36 am
Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something wrong with my browser (entirely possible since the company has me stuck on IE 6).
"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
September 22, 2009 at 8:38 am
Grant, Bitbucket just pointed out to me that you're coming to my hometown in a couple weeks! Can't wait to see you speak in Columbus, recruiting the rest of my workplace to come check it out too...:-D
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"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."
September 22, 2009 at 8:52 am
Grant Fritchey (9/22/2009)
Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something wrong with my browser (entirely possible since the company has me stuck on IE 6).
I am getting errors... I cant even get on that link
-Roy
September 22, 2009 at 8:55 am
Roy Ernest (9/22/2009)
Grant Fritchey (9/22/2009)
Hello Threadites. Can someone check this. I can only see a single SPID in the deadlock information posted here, but someone else is seeing lots more. Is something wrong with my browser (entirely possible since the company has me stuck on IE 6).I am getting errors... I cant even get on that link
Roy here's a better link...
http://www.sqlservercentral.com/Forums/Topic791600-360-1.aspx#bm791786
September 22, 2009 at 9:03 am
jcrawf02 (9/22/2009)
Grant, Bitbucket just pointed out to me that you're coming to my hometown in a couple weeks! Can't wait to see you speak in Columbus, recruiting the rest of my workplace to come check it out too...:-D
Well there's coming to town and there's coming to town. I'll be speaking to Columbus from Grafton, Massachusetts. We're doing a live meeting. Should be fun though.
"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
September 22, 2009 at 11:56 am
Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure that I'm on the right track. I don't think it has to do with out of whack stats, but re-use of a poor execution plan.
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
September 22, 2009 at 12:06 pm
Jack Corbett (9/22/2009)
Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure that I'm on the right track. I don't think it has to do with out of whack stats, but re-use of a poor execution plan.
I was watching that one because I was quite honestly stumped by the question.
"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
September 22, 2009 at 1:45 pm
Grant Fritchey (9/22/2009)
jcrawf02 (9/22/2009)
Grant, Bitbucket just pointed out to me that you're coming to my hometown in a couple weeks! Can't wait to see you speak in Columbus, recruiting the rest of my workplace to come check it out too...:-DWell there's coming to town and there's coming to town. I'll be speaking to Columbus from Grafton, Massachusetts. We're doing a live meeting. Should be fun though.
Some (not me, of course) would suggest that this is preferable to visiting...:hehe:
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"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."
September 22, 2009 at 2:51 pm
Grant Fritchey (9/22/2009)
Jack Corbett (9/22/2009)
Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure that I'm on the right track. I don't think it has to do with out of whack stats, but re-use of a poor execution plan.I was watching that one because I was quite honestly stumped by the question.
Hmmm, and I thought I got the answer I gave from your book :-D. Maybe it was from a blog post somewhere.
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
September 22, 2009 at 5:20 pm
Jack Corbett (9/22/2009)
Grant Fritchey (9/22/2009)
Jack Corbett (9/22/2009)
Anyone want to take a look at this one? It's about statistics aging and query performance. I gave an answer, but I'm not sure that I'm on the right track. I don't think it has to do with out of whack stats, but re-use of a poor execution plan.I was watching that one because I was quite honestly stumped by the question.
Hmmm, and I thought I got the answer I gave from your book :-D. Maybe it was from a blog post somewhere.
I'm not going to take credit for it, but it's entirely possible that's the issue. Actually you should have the OP see if he's seeing recompiles of the procedure rather than focusing on the statistics.
"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
Viewing 15 posts - 8,206 through 8,220 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply