Viewing 15 posts - 1 through 15 (of 28 total)
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,...
May 28, 2019 at 7:14 pm
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...
December 14, 2017 at 1:02 pm
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...
August 4, 2016 at 10:59 am
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...
July 6, 2016 at 12:45 pm
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...
January 5, 2016 at 10:59 am
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...
November 10, 2015 at 9:35 am
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.
August 4, 2015 at 10:28 am
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...
July 28, 2015 at 11:41 am
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...
June 14, 2015 at 10:01 am
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...
May 17, 2015 at 9:49 am
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...
May 16, 2015 at 1:10 pm
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...
March 25, 2015 at 7:12 am
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...
November 9, 2010 at 8:54 am
The easiest way to change the URL that users access the Report Manager with is to set up a DNS entry with the desired name pointing to the full address....
June 2, 2010 at 9:58 am
November 24, 2009 at 9:24 am