Yahfoufi

Yahfoufi has asked 9 questions and find answers to 10 problems.

Stats

About

I am a senior developer working for a small company. I mainly works with C#, SQL and I have some experience in SQL Server Business Intelligence Suite.

Yahfoufi questions

Managing and Closing Dynamically created SQL connections in .net
Retrieve multidimensional database objects directories
Connecting to Sphinx from sql server linked server
Linked dimension performance issue
Efficient way to process a multidimensional cube
Get Last non empty column and row index from excel using Interop

Yahfoufi answers

Execute dynamic sql for all rows in a result set without a loop
Linked dimension performance issue
How can I get SSIS Lookup transformation to ignore alphabetical case?
Command is running fine in console but not when used by Powershell
SQL Server 2016, Invalid object name 'STRING_SPLIT'
ssis filter out rows with values starting in a letter
SQLCMD, .SQL files and SSIS
calculate time difference between two dates in ssis