Stack Exchange Network

Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Loading…
  1. 0
  2. +0
    • Tour Start here for a quick overview of the site
    • Help Center Detailed answers to any questions you might have
    • Meta Discuss the workings and policies of this site
    • About Us Learn more about Stack Overflow the company
    • Business Learn more about hiring developers or posting ads with us
  3. Log in Sign up
  4. current community

    • Database Administrators
      help chat
    • Database Administrators Meta

    your communities

    Sign up or log in to customize your list.

    more stack exchange communities

    company blog
Database Administrators
  1. Home
    1. Questions
    2. Tags
    3. Users
    4. Unanswered
    5. Jobs
Profile Activity
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
Custodian

Impact

~8k
people reached
0 posts edited
0 helpful flags
22 votes cast
Summary Answers Questions Tags Badges Bookmarks Bounties Reputation All actions

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
  • Tour
  • Help
  • Chat
  • Contact
  • Feedback
  • Mobile
Company
  • Stack Overflow
  • For Teams
  • Advertise With Us
  • Hire a Developer
  • Developer Jobs
  • About
  • Press
  • Legal
  • Privacy Policy
  • Terms of Service
  • Cookie Settings
Stack Exchange
Network
  • Technology
  • Life / Arts
  • Culture / Recreation
  • Science
  • Other
  • Stack Overflow
  • Server Fault
  • Super User
  • Web Applications
  • Ask Ubuntu
  • Webmasters
  • Game Development
  • TeX - LaTeX
  • Software Engineering
  • Unix & Linux
  • Ask Different (Apple)
  • WordPress Development
  • Geographic Information Systems
  • Electrical Engineering
  • Android Enthusiasts
  • Information Security
  • Database Administrators
  • Drupal Answers
  • SharePoint
  • User Experience
  • Mathematica
  • Salesforce
  • ExpressionEngine® Answers
  • Stack Overflow em Português
  • Blender
  • Network Engineering
  • Cryptography
  • Code Review
  • Magento
  • Software Recommendations
  • Signal Processing
  • Emacs
  • Raspberry Pi
  • Stack Overflow на русском
  • Code Golf
  • Stack Overflow en español
  • Ethereum
  • Data Science
  • Arduino
  • Bitcoin
  • Software Quality Assurance & Testing
  • Sound Design
  • Windows Phone
  • more (28)
  • Photography
  • Science Fiction & Fantasy
  • Graphic Design
  • Movies & TV
  • Music: Practice & Theory
  • Worldbuilding
  • Video Production
  • Seasoned Advice (cooking)
  • Home Improvement
  • Personal Finance & Money
  • Academia
  • Law
  • Physical Fitness
  • Gardening & Landscaping
  • Parenting
  • more (10)
  • English Language & Usage
  • Skeptics
  • Mi Yodeya (Judaism)
  • Travel
  • Christianity
  • English Language Learners
  • Japanese Language
  • Chinese Language
  • French Language
  • German Language
  • Biblical Hermeneutics
  • History
  • Spanish Language
  • Islam
  • Русский язык
  • Russian Language
  • Arqade (gaming)
  • Bicycles
  • Role-playing Games
  • Anime & Manga
  • Puzzling
  • Motor Vehicle Maintenance & Repair
  • Board & Card Games
  • Bricks
  • Homebrewing
  • Martial Arts
  • The Great Outdoors
  • Poker
  • Chess
  • Sports
  • more (16)
  • MathOverflow
  • Mathematics
  • Cross Validated (stats)
  • Theoretical Computer Science
  • Physics
  • Chemistry
  • Biology
  • Computer Science
  • Philosophy
  • Linguistics
  • Psychology & Neuroscience
  • Computational Science
  • more (10)
  • Meta Stack Exchange
  • Stack Apps
  • API
  • Data
  • Blog
  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. rev 2021.2.26.38670

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.