Viewing 15 posts - 5,611 through 5,625 (of 7,619 total)
You'll need to create a start up proc for each instance that checks for the different conditions.
Since you have to change both instance's memory settings, I'd create a proc 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".
December 1, 2014 at 4:12 pm
ZZartin (12/1/2014)
ScottPletcher (12/1/2014)
GilaMonster (11/30/2014)
river1 (11/28/2014)
What do you mean by stop using select?
I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and...
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".
December 1, 2014 at 3:22 pm
GilaMonster (11/30/2014)
river1 (11/28/2014)
What do you mean by stop using select?
I didn't say stop using select. I said stop using SELECT *. Explicitly define what columns you need and you won't...
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".
December 1, 2014 at 2:24 pm
Also, as additional stop-gap measures:
1) review indexes to see if there any you can drop
2) if you have any heaps, see if they consume a lot of space beyond what...
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".
December 1, 2014 at 11:59 am
zedtec (11/25/2014)
ERROR 1222 : Lock request time out period exceeded.
I killed a session...
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 25, 2014 at 9:52 am
In theory, the code below would do what you've described.
select t2.*
from Table2 t2
where
exists(select 1 from table1 t1 where t2.detail like '%' + t1.ID +...
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 25, 2014 at 9:47 am
ZZartin (11/21/2014)
g.britton (11/21/2014)
ScottPletcher (11/21/2014)
You don't "have" to do the FETCH twice. In fact, I never do that, because it's too error prone when the code is changed.
good point, though...
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 21, 2014 at 3:45 pm
g.britton (11/21/2014)
ScottPletcher (11/21/2014)
You don't "have" to do the FETCH twice. In fact, I never do that, because it's too error prone when the code is changed.
good point, though 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".
November 21, 2014 at 3:02 pm
I use a different approach.
I have a nonbusiness dates control table where one first defines the general and specific nonbusiness dates wanted. Then you call a stored proc with...
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 21, 2014 at 2:43 pm
You don't "have" to do the FETCH twice. In fact, I never do that, because it's too error prone when the code is changed.
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 21, 2014 at 2:38 pm
He already has a partial design in place, I suspect his previous Developer left him with a few ideas, now he's asking if I can help him through.
First, start over...
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 21, 2014 at 1:20 pm
Jeff Moden (11/20/2014)
ZZartin (11/20/2014)
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 20, 2014 at 3:37 pm
No, DBAs should not know and definitely not store end user passwords, period.
App passwords are a different matter, and it can depend on the app. But stored passwords should...
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 20, 2014 at 2:02 pm
You can't calculate "work hours" without "in" and "out" markers. The work time calc is very easy if you a matching "out" for every "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".
November 20, 2014 at 1:46 pm
In other words, you need to create a new table that explicitly specifies the clause:
CREATE TABLE ... (
...
TEXTIMAGE_ON [new_filegroup_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".
November 20, 2014 at 1:23 pm
Viewing 15 posts - 5,611 through 5,625 (of 7,619 total)