Fantastic!  Two of my three flat file connection managers somehow got assigned a Code Page of 65001 and nothing I did in the advanced column mappings fixed it.  After reading...

Awesome that you are upgrading, and that you are sharing the details!  Please share more on the progress.  I have a vested interest in that I am running SQL Server...

I recommend getting the data out of the AS400 data source directly into staging tables in SQL Server first.  If there is any question about the data-typing from the AS400,...

I have just encountered a similar error and symptoms after deploying Power BI Report Server October 2017 GA on a SQL Server 2016 Enterprise server.  I had been running SSRS 2016...

I deal with the variable field values by A) making each name component field a varchar(50), B) setting the field to NOT NULL, and C) providing a default value of...

rizwankhalid214 (10/18/2013)

please follow below steps

1-stop analysis Services on your New Server from SQL Server Configuration Manager and close SQL Server Configuration Manager

2-go to registry . START>RUN>regedit

3-in registry , go...

I've been burned in the past with the .997 accuracy of datetime, especially when dealing with orders that come in or events that occur during just before midnight. An...

Great scripts! To show memory buffer MB with a decimal value, I changed "128" to "128.00". Since many of my indexes use less than 1 MB, they all...

This is great! I was able to immediately put it to use, and then made a small adjustment to the implementation to see if it could be done.

I slightly...

I had the same situation as posted with the results not being returned as expected, except the results weren't returned at all. I am running SQL 2012 Enterprise 64-bit...

As an architect, I always try to align object names with what they really are. As the systems I develop adapt to changing conditions over the years, sometimes the...

A clustered index gives great, if not the best, performance IF you use it. If you do not use it in the match, or if you are inserting large...

I've seen that happen (inserting multi-millions of rows into an empty table taking hours) when using a clustered index on the target and the records are inserted in an order...

I totally agree with The Dixie Flatline. Indexes, indexes, indexes. The one caveat I have found working on ETL processes is that having indexes on the tables being...

This is a great post and a great demo of recursion capabilities in T-SQL/SPs. My current issue is the duplicate key/ID in the source data. What I am...