November 2, 2011 at 12:38 pm
WayneS (11/2/2011)
Stefan Krzywicki (11/2/2011)
Thanks, I know I don't know everything and I might be reading things wrong, it helps to have extra opinions, especially from people who know what they're doing.Man, have we got you completely confused now. :-D:w00t:
I'm still hoping some of them respond. 😀
(I knew someone would make that joke.)
--------------------------------------
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
November 2, 2011 at 12:39 pm
Stefan Krzywicki (11/2/2011)
I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run any index defragmenting jobs, they just have one that sees if an index needs to be rebuilt and does the rebuild if it does.Am I over-reacting or does that sound like someone that doesn't really know what they're doing?
Sounds like they know how to run a script.
Maybe check and see if this is what they provide.
November 2, 2011 at 12:47 pm
Greg Edwards-268690 (11/2/2011)
Stefan Krzywicki (11/2/2011)
I'm trying to find out what a support service is doing for some databases that another group here uses. We got a response that they haven't done run any index defragmenting jobs, they just have one that sees if an index needs to be rebuilt and does the rebuild if it does.Am I over-reacting or does that sound like someone that doesn't really know what they're doing?
Sounds like they know how to run a script.
Maybe check and see if this is what they provide.
To be fair, that's a good script. 🙂
I think it is something they do through the SAP interface. That's how they're doing the CheckDB.
My concern comes primarily from the lack of information in the response. They say they run a specific check in SAP for CheckDB, but don't mention what they do with the results. They don't seem to know that you need to monitor index fragmentation. They have a job that checks, but they've never run it. They answer the questions asked, in a limited way, and volunteer no other information.
--------------------------------------
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
November 3, 2011 at 9:31 am
Agree that is a good script, I use it myself from time to time.
They sound like you are an auditor, and they don't want to tell too much.:-D
November 3, 2011 at 11:04 am
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
And why is your name not on it?
I look forward to getting a copy.
November 3, 2011 at 11:10 am
Brandie Tarvin (11/3/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
And why is your name not on it?
Because I was the tech editor, not author.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 3, 2011 at 11:15 am
GilaMonster (11/3/2011)
Brandie Tarvin (11/3/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
And why is your name not on it?
Because I was the tech editor, not author.
There should be a mention in there somewhere for Gail 😉
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
November 3, 2011 at 11:16 am
L' Eomot Inversé (9/30/2011)
Brandie Tarvin (9/28/2011)
Speaking of writing, follow this link if you like high fantasy and want to read a story (for free!) from me. http://www.storyportals.com/series/katya-lady-assassinWhy, yes. This is a shameless self-promotion plug!
As long as it's not shameful, self-promotion is no bad thing. And I liked the story.
However, the series blurb is appalling; whoever wrote that needs to attend a good course on the English language and in particular how its punctuation works. If you read that thing out loud with the pauses indicated bythe punctuation you'll see thast it makes no sense. If however you ignore the punctuation and guess where the pauses might be it sort of makes sense.
I will go back to the site and check that out. I haven't read the site blurb. Too busy writing.
I'm glad you enjoyed the story.
November 3, 2011 at 11:18 am
Jack Corbett (10/1/2011)
Hey guys I got some really cool news today. I was awarded MVP status!I just hope I can honor that award the way that all the MVP's on here already do!
Jack, you are stellar! Congratulations! That is well deserved.
November 3, 2011 at 11:20 am
Anyone know a good source for on-line SSIS help?
I'm having a problem with the speed of my main SSIS load package and would love to find out what I'm doing wrong or how to improve the speed. There don't seem to be many SSIS experts here, though we're rife with nearly every other kind of SQL Server expert. Or am I just posting in the wrong area?
--------------------------------------
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
November 3, 2011 at 11:21 am
GilaMonster (10/3/2011)
SQLRNNR (10/3/2011)
GilaMonster (10/3/2011)
It's not the only one.http://www.sqlservercentral.com/articles/T-SQL/70809/
and
http://weblogs.asp.net/dotnetstories/archive/2011/09/24/take-an-asp-net-application-offline.aspx
Wow, this guy is a real class act. I wonder what EMC thinks about it?
From what I could see (with a few quick google searches), every post is a direct copy-paste from elsewhere.
Guys, I don't know if this is the same person I spotted two years ago, but when I reported it to Simple Talk, they told me it was the same author who uses a pen name and he was just reposting what he'd written.
Might want to check with them first before talking smack about this guy.
November 3, 2011 at 11:24 am
SQLRNNR (11/3/2011)
GilaMonster (11/3/2011)
Brandie Tarvin (11/3/2011)
GilaMonster (9/29/2011)
Wooooooooot!!!!!!!!!!!!!!!!!!2 years, many, many weekends, late nights and a mad rush to the end (and I'm not even counting the ones Jonathan did), it's here
And why is your name not on it?
Because I was the tech editor, not author.
There should be a mention in there somewhere for Gail 😉
Front cover, bottom right, pages x, xii, xiii and xiv (that's in the ebook)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 3, 2011 at 11:24 am
Sean Lange (10/3/2011)
This one (http://codevc.com/19244_A_The_WebGrid_Helper_-_Making_Selections.aspx) is a classic. The images are replaced with "Thief" image because they were lifted. The link in the article to "My previous article" even points correctly to the domain where the images were stolen from. Sheesh!!
Okay, how did they get that to work? I'd love to put it on some of my stuff.
November 3, 2011 at 11:32 am
Jeff Moden (10/5/2011)
"How do you return the current date and time from SQL Server using T-SQL?"...
The answer the interviewee returned was "I don't know... we always used the GUI code to do that."
I always thought the answer was "bribe the senior dba with cookies."
@=)
November 3, 2011 at 12:02 pm
Quick question. Has anyone else been approached by John Millward of Callidus Technology Limited for permission to use your SQL Articles on a social networking site he's putting together?
The site isn't up yet. It is, in his words:
Effectively this is going to create a social network for those people within public sector organisations who have an interest in the production of reliable and trusted information. There is a situation over here where public funds are tight and our aim is to create an online community for sharing ideas and developments around producing such information. Primarily the systems used are increasingly SQL Server based with a move away from Oracle. There are few SQL skills employed permanently within these organisations so access to reliable and accurate technical articles such as yours would provide a useful resource.
I'm having a hard time grasping why a social networking site would be putting technical articles on it. I've been invited to join the community, which would be nice if I had time. And the fact that he's asking permission actually scores him bonus points.
But I'm going back and forth on giving permission. Partly because the site isn't complete yet and I can't see how my articles would be used. But mainly because there are so many SQL experts around the world, including you lot, and I wouldn't classify myself so highly yet (so much more for me to learn).
So, if he's asked you, please let me know. That will make me feel so much better about this whole thing.
Viewing 15 posts - 31,351 through 31,365 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply