未加星标

T-SQL Tuesday #86 : My Favorite Connect Items

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二05 | 时间 2017 | 作者 红领巾 ] 0人收藏点击收藏

T-SQL Tuesday #86 : My Favorite Connect Items
This month's T-SQL Tuesday topic is " SQL Server Bugs & Enhancement Requests ." This is a topic near and dear to my heart; for several years I was a huge proponent of the Connect system. For a while, I even published weekly digests , where I highlighted bugs and feature requests that I thought deserved more eyeballs and votes. (A few people didn't like that accusing me of giving preferential treatment and more visibility to issues I cared about. Yeah, that was kind of the point.)

I am still a firm believer in the improvement site, though I expend a lot less effort on it these days. Not because it doesn't work, but because the various teams have a less unified experience some use various combinations of Trello, UserVoice, and Yammer, while only a few teams still seem to be using Connect.

For this month's T-SQL Tuesday, Brent Ozar ( @BrentO ) asked us to write about our favorite Connect bug or enhancement request. I'm going to do him one better, and talk about two different Connect items:

My favorite unresolved Connect item My favorite resolved Connect item

I want to talk about both because, while I think it can be useful to promote important issues that haven't been addressed, I think it's also important to reinforce that Connect items do get considered by the team, and sometimes get fixed. There was certainly a period where it may have felt like all that work was going to /dev/null/ , but I can assure you that's not the case today.

My favorite unresolved suggestion

There are so many active Connect items, it's difficult to choose just one, but after spending some time looking at the generate_series function in PostgreSQL , the one at the top of my list right now is this suggestion from Erland Sommarskog ( blog ):

Connect #258733 : Add a built-in table of numbers

I think it would be cheap and easy for SQL Server to provide a defaut table of numbers, always in memory, just like any other catalog view or DMV. This thing can use compression now, regardless of edition, so even a table with 2 billion rows will only take 13 MB, and should be easy to populate either at start-up or on first use. I could list out all of the potential uses for a numbers table, but they're fairly well documented in the following sources (and most use cases don't need anywhere near 2 billion values, so maybe the range could be defined using a sys.configurations or database-level SCOPED CONFIGURATION setting):

Why are numbers tables invaluable? (DBA StackExchange) You REQUIRE a Numbers table! (Adam Machanic) A three-part series on generating sets, by yours truly Part 1 |Part 2 |Part 3

Honorable Mentions

Well, I can't just talk about one unresolved bug or suggestion, can I? There are several others I'd love to see addressed. In no particular order, here are a few:

#261342 : Regex functionality in pattern matching #273443 : "Fix scalar UDF performance" (paraphrased) #339410 : Please fix the "String or binary data would be truncated" message (Kind of cheating here, asLori Edwards also highlighted this Connect item.)

My favorite resolved suggestion

Without a doubt, my favorite fix has been a recent one, and that isthe addition of CREATE OR ALTER in SQL Server 2016 SP1. This gives us the ability to make changes to modules like views, functions, triggers, and stored procedures, without having to resort to dynamic SQL or other convoluted logic just to determine if the object already exists. I've seen many deployments go south because this logic is complicated and very easy to mess up.

There's not much else to say about this really, except job well done by the SQL Server team; they've listened and implemented something we've been asking for, for literally years. Here are the related Connect items, though not all are marked as resolved:

#273938 | #344991 | #351217 | #448946 | #487763 | #2558884

(The original item, 127219, has disappeared, but the wayback machine has it, in all its unformatted, barely legible, Times New Roman glory! )

One thing to keep in mind: Denis Gobo discovered that the logic is broken for DDL triggers (see Connect #3111866 I'm sure this will get addressed in short order).

Honorable Mentions

I was quite happy to see two of my recent suggestions make it into the product last year:

#2374513 : Add CREATE DATABASE AS COPY OF syntax this was implemented via DBCC CLONEDATABASE , which have been blogged about by Melissa Connorshereand Erin Stellato here . #2088233 : Add parameter data types to showplan they didn't implement this exactly as I suggested, but some execution plans now contain more valuable info about parameters (see KB #3190761 ).

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLPostgreSQLSQL ServerTIYammer
tags: Connect,SQL,about,was
分页:12
转载请注明
本文标题:T-SQL Tuesday #86 : My Favorite Connect Items
本站链接:http://www.codesec.net/view/522785.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(123)