Viewing 15 posts - 961 through 975 (of 9,702 total)
ACK! A Celko article that sounds exactly as he does on the forums... Yeah, sorry. Don't think I can finish reading that one.
Interesting that Sequence won't let me...
May 22, 2017 at 6:46 am
May 22, 2017 at 6:01 am
May 22, 2017 at 5:08 am
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
Viewing 15 posts - 961 through 975 (of 9,702 total)