Viewing 15 posts - 7,276 through 7,290 (of 7,602 total)
DataAnalyst110 (7/27/2012)
...
UNLESS they have another Enroll.Credits that is greater than 15.
Did you mean SUM(Credits) > 15 or a single course with Credits > 15?
I suspected SUM but coded it each...
July 27, 2012 at 2:37 pm
Sean Lange (7/25/2012)
ScottPletcher (7/25/2012)
ALTER TRIGGER UPDate_PONumber
ON dbo.PurchaseOrderDetail
AFTER INSERT, UPDATE, DELETE
AS
UPDATE PON
SET SubTotal =...
July 25, 2012 at 10:12 am
I think the code below should at least be close to what you need (hopefully very close :-)):
ALTER TRIGGER UPDate_PONumber
ON dbo.PurchaseOrderDetail
AFTER INSERT, UPDATE, DELETE
AS
UPDATE PON
SET SubTotal = PO_Total.SubTotal
FROM dbo.PONumber AS...
July 25, 2012 at 9:43 am
sqlnyc (7/23/2012)
What happens if the server has 48GB of memory? Does the OS just ignore it, or is there some way that SQL Server can access it?
Excellent q ......
July 23, 2012 at 1:43 pm
tim.cloud (7/23/2012)
July 23, 2012 at 1:13 pm
Djcarpen11 (7/23/2012)
DECLARE @P INTSET @P= 1;
select [ColA],[ColB],[ColC],[ColDfrom MyTable
where cola =@p
In cases where a filtered index is available, you can force SQL to recompile the statement, which should pick...
July 23, 2012 at 12:51 pm
I'd suggest reducing SQL to 32GB rather than 36GB. Remember that Windows needs some RAM to manage the other RAM. I think you're cutting it too close initially.
First,...
July 23, 2012 at 12:32 pm
Sony Francis @EY (7/20/2012)
...
2. When the operation is update then modiifed date as getdate. WHen insertion happens modified date is null.
...
Note :- Trigger is not applicable here
If you don't use...
July 20, 2012 at 2:45 pm
rupes0610 (7/20/2012)
Column 'dbo.IIRPS_HPOO_LPAR.OnlineMemory' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP...
July 20, 2012 at 2:37 pm
john.arnott (7/20/2012)
It never made sense to me that people would think that MS would develop an open-ended methodology to manage data in...
July 20, 2012 at 1:47 pm
I suspect the MERGE time could be reduced by clustering on the ProductID, but with it being nvarchar(60), that's not particularly appealing.
If you can go to just varchar(60), and the...
July 19, 2012 at 4:56 pm
bpw (7/19/2012)
Each table has the following indexes:
- nonclustered, unique, primary key (nvarchar(60)) - used for the MERGE join.
- clustered, unique (int)
Paul
>> ON (t.ProductID = s.ProductID) <<
So is ProductID...
July 19, 2012 at 4:00 pm
hisakimatama (7/19/2012)
Alternatively, I could create a table for each month, and track sales...
July 19, 2012 at 3:34 pm
You have to use DBCC SHRINKFILE to reduce a file below its initial allocation.
USE <your_db_name>
-- get the file#s / names of all the db's files
EXEC sp_helpfile
Then choose the file# or...
July 19, 2012 at 3:23 pm
Jeff Moden (7/18/2012)
ScottPletcher (7/17/2012)
Sounds like RCS (Read-Committed Snapshot) is what you need here.Why would that be any better than a simple MERGE?
It provides continuous availability of the data, with no...
July 18, 2012 at 8:00 am
Viewing 15 posts - 7,276 through 7,290 (of 7,602 total)