Viewing 15 posts - 5,206 through 5,220 (of 59,068 total)
I agree with that... but only 99.9% of the time., 😀 "It Depends".
May 25, 2021 at 12:49 am
GETDATE(), GETUTCDATE(), etc., are niladic nondeterministic functions.
A niladic function has no parameters. A nondeterministic function returns different values with the same inputs (the exact results of a GETDATE() call cannot...
May 24, 2021 at 5:23 pm
Gosh... I agree that it's been quite a while but it seems to me that SQL Server 6.5 and 7 worked just fine in this area and I've...
May 24, 2021 at 4:46 pm
Ah. Got it. It's an interesting question and, hopefully, someone will come back with the answer. If nothing else, this post will act as a "bump" for it. 😀
May 24, 2021 at 1:47 pm
I've not yet learned how to even spell "Azure" but a quick web search led me to the following article. From your description, I'm thinking it contains the information you...
May 24, 2021 at 6:36 am
Gosh... I agree that it's been quite a while but it seems to me that SQL Server 6.5 and 7 worked just fine in this area and I've not had...
May 24, 2021 at 6:29 am
But for backups initiated by 3rd party tools, I wonder if setting up the alert in SQL agent will it able to capture any failures as well?
Have you looked...
May 24, 2021 at 6:27 am
Hi,
You can use the undocumented function sys.fn_dblog() to identify the insert time from the transaction log.
Please refer to the following link for more details.
https://dba.stackexchange.com/questions/189485/how-can-i-find-time-of-an-insertion#:~:text=2%20Answers&text=You%20can%20find%20INSERT%20time,name)%20in%20the%20result%20set.
Thanks.
It'll be interesting to try to...
May 23, 2021 at 2:24 am
First of all, if missing a single T-Log backup causes the T-Logs to grow too large, then you folks need to sit down and come up with some extra space...
May 22, 2021 at 3:08 pm
This is how I solved the issue:
use InputDatabase;
run my scripts where my inserts look like this:
insert into OutputDatabase.Scheme.Table
I still don't understand why it matters so much if the current...
May 22, 2021 at 2:45 am
Hi,
I have to import csv files with hundreds of columns and only few thousands of records. The flat file import wizard does not do full sampling and may identify...
May 22, 2021 at 1:11 am
Thank you Phil.
Would it be advisable to do it in SQL server itself, as we have some senior management they opted to use SQL server only (son interms of...
May 22, 2021 at 12:54 am
Really helpful in understanding the topic.The content is good and understandable.
Awesome!. What did you actually like about "the content" and how was it "really helpful"?
May 21, 2021 at 2:02 pm
Large amount of email recipients (> 5000 per row). Final count of split values was ~73 million records
Been there and done that in the past! Thank you for the...
May 21, 2021 at 1:56 pm
I'[m always curious... what is the data in the VARCHAR(MAX) column that is being split? Thanks.
May 20, 2021 at 11:27 pm
Viewing 15 posts - 5,206 through 5,220 (of 59,068 total)