Viewing 15 posts - 7,276 through 7,290 (of 7,608 total)
Stefan Krzywicki (7/31/2012)
ScottPletcher (7/31/2012)
Stefan Krzywicki (7/31/2012)
Scott, What does Erwin have that Visio doesn't that causes you to consider it a modeling tool while not considering Visio one?
I admit I haven't...
July 31, 2012 at 12:46 pm
Stefan Krzywicki (7/31/2012)
Scott, What does Erwin have that Visio doesn't that causes you to consider it a modeling tool while not considering Visio one?
I admit I haven't used Visio that...
July 31, 2012 at 10:33 am
Lucky9 (7/26/2012)
redesign database based on the new business requirements ... steps need[ed] ... when redesigning a database.
Spend some more time gathering, detailing and verifying your data requirements. Don't worry...
July 31, 2012 at 9:58 am
DataAnalyst110 (7/27/2012)
Scott, I'm going to go with yours because I can better understand what it is doing. (By the way, I didn't need the SUM,...
July 27, 2012 at 3:58 pm
Tempdb drives are much too small. SQL uses tempdb a lot, and you can't afford to run out of tempdb space.
I would not dismiss RAID5 for the db data...
July 27, 2012 at 2:45 pm
[Comment below; attempted to edit, instead it was re-posted with edits, so I removed the original comment.]
July 27, 2012 at 2:44 pm
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
Viewing 15 posts - 7,276 through 7,290 (of 7,608 total)