Viewing 15 posts - 961 through 975 (of 9,698 total)
Is anyone else having an issue with getting the new generic powerpoint template from SQLSaturday.com? I keeping getting a 'cannot open powerpoint out of memory' kind of error.
May 22, 2017 at 5:07 am
May 22, 2017 at 4:47 am
May 19, 2017 at 5:12 am
Thank you everyone for your answers. They are very informative. I'll get with my co-worker and we'll discuss this (it's his code but I was advising him on the dynamic...
May 19, 2017 at 5:10 am
GAH. Why is there always ONE?
One person who "thoughtfully" hits REPLY ALL to an outage alert email, starting the trend of other people asking questions to the whole...
May 18, 2017 at 9:28 am
May 18, 2017 at 5:23 am
It was that extra file reason why I went with the CASE statement instead of just adding the plus 1. But then, I had forgotten about CEILING since I never...
May 18, 2017 at 5:03 am
jonathan.crawford - Wednesday, May 17, 2017 9:09 PMEmail server's down, I sent you an email about it.
I actually once had someone tell...
May 18, 2017 at 4:25 am
FridayNightGiant - Wednesday, May 17, 2017 12:47 PMI'd do it like this
SELECT CEILING(COUNT(*)/750000.00) AS FileCount
FROM dbo.Mytable
Ah. Forgot about that...
May 17, 2017 at 12:50 pm
SELECT COUNT(*)/750000 AS FileCount
FROM dbo.MyTableMay 17, 2017 at 12:40 pm
So here's how I got it to work.
I created two variables, @FileCount (set at 0) and @LoopCounter (set at 1). Using a T-SQL task with the below code,...
May 17, 2017 at 11:24 am
Yes, we could set the reply to but we don't want out of office messages and such hitting our inboxes. So we make them forward the email to us.
May 17, 2017 at 5:21 am
Sorta technical question that is more of the curious variety.
When you have to set up an automated email from a SQL server job to either a business unit customer...
May 17, 2017 at 4:47 am
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
May 16, 2017 at 11:02 am
<headdesk>
Feeling really stupid now.
I've done this before. Back in 2005 or 2006. This fact finally dawned on me after staying away from this project for a...
May 16, 2017 at 10:55 am
Viewing 15 posts - 961 through 975 (of 9,698 total)