Categories
Top Posts & Pages
- How to get SSAS to return the correct currency format.
- Microsoft Visual Studio is unable to load this document
- Microsoft SQL Server 2014 CTP2 Data Tools BI templates for VS2012
- How to do a String REPLACE in Teradata
- Gandalf, har du lige tid?
- Why I need to go to SQLskills Immersion Training
- Setting the maximum allowed memory consumption by Analysis Services
- MDX Query using other hierarchy in same dimension as in slicer
- Quick-tip: Default column type in SSMS
- EB helt ude af kontekst
Recent Comments
- 九州娛樂城 on MDX Query using other hierarchy in same dimension as in slicer
- Donald Parish on Run your cubes in Warp Speed – Really Really Fast!
- Kenneth M. Nielsen (@DoktorKermit) on How to Process Multiple Dimensions via BIDS and SSMS
- Jens Vestergaard on Teradata based Data Source Views in Analysis Services
- Sudipta on Teradata based Data Source Views in Analysis Services
Tags
.Net 3rd. ed. AMO Analysis Services BI Business Intelligence Bønner C# Certificering Coffee D&D Espresso FAIL Fejl Humor Kværn MCP MDX MSConnect NFL Personal Powershell Presenting Roleplay Security SQL SQL2008 SQL2012 SQLBits SQLBits X SQLPASS SQLServer SQL Server SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata vandkøling VS2008 VS2010LinkedIn
I am happy to connect on LinkedIn:
Tag Archives: SQL
Subtle differences in Teradata and SQL Server
Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine … Continue reading
How to do a String REPLACE in Teradata
String Replace does not exist but can be accomplished with the following procedure: INSTALL REQUIREMENTS:– 1) GRANT ALL ON “%TDUser%” TO “%TDUser%” WITH GRANT OPTION 2) C++ compiler, if running the TD Demo How to replace “old” with “new” so … Continue reading
Restored database konflikter med et opdaterings deploy fra VS DB Ed.
Jeg løb ind i et lidt filøjerligt issue her til aftens da jeg skulle lave et opdateringsdeploy fra VS ud til min dev instans af en database. Jeg havde modtaget en backup fra en kollega, der indeholdt en masse testdata, … Continue reading
Kør SQL statement mod alle databaser
m4s0n501 Der findes en udokumenteret system stored procedure fra Microsoft, der gør det muligt at eksekvere en T-SQL sætning mod alle databaser. Uden at skulle sætte en cursor op mod sysdatabases tabellen. Syntax: EXEC sp_MSforeachdb @command (hvor @command er en … Continue reading
” == 0
Opdagede i dag en meget underlig måde at programmere på. Under en portering fra SQL Server 2000 til SQL Server 2005 stødte jeg på en fejlbesked i en stored procedure. Fejlbeskeden lød meget mærkelig og det viste sig også at det ikke … Continue reading