Viewing 15 posts - 7,291 through 7,305 (of 7,613 total)
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
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...
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: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...
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 18, 2012 at 8:00 am
SELECT
[Database Name],
[Compression Ratio]
FROM (
SELECT
b.database_name 'Database Name',
...
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 17, 2012 at 3:20 pm
Sounds like RCS (Read-Committed Snapshot) is what you need here.
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 17, 2012 at 12:12 pm
takilroy (7/17/2012)
My intent is to see if anyone has been able to or knows of a way to create a global constant variable or use a sql function to determine...
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 17, 2012 at 11:57 am
I really think you're going to drive people crazy trying to follow this because no one else does it.
Almost universal is to use NULL to mean "no value was passed...
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 17, 2012 at 10:48 am
Viewing 15 posts - 7,291 through 7,305 (of 7,613 total)