August 8, 2012 at 6:35 pm
Brandie Tarvin (8/8/2012)
Politics in the States tend to raise high emotions.
Shoot man! You should see the bloody (and I mean that literally) politics in Thailand!
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
August 9, 2012 at 4:39 am
Jack Corbett (8/8/2012)
Congrats on the work in publishing Brandie.
Thanks.
Are you goign to be at SQLSaturday Orlando this year? As of today I'll be there.
Assuming that it doesn't conflict with a writer thing I already have planned, yes. (which was pretty much what happened with both Orlando and Jax this year). Is the speaker call up yet? There have been so many I might have missed it.
August 9, 2012 at 4:46 am
Steve Jones - SSC Editor (8/8/2012)
SQLRNNR (8/7/2012)
Editor: Image removed.Link to image
http://4.bp.blogspot.com/_o5swS_a08j4/Sv0XX5UFrSI/AAAAAAAAEQc/NKWVzCsO0MY/s400/obama+short+bus.jpg
Links are OK here.
Just an FYI, I had someone complain about the humor/political nature of the image. I don't think it's a big deal, but I also don't want to broadcast political images here.
Believe what you want, vote how you wish, but looking to limit the inflammatory nature of some images.
+1 - Totally agree with the limitations on inflammatory images.
Also, I wanted to share this which has been going around the writers groups of late. Pasting images in the Thread is copyright infringement unless the picture is in public domain or owned by the person doing the posting. We complain enough about people who do CI or plagiarism on our articles. So why do we engage in such behavior with other people's pictures?
This is my own post from one of the groups I'm in. Consider this fair warning. I can totally see Red Gate not wanting to get dinged for this behavior.
Brandie's Post Elsewhere
I wanted to share this with everyone, because the subject bears repeating for those who unknowingly engage in the practice of posting photos and such. I'm not sure where embedded videos lie in the spectrum of this issue, but everyone should take a look at this post and think about what they are posting on their blogs and websites.http://www.roniloren...l#disqus_thread
And here's a blog post I wrote about the subject some years back. Note: I am not a lawyer. I'm just passing on info that I learned from one.
August 9, 2012 at 4:50 am
GSquared (8/8/2012)
Evil Kraig F (8/8/2012)
-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...I'm sure I can easily get quite a bit more verbose than a phone book...
Which leads to the existential debate of ... If your name isn't in the phone book, do you actually exist?
What happens if your name was in the phone book, but someone erased it (or worse - tore the page out)?
Think about it...
August 9, 2012 at 6:13 am
Brandie Tarvin (8/9/2012)
GSquared (8/8/2012)
Evil Kraig F (8/8/2012)
-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...I'm sure I can easily get quite a bit more verbose than a phone book...
Which leads to the existential debate of ... If your name isn't in the phone book, do you actually exist?
What happens if your name was in the phone book, but someone erased it (or worse - tore the page out)?
Think about it...
According to the telemarketers, yes, yes I do.
---------------------------------------------------------
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."
August 9, 2012 at 6:22 am
This might start your day out with a chuckle.
It sure made my day.
I had one of my users ask me to troubleshoot a query.
She said this one and several other ones had suddenly stopped working.
I got the query, and it had a date range prompt.
So I just ran it for a day, as her, and it worked fine.
When I asked what date range she was running it for, she replied '6/31/12' to '7/28/12'.
I just had to ask 'is there a new calendar out? Mine doesn't seem to have that date.'
She even had to laugh at her oversight.
Wish all my problems were so simple.
August 9, 2012 at 6:25 am
Greg Edwards-268690 (8/9/2012)
This might start your day out with a chuckle.It sure made my day.
I had one of my users ask me to troubleshoot a query.
She said this one and several other ones had suddenly stopped working.
I got the query, and it had a date range prompt.
So I just ran it for a day, as her, and it worked fine.
When I asked what date range she was running it for, she replied '6/31/12' to '7/28/12'.
I just had to ask 'is there a new calendar out? Mine doesn't seem to have that date.'
She even had to laugh at her oversight.
Wish all my problems were so simple.
A friend of mine has been buying a local calendar for years. They always include 4/31 even though he's notified them about the error. The best part is that 5/1 still is listed on the correct day.
--------------------------------------
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
August 9, 2012 at 6:27 am
Brandie Tarvin (8/9/2012)
GSquared (8/8/2012)
Evil Kraig F (8/8/2012)
-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...I'm sure I can easily get quite a bit more verbose than a phone book...
Which leads to the existential debate of ... If your name isn't in the phone book, do you actually exist?
What happens if your name was in the phone book, but someone erased it (or worse - tore the page out)?
Think about it...
When is the last time anyone here actually used a physical phone book? I think it has to have been at least 10 years. I've been watching The Rockford Files recently, from the 70s, and it is fun seeing how many plot points depend on the phone book or how hard it is to get to a phone.
--------------------------------------
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
August 9, 2012 at 7:51 am
Stefan Krzywicki (8/9/2012)
When is the last time anyone here actually used a physical phone book?
This morning.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 9, 2012 at 7:52 am
WayneS (8/9/2012)
Stefan Krzywicki (8/9/2012)
When is the last time anyone here actually used a physical phone book?This morning.
Yellow pages or white?
--------------------------------------
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
August 9, 2012 at 8:56 am
Stefan Krzywicki (8/9/2012)
Brandie Tarvin (8/9/2012)
GSquared (8/8/2012)
Evil Kraig F (8/8/2012)
-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...I'm sure I can easily get quite a bit more verbose than a phone book...
Which leads to the existential debate of ... If your name isn't in the phone book, do you actually exist?
What happens if your name was in the phone book, but someone erased it (or worse - tore the page out)?
Think about it...
When is the last time anyone here actually used a physical phone book? I think it has to have been at least 10 years. I've been watching The Rockford Files recently, from the 70s, and it is fun seeing how many plot points depend on the phone book or how hard it is to get to a phone.
A phone book makes it much easier to find the Sarah Connor you're looking for in an area...
You ever try Googleing for Sarah Conner in {city name}?
Sheesh...
😎
August 9, 2012 at 8:59 am
jasona.work (8/9/2012)
Stefan Krzywicki (8/9/2012)
Brandie Tarvin (8/9/2012)
GSquared (8/8/2012)
Evil Kraig F (8/8/2012)
-- Ignore this, bad joke that's not going to work as planned... I'm not going to get it wordy enough without copy/pasting a phone book or something...I'm sure I can easily get quite a bit more verbose than a phone book...
Which leads to the existential debate of ... If your name isn't in the phone book, do you actually exist?
What happens if your name was in the phone book, but someone erased it (or worse - tore the page out)?
Think about it...
When is the last time anyone here actually used a physical phone book? I think it has to have been at least 10 years. I've been watching The Rockford Files recently, from the 70s, and it is fun seeing how many plot points depend on the phone book or how hard it is to get to a phone.
A phone book makes it much easier to find the Sarah Connor you're looking for in an area...
You ever try Googleing for Sarah Conner in {city name}?
Sheesh...
😎
And make sure you keep on Safe Search!
If you only have a cell phone/no land line, are you even in the phone 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
August 9, 2012 at 9:07 am
WayneS (8/9/2012)
Stefan Krzywicki (8/9/2012)
When is the last time anyone here actually used a physical phone book?This morning.
...for anything other than killing a spider...
---------------------------------------------------------
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."
August 9, 2012 at 9:12 am
jcrawf02 (8/9/2012)
WayneS (8/9/2012)
Stefan Krzywicki (8/9/2012)
When is the last time anyone here actually used a physical phone book?This morning.
...for anything other than killing a spider...
Yeah, I suppose I should have said used it successfully for its intended purpose.
--------------------------------------
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
August 9, 2012 at 9:15 am
Brandie Tarvin (8/9/2012)
Steve Jones - SSC Editor (8/8/2012)
SQLRNNR (8/7/2012)
Editor: Image removed.Link to image
http://4.bp.blogspot.com/_o5swS_a08j4/Sv0XX5UFrSI/AAAAAAAAEQc/NKWVzCsO0MY/s400/obama+short+bus.jpg
Links are OK here.
Just an FYI, I had someone complain about the humor/political nature of the image. I don't think it's a big deal, but I also don't want to broadcast political images here.
Believe what you want, vote how you wish, but looking to limit the inflammatory nature of some images.
+1 - Totally agree with the limitations on inflammatory images.
Also, I wanted to share this which has been going around the writers groups of late. Pasting images in the Thread is copyright infringement unless the picture is in public domain or owned by the person doing the posting. We complain enough about people who do CI or plagiarism on our articles. So why do we engage in such behavior with other people's pictures?
This is my own post from one of the groups I'm in. Consider this fair warning. I can totally see Red Gate not wanting to get dinged for this behavior.
Brandie's Post Elsewhere
I wanted to share this with everyone, because the subject bears repeating for those who unknowingly engage in the practice of posting photos and such. I'm not sure where embedded videos lie in the spectrum of this issue, but everyone should take a look at this post and think about what they are posting on their blogs and websites.http://www.roniloren...l#disqus_thread
And here's a blog post I wrote about the subject some years back. Note: I am not a lawyer. I'm just passing on info that I learned from one.
FYI...the image was not pasted in the thread but the img tag was used and direct linked back to the original site.
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
Viewing 15 posts - 37,381 through 37,395 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply