Thanks for the great article and the code that goes with it.

Is there a reason why you chose a VARCHAR(8000) instead of a VARCHAR(MAX)? I modified the provided...

Thanks for the script. It seems to cover most cases easily. I do have a suggestion. I recently worked on importing data from a similar script and...

Thanks for the great series of articles. I started using the extended properties when I got a tool that would create database documentation based on those properties.

I found that...

I agree that the UI layer should be passing the correct combination, and there is a problem if it is not. From a defensive programming standpoint, you have created...

The original code updates every record for the person, irrespective of whether it changes or not. I think updating only the rows that change makes up for any inefficiency...

I have used a similar procedure to move records in a sequence. I won't repeat the table setup, but I need to point out that I used "1" as...

This is a very helpful script; thank you for providing it.

Because most of our permissions are assigned by role, and individual users are assigned to roles, having a similar generator...

In my experience, every table has a row in sys.sysindexes that can be used to tell the number of rows in the table.

SELECT i.rowcnt, o.name

FROM sys.sysobjects o JOIN sys.sysindexes...

I like the script. I would like to see the datetime fields formatted using format 121 so that the second and millisecond precision is retained.

To the comment that SQL Server should be able to find these relationships: I'm sure it would be possible to write a parsing engine to determine what each script is...

I have not seen anything in SQL Server that will identify for a developer the code that will break when creating a foreign key reference on a table. SQL...

SELECT CASE WHEN column_id = MIN(column_id) OVER(PARTITION BY 1) THEN 'INSERT INTO ' + OBJECT_NAME(object_id) + ' (' ELSE '' END + name + CASE WHEN column_id = MAX(column_id)...

Another way to solve this problem is to create a temp table in the first procedure. The second procedure looks for the existence of the temp table and adds...

It seems to me that this solution will only work if there are only two levels of parent/child relationship. Do you have cases where the relationships go to three...

The data in the challenge is obviously unrealistic in order to be able to produce the graph. I use graphing in SQL Server for on a regular basis, as...