Tag Info

New answers tagged

1

UPDATE statements in PDW are only partially parallel rather than fully parallel like CTAS. That said, this could well be down to indexing. What is the actual code that you're running? Do you have indexes in place to help find those records you're expiring? You do still need to apply some of the standard tuning techniques of applying non-clustered indexes to ...


5

A few questions. 20 million rows isn't necessarily that large. What process are you using to perform your updates and deletes right now? Is the dimension a CLUSTERED COLUMNSTORE INDEX, CLUSTERED INDEX or HEAP? Are you saying that there is movement whilst you update and delete this table or did you just see movement when you changed the table from ...


1

Being replicated doesn't stop you from using partitioning. Partition your table. Then, for the rows you need to delete or update, CTAS the entire partition into a new table, using LEFT JOIN and COALESCE to get the appropriate (i.e. new) values for updates from the changed rows while keeping the rows you want and excluding the ones you don't. Finally, ...


0

If the company owns a database and has no DBA, somebody has to be capable of auditing that database directly, without using an application program as a go-between. Either that or the company is at the mercy of whatever enterprise supplies them with their applications. That person could be an in-house member of the IT staff. It could be the company's ...


0

You need to design a webpage that will have a form as shown. Now on submit button click, you need use any server-side language like PHP/C#/Python...etc to convert those form data in a sql query. Something like INSERT INTO TABLE..... you can have some idea from these links PHP Form ASP.NET Form


0

I can understand that you feel some pieces that you are used to are missing. But that is only because they are missing. Nonetheless, SQL Server was being successfully used when Foreign Keys were just a concept (which we implemented through triggers in those days), not a physical implementation such as a constraint. Declarative Referential Integrity was ...


0

You mentioned you have 200 source tables and 225 databases. I am assuming the 200 source tables is a count of all tables from all the 225 databases (cause if you had 200 tables in each database that will put your total table count to 45000). You also mentioned that the schema of the database is the same for the 225 databases. You could build the SSIS ...



Top 50 recent answers are included