A Fine Slice Of SQL Server
Erik Darling has some doozies today:
Many of our Tables have 15 plus guid s from other tables, but not declared as Foreign Key. Plus Foreigne Keys. When I add a Index on for every Foreign Key plus Indexes for declared foreign keys we end up with tables with 30 plus indexes for fks only. We don’t have write performance issues. would you index every fk for every possible join?
Click through for the answer to this and four other questions.
Comments closedDan Liu makes an announcement:
Task flows feature is now generally available! Task flows streamline the design of your data solutions and ensure consistency between design and development efforts. It also allows you to navigate items and manage your workspace more easily, even as it becomes more complex over time.
Read on to see what’s available to us now.
Comments closedIn general, the process to build and manage both models and reports in Power BI can be simplified to a few sequential steps that describe the “lifecycle” of this content. You can see this depicted below, as well as some examples of the various tools that you might use to support each of these steps. Shameless plug, Bravo, Vertipaq Analyzer, and Analyze in Excel were created by SQLBI, and SQLBI is involved in the development of DAX Studio, DAX Optimizer, and Tabular Editor.
Click through for an interesting table showing what fits where. If all you’re using is Power BI Desktop, there’s a whole world of additional functionality you’re missing out on.
Comments closedDavid Fitzjarrell wants to see which indexes are in use:
Database performance is one of the biggest areas for DBAs to address, measured primarily in time. Users usually complain when queries “take too long” and immediately run to the DBA team to register their disappointment. One avenue used to address such concerns is the creation and maintenance of indexes, and as any DBA with any experience can attest, simply throwing indexes at a table isn’t necessarily the smartest play; a major concern is if the index is actually being utilized. Oracle, in its wisdom, has provided tools to monitor these objects in the form of system views. Let’s look at what is available and how to get the most benefit out of them.
Click through for some scripts and information on how to tell whether an index is in use or not.
Comments closedPatrick Gruenauer asks, what’s in a name?:
Active Directory users log on with their logon names and password. But what are the rules for assigning usernames? g.surname? surname? gsurname? What are the naming conventions? This article looks for and modifies users who do not meet the naming convention.
Read on to see how it works.
Comments closedVlad Drumea counts that which does not exist:
I’ve seen variations of the question “how to count all NULLs in all columns of a table” pop up on reddit once every couple of months, and I figured I’d give it a shot and post here in case anyone else might need it in the future.
Click through for the script. It does require M*N scans, where M represents the average number of columns in each table and N the number of tables in the database. In other words, don’t expect an immediate response.
Comments closed