Just for fun (and a little learning), I made it work with your example:

SELECT lw.SomeCode, lw.Seq, lw.LWType, lw.Age,lw.Race,lw.Sex,

SUBSTRING(','+lw.Crimes+',',N+1,CHARINDEX(',',','+lw.Crimes+',',N+1)-N-1) AS Value

FROM SCRIDB.dbo.Tally t

CROSS JOIN lwNames lw

WHERE N < LEN(','+lw.Crimes+',')

...

Create two tables with the same basic structure, one for each design. then run the same INSERT script against each one and do performance testing. The only way...

Is there a need to shrink the file? Do you know all the ugly things that shrinkfile does to your indexing etc? Unless you absolutely must do it,...

This was interesting... Ran this

CREATE PROC uspHouseRepairs

AS

SELECT pa.Longitude, pa.Latitude, geography::Point(pa.Longitude, pa.Latitude, 4326) As MyPoint, h.Location, h.StreetAddress, h.City, h.HState, RepairList.RepairName, RepairList.RequiresLicense, HouseRepairs.StartDate,

...

HappyCat,

Thanks for answering, but mission failed! Your SQL ran, but nothing got updated.

It would appear that for some reason, I cannot use CROSS APPLY in an update query.... If...

Hopefully this helps someone else...

I got Itzik Ben-Gan's book Inside MS SQL Server 2008 T-SQL Querying, and basically modified one of his SQL queries to suit my problem. ...

Answered my own question... ("Re-search. It means 'look again', don't it?") After a few minutes of surfing, I found this: http://stackoverflow.com/questions/2120544/how-to-get-cumulative-sum, which I basically tweaked for my own...

You could always have Reporting Services do the pivot... just drop a matrix onto your report...

I'm needing to get the most recent AP_Ex.Ap_Expt_Date for each AP_Ex.Student_ID

SELECT Max(AP_Ex.Ap_Expt_Date) As LatestDate, AP_Ex.Student_ID

FROM...

GROUP BY AP_Ex.Student_ID;

Do you really mean Modals? Or do you really mean Models? From the context, it would appear you mean "Models".

Do you mean aside from the fact that it requires the Enterprise version of SQL Server?

Usually, when an .LDB file is still around, the Access database was not closed properly. Standard way of fixing the problem is to delete the LDB file and then...

Maybe the best way to handle this is to put your read only tables in one or more filegroups that are separate from your read/write tables. Then you can...

use the same password on both servers or set up impersonation.

I would say so... Question 3 is a dead giveaway.