Viewing 15 posts - 916 through 930 (of 59,063 total)
Is there a better/more efficient way to do what the below does? It is replacing several characters that are known to be problematic for this table/column(s) with a space.
BONUS...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 23, 2023 at 3:59 am
Registration isn't open, but you can sign up: https://passdatacommunitysummit.com/twentyfour/
That way you can get the lowest price when it opens.
I do think they're pretty good about moving registration to...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 22, 2023 at 3:47 am
Just a suggestion... Keep It Super Simple and flexible at the same time.
Here's the test table (not part of the solution):
DROP TABLE IF EXISTS #TestTable;
GO
SELECT *
...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 22, 2023 at 3:36 am
We do Statistic Updates every 6h, maybe we should do this more often?
Hopefully, you're REALLY selective about which stats get updated.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2023 at 1:51 am
Actually, it could be simplified even more. Since it always tries to run on Thursdays, we don't need to figure that out. We just need to figure out if the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 21, 2023 at 1:41 am
Totally agreed.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 11:08 pm
12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.
In terms of your last question, changing logins makes changes in master. Changing...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 9:48 pm
As a bit o a sidebar, I've found that the cutover point between DELETES and COPY to a new table is actually about (depending on the table, of course) only...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 9:43 pm
Hadn't thought about that. Thanks, Scott.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 7:55 pm
Looks like they fixed it!
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 7:42 pm
Heh... pretty typical for things like this. The OP asks a question and then never participates in their own thread. While some great code has been posted, there...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 7:41 pm
Mostly but, personally, I wouldn't tolerate an RPO of 24 hours for any important data. Why are these databases in the SIMPLE Recovery Model?
these are read-only dbs. there's...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 4:29 pm
Heh... pretty typical for things like this. The OP asks a question and then never participates in their own thread. While some great code has been posted, there are still...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 4:03 pm
Although there is a solution provided to the OP that works, I have to ask what the original reason is for trying to build a string based GUID...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 4:30 am
The worst schema I had to implement: A customer wanted us to reboot the server for patches on the first friday of the month around 1am.
How do you schedule...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 20, 2023 at 1:53 am
Viewing 15 posts - 916 through 930 (of 59,063 total)