Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

A Wish list for the Microsoft Flying Squad Expand / Collapse
Author
Message
Posted Saturday, October 17, 2009 5:25 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: Administrators
Last Login: Wednesday, April 16, 2014 9:53 AM
Points: 569, Visits: 985
Comments posted to this topic are about the item A Wish list for the Microsoft Flying Squad
Post #804728
Posted Saturday, October 17, 2009 10:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 4:18 PM
Points: 1,276, Visits: 1,132
Hi Tony,

Funny you mentioned extended properties :) I'm working on a little set of apps right now that will greatly simplify working with them. Of course the Intellisense won't be modified to incorporate them, but adding, deleting, updating and retrieving them on objects will be greatly simplified. To me it only makes sense to let the server manage your metadata, but as you mentioned it can be painful to use the SPs.

Post #804746
Posted Sunday, October 18, 2009 12:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 10, 2013 6:48 PM
Points: 3, Visits: 46
Another useful feature would be change in versioning so it accepts the same plugins that Visual Studio uses. For now versioning doesn't work for most people around.
Post #804755
Posted Sunday, October 18, 2009 3:51 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 11:44 AM
Points: 561, Visits: 2,417
I realize that this is not a major issue, but I always find it irritating that the system stored procedures haven't been updated with the new data types. ---for years and years and years.....

Try this...

DECLARE @Output VARCHAR(8000)
EXECUTE xp_sprintf @output out,
'Go hang yourself, you old M.D,!
You shall not sneer at me.
Pick up your hat and stethoscope,
Go wash your mouth with laundry soap;
I contemplate a joy exquisite
In not paying you for your visit.
I did not call you to be told
My malady is a common cold.

By pounding brow and swollen lip;
By fever''s hot and scaly grip;
By those two red redundant eyes
That weep like woeful %s skies;
By racking snuffle, snort, and sniff;
By handkerchief after handkerchief;
This cold you wave away as naught
Is the damnedest cold man ever caught!'
, 'April'
SELECT LEN(@Output)

--253


Yup, the documentation proudly says that it takes a string. ...Er... only 256 characters. Look here, this isn't even lined up for deprecation so how long would it take to fix to make it use MAX??



Best wishes,

Phil Factor
Simple Talk
Post #804766
Posted Sunday, October 18, 2009 6:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 06, 2013 8:07 AM
Points: 109, Visits: 489
While table partitioning has been available since 2005, it's almost easier to continue to manually manage it with regular tables, since tables have to be swapped in and out, and partition functions changed with a lot of verbose code - i.e. equivalent to the same code you would change when you added partitioning tables into a view and changed the trigger which makes the view updatable.
Post #804776
Posted Sunday, October 18, 2009 6:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 06, 2013 8:07 AM
Points: 109, Visits: 489
If they were to fix extended properties, they should fix it so that they are not lost when altering a multi-step table value function whenever I remove schemabinding and re-add schemabinding.
Post #804777
Posted Sunday, October 18, 2009 10:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 11:24 AM
Points: 32,781, Visits: 14,942
Good editorial. I'm not sure what I'd want fixed more, though I think partitioning for sure could use an easy way to manage it (and then generate the scripts).

I might ask for more monitors for service broker and mirroring as well.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #804792
Posted Sunday, October 18, 2009 12:20 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411

In most software development projects there is a bug I call the sycophant who tells the boss he or she can do the job and most bosses usually find out after the person with the implementation detail have left without leaving the implementation detail. I can tell you the people who created those nice features have moved on to other companies Microsoft is left without implementation detail, Microsoft is also in a better position than other companies because their employees must leave blogs as is. If the employee did not blog about it the feature is usually lost forever even with a blog I think Microsoft sometimes hire 5 to 10 new people who still cannot complete the nice feature. I know one such work in .NET I help their customers only as needed because the person who created it left with the implementation detail. I was surprised to find the person’s blog number one when I searched Google for it using the feature as key word because I did not remember his name , who knows if he now works for Google.






Kind regards,
Gift Peddie
Post #804809
Posted Sunday, October 18, 2009 6:38 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 10:06 PM
Points: 35,978, Visits: 30,269
Gift Peddie's good post brings up a real sore spot with me... why does everyone think that the Agile Manifesto says "No Documentation" whatsoever? Why does everyone think that if you document code (especially embedded documentation) that you're a sissy of some sort? Why does everyone think that having a simple implementation plan in black and white is somehow against the ability to move quickly?

IT managers of the world... wake up. Insist on proper embedded documentation so it never gets separated from the code and then give people time to do it right. Then insist on code reviews and make them part of everyone's job using pay reviews as enforcement. If you lose a couple of programmers because of it, good... they needed to be replaced anyway.

And remember... "If you want it real bad, you'll probably get it that way."


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #804846
Posted Sunday, October 18, 2009 7:10 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Sunday, April 13, 2014 12:23 PM
Points: 3,433, Visits: 14,411
IT managers of the world... wake up. Insist on proper embedded documentation so it never gets separated from the code and then give people time to do it right. Then insist on code reviews and make them part of everyone's job using pay reviews as enforcement. If you lose a couple of programmers because of it, good... they needed to be replaced anyway.

And remember... "If you want it real bad, you'll probably get it that way."



This is more about intellectual property transfer than documentation because I can give you ten pages of documentation without the three lines needed to implement what I am working on. It takes very little to keep a developer happy but companies sometimes have paid team members doing nothing, writing useless compiled code, working on manager's pet project reinventing the wheel. I find most large projects are useless without a few people in the team and if these people are marginalized so they move on the project is dead.


Kind regards,
Gift Peddie
Post #804851
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse