Profile Activity

IronicMuffin

Network profile

Reputation

384

384
290
196

2016
2017
2018
2019

Top tag

sql-server

Next privilege

500 Rep.

Access review queues

Badges

1

13

Newest

Nice Question

Next badge

0/1

Impact

0 posts edited

0 helpful flags

16 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

8 Questions

Views Newest Activity Votes

1

11

votes

1

answer

165

views

Why can you only drop a SQL Server view in the current database?

sql-server view

Jan 20 at 11:11 Muntasir 114

6

votes

7

answers

1k

views

Why does SQL try to convert rows that are excluded by my where clause?

sql-server view type-conversion

Aug 7 '17 at 12:35 IronicMuffin 384

1

5

votes

2

answers

853

views

Solutions for reporting off of an EAV structured database?

business-intelligence reporting cognos eav

Nov 13 '12 at 10:18 Erwin Brandstetter 100k

4

votes

1

answer

761

views

What known strategies, if any, can I use to validate a Slowly Changing Dimension?

data-warehouse ssas business-intelligence star-schema slowly-changing-dimension

Sep 8 '15 at 16:59 Jo Douglass 306

3

votes

2

answers

2k

views

How do you block ad-hoc distributed queries from specific sql server instances?

sql-server sql-server-2008 sql-server-2005

Feb 8 '12 at 1:53 IronicMuffin 384

1

vote

4

answers

107

views

Is there an efficient way to match multiples headers that have the same set of details?

sql-server t-sql query-performance optimization

Jan 16 '18 at 20:26 IronicMuffin 384

1

vote

1

answer

125

views

TSQL Stored Procedure rollback without any warning/error?

sql-server t-sql stored-procedures ssis user-defined-table-type

May 9 '17 at 19:55 IronicMuffin 384

0

votes

1

answer

35

views

Why would SQL Server stop excluding partitions appropriately?

sql-server t-sql partitioning execution-plan statistics

Aug 4 '16 at 13:03 Sean Gallardy 18.5k

Database Administrators Stack Exchange works best with JavaScript enabled