Viewing 15 posts - 2,161 through 2,175 (of 7,613 total)
I think there is one way you can try the upgrade path.
IF your san/disk/software allows you to snapshot a given point-in-time on disk, and accurately restore everything on disk (including...
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".
November 12, 2020 at 2:27 pm
OP = "original poster", i.e., the person that originally asked the q (or, rarely used and only by some people, "original post")
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".
November 11, 2020 at 8:52 pm
The actual database and logfiles should preferably be kept on same drives as they are now.
The most simple approach I can come up with is:
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".
November 11, 2020 at 4:16 pm
I think you're correct, you should do this for all tables. No sense wasting resources scanning a 900-row table either. Of course that 900 rows could be far...
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".
November 11, 2020 at 12:13 am
I think you're correct, you should do this for all tables. No sense wasting resources scanning a 900-row table either. Of course that 900 rows could be far larger than...
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".
November 10, 2020 at 8:35 pm
Hmm, I wouldn't think there'd be a direct money charge just from having to reread something into RAM. Then again, that could change by vendor I guess (we use MS).
But...
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".
November 10, 2020 at 8:31 pm
/*INSERT INTO dbo.input_Main_data ( ... )*/
SELECT new_rows.*
FROM dbo.input_Main_data iMd1
CROSS APPLY (
SELECT TOP (1) *
FROM dbo.input_Main_data iMd2
...
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".
November 10, 2020 at 8:04 pm
SQL row/page compression is typically extremely helpful to reduce disk space. Before SQL 2016, I believe you must have Enterprise Edition for it to be available.
Yes, I...
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".
November 10, 2020 at 2:15 pm
I see the big issue as one of less RAM. I suspect the max ram you receive will be far less than what you'd get in an on-premises db.
When fragmentation...
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".
November 10, 2020 at 2:12 pm
Here's a method I often use. "Ideal", don't know.
Use full backups and differentials. Generally a differential restores very quickly (you can do the "base" restore of the full backup ahead...
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".
November 9, 2020 at 5:25 pm
If hyperthreading is present (most CPUs use this nowadays), set MAXDOP to no more than half the cores, in your case 4.
If NUMA is being used, set it to 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".
November 9, 2020 at 4:24 pm
SQL row/page compression is typically extremely helpful to reduce disk space. Before SQL 2016, I believe you must have Enterprise Edition for it to be available.
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".
November 9, 2020 at 4:18 pm
In the main table storage area, a row will be on one and only one page. Any other data for that row must go to overflow pages.
-1- There's not an...
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".
November 9, 2020 at 4:15 pm
You could try making the data type "rowversion" or "binary(8)" just to see if it works.
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".
November 9, 2020 at 4:09 pm
Agreed, the best thing would be to review the query plan. Even the estimated might give you some idea of the differences between the two queries. To get the actual...
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".
November 8, 2020 at 1:36 am
Viewing 15 posts - 2,161 through 2,175 (of 7,613 total)