Viewing 15 posts - 1,171 through 1,185 (of 59,066 total)
jonathan.crawford wrote:Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
That would make a very viral video!!!!!!!!!
I know it's been...
September 1, 2023 at 11:01 pm
Off-topic, but awesome to SEE Jeff Moden after all these years! The YT vid was a bit over my head but still fascinating.
I've PM'd you to ask a favor,...
August 31, 2023 at 9:56 pm
Shift all parameters 1.5 bytes to the left and start the run. In 30ms, stop the run and then restart it. Note that you have to do...
August 31, 2023 at 8:46 pm
DAMMIT!! I make one, ONE, typo on parameter 137 and suddenly I find myself here in the FUTURE!!
Does anyone still follow this thread, and if so, can you...
August 30, 2023 at 10:44 pm
Posting to get Johan's answer to show up. It was the first post on a new page and this forum still has the problem of not showing the first post...
August 30, 2023 at 2:59 pm
The only time you might want to do a rebuild on a system (or any other database) is if you need to recover a lot of disk space. You check...
August 30, 2023 at 5:23 am
Windows 11 PRO??? You need to have a Windows Server. I'm surprised that your SQL Standard Edition even runs on that desktop edition.
TBH, I'm thinking it might be automatic reboots...
August 29, 2023 at 3:26 pm
Does it make any difference with the on-going open transactions to the database? is it better to do during maintenance windows when there are no incoming connections from the...
August 28, 2023 at 9:05 pm
A shrink that large will take a long time, especially if there's a fair bit of LOBs in the data. Worse yet, you won't be able to see any progress...
August 28, 2023 at 4:08 pm
August 28, 2023 at 2:30 pm
I think I'll go to the other extreme. I am waiting for eye surgery right now, so there will be a little delay, but I will develop an article...
August 28, 2023 at 1:21 am
After more than 2 decades of having CPU's that have some serious math co-processors, you'd think they change the code for the floating point math that occurs in the NUMERIC...
August 25, 2023 at 5:34 pm
For example, we actually have Express edition installed at 1,000+ point of sale locations and rely on a 3rd party backup solution just for the encryption.
Now THAT sounds like...
August 25, 2023 at 5:07 pm
We are trying to delete data from logging table which has grown upto 7 TB. App team now decided to delete the data based on some filters. As they...
August 25, 2023 at 12:09 am
What is preventing you from trying it and then reporting back here for all our benefit?
NTS:PPTS
August 24, 2023 at 11:42 pm
Viewing 15 posts - 1,171 through 1,185 (of 59,066 total)