Profile Activity

IronicMuffin

Network profile

Reputation

406

406
301
196

2016
2017
2018
2019

Top tag

sql-server

Next privilege

500 Rep.

Access review queues

Badges

2

13

Newest

Yearling

Next badge

0/1

Impact

0 posts edited

0 helpful flags

18 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

9 Questions

Views Newest Activity Votes

1

11

votes

1

answer

168

views

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

sql-server view

Jan 20 at 11:11 Muntasir 116

6

votes

7

answers

2k

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 406

1

5

votes

2

answers

856

views

Solutions for reporting off of an EAV structured database?

business-intelligence reporting cognos eav

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

4

votes

1

answer

54

views

Does SQL Server Date Correlation Optimization only work on DateTime fields, or will a Date work, too?

sql-server sql-server-2014 date-correlation-optimzation

Jul 24 at 14:33 Aaron Bertrand♦ 159k

4

votes

1

answer

766

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 406

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 406

1

vote

1

answer

127

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 406

0

votes

1

answer

36

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 19.1k

Database Administrators Stack Exchange works best with JavaScript enabled