This script was created for an Oracle to SQL 2005 migration. It creates a table, and then populates it with the record counts for each table in a given schema. (You will need to replace the xxxx text with your schema name for it to work). I prefer populating a table with this data, then […]
2007-09-24 (first published: 2007-05-24)
1,011 reads
After migrating an Oracle database to SQL 2005, all the identity values were not properly set. This script goes through and sets them all to 1 greater than the max value in the identity column.
2007-09-21 (first published: 2007-05-24)
437 reads
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
Hello, I need help to improve an existing (hence I cannot change table's structure...
Ask SSC