Are the posted questions getting worse?
- Sean Lange - Thursday, March 29, 2018 2:38 PM
... and if you try doing anything from your phone... Forget about it!
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
No details yet, but word has been spread that Robert Davis has died. I'm so very sorry to be the one to pass this on to you all. However, I thought you'd want to know. I understand that a GoFundMe or similar will be put together for his family. I can pass information in here as I get it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Here is the link to the GoFundMe for Robert's family in case you're interested.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning - Grant Fritchey - Tuesday, April 3, 2018 3:50 PM
I saw this on FB last night. Very sad news. 🙁
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/ - Jeff Moden - Thursday, March 29, 2018 1:35 PM
Point taken, and I've sent this along
-
A few weeks back, we were all sharing our "can you top this" pictures of potholes.
Route 30 is one of two major roads to the eastern suburbs of Pittsburgh, Last year, they attempted to add a layer of asphalt because the roadway sunk. Two weeks ago, they restricted it to one lane each way. Three days ago, the closed the entire roadway. Just in time!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ - Michael L John - Saturday, April 7, 2018 5:46 PMA few weeks back, we were all sharing our "can you top this" pictures of potholes.
Route 30 is one of two major roads to the eastern suburbs of Pittsburgh, Last year, they attempted to add a layer of asphalt because the roadway sunk. Two weeks ago, they restricted it to one lane each way. Three days ago, the closed the entire roadway. Just in time!Heh... reminds me of the song... "You take the high road and I'll take the low road..."
--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) - Michael L John - Saturday, April 7, 2018 5:46 PMA few weeks back, we were all sharing our "can you top this" pictures of potholes.
Route 30 is one of two major roads to the eastern suburbs of Pittsburgh, Last year, they attempted to add a layer of asphalt because the roadway sunk. Two weeks ago, they restricted it to one lane each way. Three days ago, the closed the entire roadway. Just in time!I'll bite. Not this year, fortunately. The collapse of Colrain road in Sandton.
It's at the bottom of a dip. The rains overwhelmed the drainage system (not uncommon, happens almost every time it rains) and washed the road support out.Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass - GilaMonster - Sunday, April 8, 2018 4:46 AMMichael L John - Saturday, April 7, 2018 5:46 PMA few weeks back, we were all sharing our "can you top this" pictures of potholes.
Route 30 is one of two major roads to the eastern suburbs of Pittsburgh, Last year, they attempted to add a layer of asphalt because the roadway sunk. Two weeks ago, they restricted it to one lane each way. Three days ago, the closed the entire roadway. Just in time!I'll bite. Not this year, fortunately. The collapse of Colrain road in Sandton.
It's at the bottom of a dip. The rains overwhelmed the drainage system (not uncommon, happens almost every time it rains) and washed the road support out.Ahhh. Crappy roads are a worldwide problem!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Hi Guys,
I'm struggling with using EXECUTE AS to assign a server-level permission to an account - could I ask somebody to see if I've just done
something stupid here, please?Thanks for your time.
-
Wow what a weekend. My oldest was playing in the North American Brass Band Association (NABBA) championships competition in Fort Wayne Indiana. He rode the bus with all the bands. My wife and I put in 2248 miles of windshield time from Thursday through Sunday afternoon. It was amazing to watch and hear some many incredibly talented musicians of all ages. My son's band got second place in the Youth Open division. Very proud of him and his accomplishments. Glad to be home but kind of wishing I had a day of relaxation before coming back to work today.
_______________________________________________________________
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/ - GilaMonster - Sunday, April 8, 2018 4:46 AMMichael L John - Saturday, April 7, 2018 5:46 PMA few weeks back, we were all sharing our "can you top this" pictures of potholes.
Route 30 is one of two major roads to the eastern suburbs of Pittsburgh, Last year, they attempted to add a layer of asphalt because the roadway sunk. Two weeks ago, they restricted it to one lane each way. Three days ago, the closed the entire roadway. Just in time!I'll bite. Not this year, fortunately. The collapse of Colrain road in Sandton.
It's at the bottom of a dip. The rains overwhelmed the drainage system (not uncommon, happens almost every time it rains) and washed the road support out.Let's play. This happened last year in Mexico city.
And after 4 months of repairing it, it took only one month to find this in the same area.
-
I saw some potholes in Philly the last two weekends, but nothing like that.
My break was coaching volleyball. Good weekend for my 14s at 5-3.
- Sean Lange - Monday, April 9, 2018 7:37 AM
Great job! I used to be in and then help with the youth brass band in the area, chaperoned one of those trips. Great fun! (and great music!)
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses - jonathan.crawford - Monday, April 9, 2018 9:53 AM
Awesome what instrument? I played in a few brass bands about a million years ago. And I started playing trumpet again. My sons music teacher invited me to play with our city brass band so picked up a cornet for the first time in 30 years less than a year ago. Played two concerts with them so far and have started playing trumpet in a local rock band. Having been a bass player in bands for the last 25 years or so this is a big change for 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 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/
Viewing 15 posts - 61,291 through 61,305 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply