Viewing 15 posts - 7,396 through 7,410 (of 59,072 total)
Good one. But sometimes I wish there was a better row by row method available for those few times when there appears to be no other option.
Luther
You got...
April 1, 2020 at 4:34 pm
Don't get too comfortable Jeff. SQL Server on Linux was also a Steve Jones classic April Fool
Heh... I wasn't going to bring it up just for that reason. 😀 ...
April 1, 2020 at 4:23 pm
Thanks, Joe. I was reading about that in the second link I provided. Interesting bit of history that still affects us today. So, to answer the question of "When is...
April 1, 2020 at 4:20 pm
My absolute favorite scene from that movie also contains my favorite quote from the movie. Here's a link to it...
April 1, 2020 at 1:29 am
Whew!!! Nice one, Steve!! You had me going there! I was thinking that I should plan on retiring sooner than I really wanted because even the cursors in Oracle are...
April 1, 2020 at 1:19 am
Very nice collection of algorithms, Jeffrey. I've got one more for you to add to your collection.
Peter "Peso" Larsson came up with the following basic method quite a while back. ...
April 1, 2020 at 1:05 am
We have no clue by what you mean by "unexpected results".
March 31, 2020 at 8:38 pm
For me, it was the initial run of having an extra 90 million rows. 😀
March 31, 2020 at 8:35 pm
Never used geometry by I suppose some this like this
SELECT N,
GEOMETRY::STGeomFromText('POLYGON(('+CAST(N as varchar(10))+' 0, 1 1, 0 1, 0 0, 1 0))', 0)
FROM (VALUES(1))...
March 31, 2020 at 4:59 pm
Use your imagination. 😀 You can use it to figure out what causes the most blocking at certain times of the day not to mention that if you fix such...
March 31, 2020 at 3:59 pm
Open Windows Powershell ISE - this is the development tool for Powershell included with Windows 10.
You will need to include 2 variables that I excluded from the post. Those...
March 31, 2020 at 3:27 pm
It's a shame that Brent didn't subscribe to this thread because I think he's pretty much spot on.
March 31, 2020 at 1:24 pm
I recommend that f you have more than one app, use more than one service login. Each app should have it's own so you can more easily trace things like...
March 31, 2020 at 3:27 am
Just plan on such a thing doing full table scans because the JOIN criteria will become non-SARGable.
March 31, 2020 at 2:19 am
Viewing 15 posts - 7,396 through 7,410 (of 59,072 total)