Thursday, March 3, 2016

Did you know there are four heaps in .NET?

  1. generation 0
  2. generation 1
  3. generation 2
  4. Large Object Heap

Objects greater than 85,000 bytes go on the LOH!

Wednesday, March 2, 2016

torrent

Torrent sites are sites like these!

What are filegroups in MSSQL?

These are where database tables are actually kept in files on a server, and, yes, they are kept somewhere. There is a folder structure that holds data files. The default is PRIMARY but you may change this setting. I remember when I first starting using mySQL databases in lieu of Microsoft Access databases what a big adjustment it was to think of a database as a thing running out there somewhere of which I didn't have to pay attention for an actual file, but MySQL did use files that I never saw and so too does SQL Server.

Limit a DevExpress ASPxTextBox to fifty alphanumeric characters!

This goes inside the tag.

<RegularExpression ValidationExpression="[A-Za-z0-9]{1,50}$" ErrorText="Allows up to
      50 alphanumeric characters." />

at the "Defects" tab for the story...

Within CA Technologies (used to be Computer Associates) tool CA Agile Central (used to be Rally) one may see the Defects for a story at the "Defects" tab for the story. You may add a new defect under this tab too. Otherwise, I don't know how one associates a defect to a story after the fact. Wait, I spoke too soon! At the far right where you pick an owner for a defect there is a place to set the associated story.

Tuesday, March 1, 2016

you may right-click in the midst of a SQL file in SSMS and under "Connection" pick options for "Connect..." and "Disconnect..."

Yes, this will allow you to spec which database you want to connect to to run the script. A coworker suggested this today in the name of jogging things into working in a vein similar to restarting your computer. :P

Invalid filegroup 'DATA' specified.

When you get this error in SSMS, just remove...

ON [DATA]

 
 

...from the SQL script and you should have an easier time creating tables. This stuff shows up in the midst of constraints as defined in T-SQL.