Thank you for making my day!  I am glad to know that they are helping.  This is a subject that is near and dear to me - helping people, especially...

@shane.green 1227 - I agree entirely, and I know I need to learn more about the differences between the systems myself!

@dgosh1 - I am glad you did!  Are you new to the field?

Hi Cebisa,

I am glad you enjoyed the article, and agree completely with your point on code review.  In fact, I think that viewpoint applies to incident resolution, change management, and...

• This reply was modified 4 years, 12 months ago by pamelamooney1966.

I agree re. the networking, etc. being a good thing.  I was curious about the possibility of virtualization because in my area (St. Louis), we haven't been able to have...

I have wondered more than once if it is time to change to virtual SQLSaturdays.  It would save the presenters needing to travel at their own expense, and might allow...

Hi Wilfred,

Thanks for your comment.  Actually, we have top notch monitoring tools where I work.  However, they don't retain the data for three months, which is what my process does...

Thanks! I will find out what is happening and see if I can get it corrected.

Hi Mischa,

I had to do it that way because some of the tables on my server are very large and partitioned.  I didn't want the row counts per partition, I...

Hi, @dbishop!

So, when you do that, what happens on my machine is the execution time actually goes up by a second (to generate the PK), and still it estimates 1...

Hi Rick,

I had actually forgotten the BEGIN and END statements to the loop, which as you pointed out, would make it run indefinitely (I had incremented the loop as you...

I am using SQL Server 2016, but I  do have the SSMS Tools Pack. I should have mentioned that in the post. Sorry for any confusion!