I had to go to wikipedia to get a good definition of data governance:

https://en.wikipedia.org/wiki/Data_governance

There appears to be several areas affected by it:

1. Quality through constraints and process controls.

2. Protection through...

This is from t-sql help and I believe it works with trigger objects too:

USE AdventureWorks2008R2;

GO

IF OBJECT_ID ( 'usp_FindName', 'P' ) IS NOT NULL

DROP PROCEDURE usp_FindName;

GO

CREATE PROCEDURE usp_FindName

...

https://www.simple-talk.com/sql/sql-tools/sqlxml-bulk-loader-basics/

I came across the article above today and the author says he deals with importing tens of gigs at a time. I think XML might be ideal for this...

SqlServer is the wrong tool for the job if you want compiled speed. I suggest using a compiled console app that pre-processes your file so each row will have...

I think you have it designed backwards. A JobRequest row should have a PrimaryKey of JobRequestKey. A JobRequisitions row should have a foreign key column called JobRequestKey that...

Eureka! I think I figured out what you're trying to do.

DECLARE @Names TABLE (LastName varchar(50) NOT NULL);

INSERT into @Names values ('Robertson'), ('Johnson'), ('Smith'), ('Smithwyck'), ('Miller');

DECLARE @searches TABLE (token VARCHAR(50)...

It works fine for me either way, with or without the WHERE clause.

I never use the old join syntax...and actually I don't see the join in your updates.

The first doesn't work because you are trying to select every row from s1.

The second...

I see you prefix your constraints with pk, uk, ak, etcetera. May I suggest you begin almost all objects with TableName and just use suffixes. That way you...

You can set an index option to Ignore_dupe_key but with a constraint you may need to disable it or drop it.

I think it will work. Multi-column primary keys fry my brain on gnarly queries. I think that is why you did not follow names through to lower tables.

I...

You are SELECTing a.*, b.*

In other words you are showing data from two source rows in one result row. You must use a join.

I'm working on a problem similar to this one and solved it using a similar technique. I have millions of pdf attachments and there was a developer bug where...

So far I believe the 58 GB max size comment has been the best empirical statement of how to fix the problem. I'm wondering why that hypothesis hasn't been...

I changed all my 450 tables from clustered to heap and got a big boost in efficiency. Most of my customers have several hundred gigs of data but only...