Viewing 15 posts - 1,171 through 1,185 (of 59,066 total)
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
Hi,
I am looking for a sql help to generate one row per each sequental door_area, for a given employee, based on the sample data that looks like this:
Current Output:
August 24, 2023 at 3:14 am
Why bother storing something that you can calculate out when you query the data?
To get sheer, blinding, speed. It's the basic method that Pre-Aggregation through Indexed Views work. Of...
August 24, 2023 at 1:01 am
Hi All,
We are trying to delete data from a large 5TB log table. We are able to delete the data but that is not shown up in the free...
August 24, 2023 at 12:39 am
Hi Phil Parkin,
This is working on the sample data I created.
But If I apllied on my original table I am getting below error.
Invalid length parameter passed to the...
August 23, 2023 at 5:16 pm
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok......
August 23, 2023 at 4:47 pm
Ok... let's all gather hands in a circle around Thom and repeat the DBA prayer with me...
I'm not sure the strength will help me as it's likely to...
August 23, 2023 at 3:34 pm
At my new position, DISTINCT is the default for every query. Nobody knows why they do it. There is a fairly large group who is 100% dedicated to creating...
August 23, 2023 at 3:22 pm
As we're sharing "new job" pains, we're likely going to be are taking responsibility of IT services for our parent company in the month months (years).
Ok... let's all...
August 23, 2023 at 3:11 pm
Trying to imagine a scenario where I worked with Jeff Moden and tried to call out his code...
Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS....
August 23, 2023 at 3:03 pm
Understood. That's why I suggested that your first take on the subject is probably your best take.
To prevent any overlapping of old vs new, leave everything you currently have alone. ...
August 23, 2023 at 1:45 am
Viewing 15 posts - 1,171 through 1,185 (of 59,066 total)