SQL Server Management Studio diagramming and dates

%3CLINGO-SUB%20id%3D%22lingo-sub-3253522%22%20slang%3D%22en-US%22%3ESQL%20Server%20Management%20Studio%20diagramming%20and%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3253522%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20couple%20of%20issues%20with%20SSMS%2018.9.1%20that%20are%20driving%20me%20mad%2C%20one%20small%2C%20the%20other%2C%20not%20so%20much%2C%20and%20wondered%20if%20anyone%20else%20experiences%20them%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirstly%2C%20I'll%20hold%20my%20hand%20up%20and%20admit%2C%20that%20using%20the%20table%20designer%20in%20SSMS%20is%20a%20fantastic%20way%20of%20building%20my%20base%20table%20structure%2C%20without%20having%20to%20resort%20to%20code%2C%20and%2099%20times%20out%20of%20100%2C%20gets%20the%20job%20done%20perfectly.%26nbsp%3B%20The%20one%20issue%20I%20have%20with%20it%2C%20however%2C%20is%20the%26nbsp%3B%3CSTRONG%3EDATETIME2%3C%2FSTRONG%3E%20field%20type.%26nbsp%3B%20Whenever%20I%20set%20this%20value%20to%20something%20like%26nbsp%3B%3CSTRONG%3EDATETIME2(0)%3C%2FSTRONG%3E%2C%20it%20resets%20it%20and%20changes%20it%20back%20to%26nbsp%3B%3CSTRONG%3EDATETIME2(7)%3C%2FSTRONG%3E!%26nbsp%3B%20Does%20anyone%20else%20have%20this%20issue%3F%26nbsp%3B%20It's%20not%20a%20major%20thing%2C%20obviously%2C%20more%20of%20an%20annoyance%20than%20anything%20else.%26nbsp%3B%20Is%20there%20any%20kind%20of%20fix%20for%20this%2C%20or%20something%20I'm%20doing%20wrong%3F%26nbsp%3B%20Can%20the%20default%20template%20be%20changed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20thing%20that%20causes%20me%20more%20of%20a%20serious%20problem%20is%20a%20stability%20issue%20with%20database%20diagrams.%26nbsp%3B%20I%20rely%20on%20this%20tool%20quite%20heavily%2C%20to%20produce%20relevant%20relational%20maps%20of%20the%20table%20structure%20for%20our%20documentation%2C%20and%20as%20a%20model%20for%20applications%3B%20it%20is%20a%20great%20tool!%26nbsp%3B%20One%20of%20the%20last%20strokes%20of%20perfection%20for%20it%2C%20would%20be%20to%20automatically%20line%20up%20the%20links%20between%20tables%20with%20their%20associated%20columns%2C%20as%20with%20Microsoft%20Access%2C%20for%20instance.%26nbsp%3B%20And%20this%20is%20where%20my%20pain%20usually%20starts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20several%20occasions%2C%20as%20I%20have%20been%20developing%20diagrams%2C%20I%20have%20added%20the%20tables%2C%20then%20joined%20the%20columns%20together%20(FK%20-%26gt%3B%20PK)%20and%20manually%20lined%20up%20the%20links%20to%20appear%20beside%20their%20respective%20field%20names.%26nbsp%3B%20Sometimes%20it's%20not%20instantly%20obvious%2C%20so%20I%20pause%20while%20I'm%20comparing%20the%20source%20and%20destination%20on%20the%20link.%26nbsp%3B%20If%20I%20pause%20too%20long%2C%20SSMS%20spirals%20off%20on%20its%20own%20travels%20and%20never%20returns%2C%20simply%20spinning%20the%20cursor.%26nbsp%3B%20Windows%20reports%20the%20application%20as%20being%20busy%2C%20but%20any%20changes%20are%20lost%20at%20that%20point%2C%20as%20the%20program%20never%20comes%20back.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20there%20fixes%20for%20them%2C%20out%20there%2C%20or%20is%20it%20just%20one%20of%20those%20things%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3254711%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20Management%20Studio%20diagramming%20and%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3254711%22%20slang%3D%22en-US%22%3EThanks%20for%20taking%20a%20look%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1317415%22%20target%3D%22_blank%22%3E%40MCarr10%3C%2FA%3E.%20Hmmm%20...%20I%20wonder%20if%20it's%20down%20to%20GPU%20drivers.%20I'll%20have%20to%20take%20a%20look.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3254486%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20Management%20Studio%20diagramming%20and%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3254486%22%20slang%3D%22en-US%22%3EI%20am%20able%20to%20duplicate%20the%20datetime2%20behavior%20in%20SSMS%2018.10.%20I%20have%20not%20encountered%20the%20database%20diagram%20problem.%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a couple of issues with SSMS 18.9.1 that are driving me mad, one small, the other, not so much, and wondered if anyone else experiences them:

 

Firstly, I'll hold my hand up and admit, that using the table designer in SSMS is a fantastic way of building my base table structure, without having to resort to code, and 99 times out of 100, gets the job done perfectly.  The one issue I have with it, however, is the DATETIME2 field type.  Whenever I set this value to something like DATETIME2(0), it resets it and changes it back to DATETIME2(7)!  Does anyone else have this issue?  It's not a major thing, obviously, more of an annoyance than anything else.  Is there any kind of fix for this, or something I'm doing wrong?  Can the default template be changed?

 

The other thing that causes me more of a serious problem is a stability issue with database diagrams.  I rely on this tool quite heavily, to produce relevant relational maps of the table structure for our documentation, and as a model for applications; it is a great tool!  One of the last strokes of perfection for it, would be to automatically line up the links between tables with their associated columns, as with Microsoft Access, for instance.  And this is where my pain usually starts.

 

On several occasions, as I have been developing diagrams, I have added the tables, then joined the columns together (FK -> PK) and manually lined up the links to appear beside their respective field names.  Sometimes it's not instantly obvious, so I pause while I'm comparing the source and destination on the link.  If I pause too long, SSMS spirals off on its own travels and never returns, simply spinning the cursor.  Windows reports the application as being busy, but any changes are lost at that point, as the program never comes back.

 

Are there fixes for them, out there, or is it just one of those things?

2 Replies
I am able to duplicate the datetime2 behavior in SSMS 18.10. I have not encountered the database diagram problem.
Thanks for taking a look, @MCarr10. Hmmm ... I wonder if it's down to GPU drivers. I'll have to take a look.