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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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,...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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.
Just to clarify...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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,...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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,...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 13, 2022 at 11:47 am
Serial is an integer. So you would use that data type in any foreign keys.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 the PostgreSQL forum here on SSC...
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 8, 2022 at 8:16 am
Viewing 15 posts - 1 through 15 (of 21,374 total)