Viewing 15 posts - 1 through 15 (of 78 total)
Thank you for that info. Not quite at the level of detail that I was looking for but VERY GOOD information none-the-less!!
I definitely didn't know about the default traces...
August 4, 2016 at 3:27 pm
It's not so much that they should not, I'm just trying to verify when. Their access is good.
I've setup auditing for the DB/Table I need info on so, I'll...
August 3, 2016 at 4:04 pm
I wish it was as easy as sending an email...
August 3, 2016 at 1:48 pm
I did see an article on setting up auditing but thought there was another option.
Is auditing the best way to capture that or setting up Profiler the way to do...
August 3, 2016 at 1:42 pm
Thanks Alvin for the follow up.
Yes, there is an expression in the report name:
=SrsResources.Localization.GetString("Report248_Name", User!Language) + " "
I'm not sure how the report name is derived from that expression,...
July 2, 2015 at 10:41 am
Sorry, I've been kind of out of the loop but it would be rude for me not to express my appreciation.
I ended up making some changes in the...
February 23, 2015 at 8:47 am
Thank you Kevin!!
I think I need to sharpen my skill on really understanding fragmentation...
January 26, 2015 at 9:47 am
Thank you guys for your reply!
So, you're saying that I shouldn't worry about the avg_fragmentation_in_percent number in my result set? I'm trying to setup routine maintenance and just want to...
January 23, 2015 at 4:26 pm
I'm thinking more along the lines of:
.mdf = master data file
.ldf = log data file
.ndf = "next" data file
🙂 Crazy I know...
January 16, 2015 at 2:26 pm
I'm actually returning data with single quotes in the string. So, in my query, I'm including a column name "Reason" and the data in that column, pretty much every row,...
April 18, 2014 at 8:42 am
While I have your attention, do you have any suggestions on how I can query on a value with a single quote in the middle of a string of text?
April 17, 2014 at 8:11 am
Thanks for your suggestion. You are pretty much correct. I figured out the problem to be related to the parameter.
The table has over 40 million rows and one...
April 17, 2014 at 7:55 am
Thank you all for your input.
I was able to resolve issue.
It wasn't a straight forward approach but it worked.
The problem appeared to be related to concatenating the result set...
May 10, 2013 at 4:14 pm
Great Information GoVelo!
Thank you. That's about as close to what I needed as I've gotten.
March 8, 2013 at 3:24 pm
Thank you very much for your advice.
I will look into those options to see how they might work for me.
March 5, 2013 at 7:05 pm