June 8, 2018 at 10:05 am
You know who I haven't seen posts from in a while?
The canine from Cardiff...
June 8, 2018 at 10:14 am
jasona.work - Friday, June 8, 2018 10:05 AMYou know who I haven't seen posts from in a while?
The canine from Cardiff...
And it has been so nice. Now that you mentioned it the posts will be coming shortly I am sure. 😛
_______________________________________________________________
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/
June 8, 2018 at 10:26 am
Sean Lange - Friday, June 8, 2018 10:14 AMjasona.work - Friday, June 8, 2018 10:05 AMYou know who I haven't seen posts from in a while?
The canine from Cardiff...And it has been so nice. Now that you mentioned it the posts will be coming shortly I am sure. 😛
But it will give Lynn and Gail such *joy* to deal with him / them / her!
June 11, 2018 at 12:30 am
Just a heads up: in today's newsletter, the "database pros who need help" section had 5 legit posts; the rest were all spam posts.
Having the spam in the forunm is bad enough. Advertising it in the news letter .... not the best idea!
June 13, 2018 at 12:13 am
Crud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs would be the worst possible index to fix and they're not. I knew that there were a couple classes of indexes that were worse but it turns out that supposedly "normal" indexes are actually much worse. I've had to pull all of my SQL Saturday submittals on the subject. Totally embarrassing oversight on my part.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2018 at 2:13 am
Jeff Moden - Wednesday, June 13, 2018 12:13 AMCrud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs would be the worst possible index to fix and they're not. I knew that there were a couple classes of indexes that were worse but it turns out that supposedly "normal" indexes are actually much worse. I've had to pull all of my SQL Saturday submittals on the subject. Totally embarrassing oversight on my part.
Far better you notice it now though, than doing a presentation and then someone else (shortly afterwards) proving you wrong. Plus, you've learned something, which is always invaluable too. 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 13, 2018 at 6:13 am
Jeff Moden - Wednesday, June 13, 2018 12:13 AMCrud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs would be the worst possible index to fix and they're not. I knew that there were a couple classes of indexes that were worse but it turns out that supposedly "normal" indexes are actually much worse. I've had to pull all of my SQL Saturday submittals on the subject. Totally embarrassing oversight on my part.
I'd offer to assist but not sure if I can find the band width at the moment.
June 13, 2018 at 6:15 am
Can't remember who mentioned the spam reporting tip (report the same thread 3 times), but it worked a charm last night.
June 13, 2018 at 8:58 am
The threshhold is 3 points, of which a report from most of you is 1. I get 3, so I try to tag them as I find them.
June 13, 2018 at 12:17 pm
Jeff Moden - Wednesday, June 13, 2018 12:13 AMCrud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs would be the worst possible index to fix and they're not. I knew that there were a couple classes of indexes that were worse but it turns out that supposedly "normal" indexes are actually much worse. I've had to pull all of my SQL Saturday submittals on the subject. Totally embarrassing oversight on my part.
wait, so now you're not coming to Columbus?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
June 13, 2018 at 1:09 pm
jonathan.crawford - Wednesday, June 13, 2018 12:17 PMJeff Moden - Wednesday, June 13, 2018 12:13 AMCrud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs would be the worst possible index to fix and they're not. I knew that there were a couple classes of indexes that were worse but it turns out that supposedly "normal" indexes are actually much worse. I've had to pull all of my SQL Saturday submittals on the subject. Totally embarrassing oversight on my part.wait, so now you're not coming to Columbus?
He's coming, but his presentation might lend itself to some serious heckling from the audience!
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/
June 13, 2018 at 1:20 pm
Ugh.
The joy of spending a day waiting for someone to get in touch with someone on their end who can hopefully resolve a connectivity issue to a remote (linked) server...
Can't use SSIS to pull the data across, the customer on this end needs it "live," and we'd still be stuck waiting for the connection problem to be resolved...
Even worse, I feel like I'm pestering the poor guy (who's just as stuck waiting to hear) on the remote end when I e-mail a "just touching base, any word yet," every couple hours.
My boss won't even take the bet that I'll finally hear from them at 10:45am tomorrow morning, just as I'm thinking about packing it in to go to the company picnic, that the teleconference to work the issue is scheduled for 2:30pm tomorrow afternoon...
And I'm off on Friday...
June 13, 2018 at 6:47 pm
Going to a picnic and taking a day off in the midst of issues... Am I sensing a serious lack of job devotion here??? 😀
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 13, 2018 at 7:59 pm
Michael L John - Wednesday, June 13, 2018 1:09 PMjonathan.crawford - Wednesday, June 13, 2018 12:17 PMJeff Moden - Wednesday, June 13, 2018 12:13 AMCrud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs would be the worst possible index to fix and they're not. I knew that there were a couple classes of indexes that were worse but it turns out that supposedly "normal" indexes are actually much worse. I've had to pull all of my SQL Saturday submittals on the subject. Totally embarrassing oversight on my part.wait, so now you're not coming to Columbus?
He's coming, but his presentation might lend itself to some serious heckling from the audience!
I can still go to Columbus but it will be sans the presentation. You still interesting in meeting there Jonathon? If so, I'll re-register (I unregistered because I no longer deserve the free lunch ticket).
Hmmm... I think this will be the first ever SQL Saturday I've gone to where I wasn't presenting. Just might be an enjoyable thing!
--Jeff Moden
Change is inevitable... Change for the better is not.
June 13, 2018 at 8:12 pm
WayneS - Wednesday, June 13, 2018 6:47 PMGoing to a picnic and taking a day off in the midst of issues... Am I sensing a serious lack of job devotion here??? 😀
Well, the day off is the way my schedule is (8x days at 9hrs a day, 1x day at 8hrs, and one day off in every 2 week pay period,) and as for the picnic, if I do get the call about it before I've left, then I'm working the problem, not the picnic, so...
😉
Viewing 15 posts - 61,666 through 61,680 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply