VIBE CODED

The following is a living list of information about the various metadata files associated with Visual Studio.NET and ClearCase. Folder Hierarchy The Visual Studio.NET (VS.NET) and ClearCase metadata exist in a simple hierarchy of folders. The first folder is the Solution folder and is named after the VS.NET Solution. The Solution folder contains one *.SLN file (see below), at least one *.SUO file (see below), and zero or more VS.NET Project folders. Project folders are named after their VS.NET Projects. The contents of the Project folders vary, but they always contain one *.CSPROJ file (see below) per Project folder, and a *.WEBINFO file (see below) if the Project is a web (ASP.NET) project. SLN (Solution File) The VS.NET Solution metadata is stored in the *.sln file. The Solution and all the Projects associated with it can be opened within VS.NET by opening the *.sln file. It is a text file and can be edited. It is version controlled. CSPROJ (Project File) The metadata file associate...

OVER OVER allows you to get aggregate information without using a GROUP BY. In other words, you can retrieve detail rows, and get aggregate data alongside it. For example, this query: SELECT SUM(Cost) OVER () AS Cost , OrderNum FROM Orders Will return something like this: Cost  OrderNum 10.00 345 10.00 346 10.00 347 10.00 348 Quick translation: SUM(cost) – get me the sum of the COST column OVER – for the set of rows…. () – …that encompasses the entire result set. OVER(PARTITION BY) OVER, as used in our previous example, exposes the entire resultset to the aggregation…”Cost” was the sum of all [Cost]  in the resultset.  We can  break up  that resultset into partitions with the use of PARTITION BY: SELECT SUM(Cost) OVER (PARTITION BY CustomerNo) AS Cost , OrderNum , CustomerNo FROM Orders My partition is by  CustomerNo  – each “window” of a single customer’s orders will be treated separately from each other “window...