Network profile

IronicMuffin

Reputation

591

591
433
275

2018
2019
2020
2021

Top tag

sql-server

Next privilege

1,000 Rep.

See votes

Badges

2

13

Newest

Yearling

Next badge

0/1

Impact

0 posts edited

0 helpful flags

22 votes cast

10 Questions

Votes Activity Newest Views

1

vote

2

answers

133

views

Strategies/Resources for implementing data lineage in an ETL process?

sql-server data-warehouse etl business-intelligence

Dec 17 '19 at 15:27 Tom V 15.3k

4

votes

1

answer

120

views

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

sql-server sql-server-2014

Jul 24 '19 at 14:33 Aaron Bertrand 170k

1

11

votes

1

answer

217

views

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

sql-server view

Jan 20 '19 at 11:11 Muntasir 121

1

vote

4

answers

109

views

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

sql-server t-sql performance optimization query-performance

Jan 16 '18 at 20:26 Community♦ 1

7

votes

7

answers

2k

views

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

sql-server view type-conversion

Nov 28 '19 at 12:57 Paul White♦ 58.8k

1

vote

1

answer

156

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 591

0

votes

1

answer

57

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 - Retired User 20.7k

4

votes

1

answer

984

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 Community♦ 1

1

5

votes

2

answers

927

views

Solutions for reporting off of an EAV structured database?

business-intelligence reporting cognos eav

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

2

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 591

Database Administrators Stack Exchange works best with JavaScript enabled