bjnr

bjnr has asked 4 questions and find answers to 27 problems.

Stats

About

SQL Server, SSIS, SSAS, DWH, BI - Data Enthusiast

bjnr questions

Getting total number of rows returned by a query
Power BI - You cannot see the content of this report because you do not have permissions to the underlying dataset
Query plans for CXPACKET waits
WCF / WIF - Should I find claims in the backend?

bjnr answers

SSRS 2008 Wont return the correct Dataset from Stored Procedure
MS SQL query slow because of bad plan or fragmented indexes
SQL Server Stored Procedure with varchar parameter returns wrong results
SQL Server : SUM() weird behaviour
SQL Server: Detect Non-Parameterized Queries
SQL Server 2005 - How do I find out the disk size of a specific index
Checking if a column has a null value tsql
Rapidly fragmenting index in SQL Server
One of the SELECT fails using unixOdbc - SQLSTATE[24000]: Invalid cursor state
Cannot truncate table because it is being referenced by a FOREIGN KEY constraint