Viewing 15 posts - 7,291 through 7,305 (of 7,619 total)
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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.]
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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 =...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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 ......
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 23, 2012 at 1:43 pm
tim.cloud (7/23/2012)
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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,...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 19, 2012 at 4:00 pm
hisakimatama (7/19/2012)
Alternatively, I could create a table for each month, and track sales...
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
July 19, 2012 at 3:34 pm
Viewing 15 posts - 7,291 through 7,305 (of 7,619 total)