Viewing 15 posts - 1,156 through 1,170 (of 59,061 total)
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
As a bit of a sidebar, if you don't want historical data to ever change, partition the tables (file and filegroup) and make the older files "Read Only". It also...
August 24, 2023 at 11:37 pm
We did go with a conversion table, this way we could eliminate some bad words or abbreviations. I don't think we had anything that would go out with that...
August 24, 2023 at 11:20 pm
Viewing 15 posts - 1,156 through 1,170 (of 59,061 total)