Looks like a useful unit of measure for discussing UK property prices 🙂

"lakhs of tables, stored procedures"

What are lakhs of tables?

There is absolutely no need to ever audit INSERTs. All they do is double the storage requirements. If you INSERT a row and never change it, the...

I use a simple approach which works well:

1. Each table being audited should have a PK (or unique constraint). For each table create an audit table of the...

I have found if text is unexpectedly truncated to approximately 4000 or 8000 characters this can be a string casting issue. SQL thinks an intermediate expression is NVARCHAR(4000) or VARCHAR(8000)...

If you wanted a pure TSQL solution, this should be possible using Openrowset to load in each spreadsheet. Create a table storing the filenames, another table to store the loaded...

A few years ago we had a similar problem when upgrading from SQL Server 2000 to 2008 R2. There was some complex code which involved views joined to views that...

I had this happen on my surface pro 4 laptop after Windows did a major update, and I'm putting my thoughts here in case it helps anyone. My situation:

- Windows...

Under this link https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases (see Planned relocation Procedure), Microsoft say:

1. Take the DB offline
2. Move the files to the new location
3. Run ALTER DATABASE ... MODIFY FILE...

If your objective is to check whether the XML column contains text without caring where in the XML the text is, why not convert the XML column to a varchar...

Following on from the above approach, I am sure we could do effective masking by SQL scripting:

- Names, if we had a table of equivalent names we could use these...

Just an idea, what about adding triggers for INSERT, UPDATE and DELETE that just call raiserror and do a rollback, would this help?

If you are using SSIS, there is a "Fuzzy Grouping" transformation that can be used for de-duplication. You provide it with the 'canonical' forms of the strings, and with the...

Just for info, neither of the links in this article work. The link from "an interesting piece" shows an error saying "The website declined to show this webpage" as it...

Actually I can think of another reason. Some 3rd party apps using SQL server expect their database login to be installed with sysadm rights, so you can limit potential misuse...