is triggers create any performance issues in Production
I am working on project where i am getting logs or data feed from outside in CSV and DAT file we have SSIS Package configured.i just wanted to create Trigger on table to reconcile table count with File count if i create triggers is it lead to performance issue? AVG CSV/DAT FILE COUNT IS 2.5 M Records
Yes, triggers will reduce your system performance by locking the tables for longer time. It is always better to look for other alternate options like CDC or handling the it manually thru' stored procedures or some other way.
Programming Entity Framework Example Not Returning Identity
Moving stored procedure from Firebird to SQL Server [closed]
VBA MS Access error 30013
VB.Net data source connection error
LINQ to SQL anomaly
Do I need to uninstall vwd 2010 express before installing vs 2010 professional?
Access Recordsets and SQL Server with Pass Through Queries - If I update a field in the recordset, does it update the server?
Insert Sub Query inside view
SQLException Foreign Key Error Getting Child Table
Connecting to local SQLserver from a local Windows managed service
What is difference between operater != and <> in SQL Server? [duplicate]
SQL Server Replication - Is it possible between two different database models?
Database Tuning Advisor: Naming of Recommended Indexes and Statistics
prefix field with letters
Can i user a where statement by first column? [duplicate]
Using list in SQL query to import data to Excel