Viewing 15 posts - 1 through 15 (of 21,374 total)
The easy way is to look in the SQL Server error log. It'll tell you. You can also see it in the Windows event log. Pretty sure you automatically get...
June 17, 2022 at 1:56 pm
I would not recommend pursuing replication. It's very old technology that gets almost no love from Microsoft at all. You honestly sound like a perfect candidate for Availability Groups. Yes,...
June 17, 2022 at 1:52 pm
Not a Data Factory person, but I do a lot of work in Azure.
Strong recommendation, look for videos or blogs. There are exceedingly few books written on Azure because the...
June 17, 2022 at 1:46 pm
Thank you for your response. I will research on your three suggestions.Given that the primary key is included in the non-clustered index I have the following questions.
Thank you for your response. I will research on your three suggestions.
Given that the primary key is included in the non-clustered index I have the following questions.
Just to clarify...
June 15, 2022 at 2:21 pm
Well, AI, believe it or not, Microsoft Azure is where I'd go to look. There's some amazing stuff going on there.
I'm absolutely NOT an AI expert of any kind. However,...
June 15, 2022 at 2:13 pm
You want to look at date functions like EOMONTH. Here are some samples that are pretty much what you're looking for.
June 15, 2022 at 2:09 pm
You're going to want to look at Resourced Based Policies. You can lock down an IAM to a particular resource and it can be extremely granular. Then you combine...
June 15, 2022 at 2:07 pm
I'd suggest taking a look at Redgate Data Compare. You can run it on a scheduled basis to capture changes to a given data set. You can compare it...
June 14, 2022 at 12:57 pm
I'm pretty sure this is what you want. First, create the Supplier table with a primary key, and then reference that in the constraints of the Product table. (it's...
June 13, 2022 at 6:23 pm
The major players, AWS, Azure & Google, are all priced somewhat similarly. You're unlikely to find a major price difference on them. So, I'd focus more on ensuring that you're...
June 13, 2022 at 11:50 am
I'm not sure what you mean. You're saying you want to drop the table if it exists AND some additional criteria? DROP only uses IF EXISTS. There's not a way,...
June 13, 2022 at 11:47 am
Serial is an integer. So you would use that data type in any foreign keys.
June 13, 2022 at 11:45 am
No official term that I'm aware of. Old, outdated, orphaned, junk, garbage, <insert inappropriate words here>. You can call 'em just about anything I guess. I'd probably just refer to...
June 13, 2022 at 11:42 am
If you're using psql for running your commands, then the yes, \timing turns on query time. After you connect with psql you can just type "\timing" and it will turn...
June 8, 2022 at 8:23 am
this is not a postgreSQL site - you better off posting elsewhere (or read documentation).you may or not get a reply here.
this is not a postgreSQL site - you better off posting elsewhere (or read documentation).
you may or not get a reply here.
This is the PostgreSQL forum here on SSC...
June 8, 2022 at 8:16 am