Viewing 15 posts - 4,861 through 4,875 (of 9,241 total)
The following should help
SELECT jobs.name,
jobs.enabled,
SUSER_SNAME(jobs.owner_sid) as Owner
FROM msdb.dbo.sysjobs as jobs
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2012 at 4:23 pm
Jeff Moden (10/6/2012)
and my answer was that I basically interview anyone that applies.
Jeff Moden (10/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2012 at 8:37 am
Grant Fritchey (10/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2012 at 2:07 am
Jeff Moden (10/6/2012)
Someone on this thread asked what I looked for on resumes
i did 😉
Jeff Moden (10/6/2012)
and my answer was that I basically interview anyone that applies.
so you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2012 at 1:35 am
Yes a read is a page. A logical read may need to initiate a physical read first if the requested page is not in cache.
more info may be found at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2012 at 12:56 am
No, just follow the link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2012 at 3:45 pm
Konuri Dinesh (10/6/2012)
I moved My MSDB database to another location. after that i tried to start my server but unfortunately it can't 🙁
i done it by following steps
step:1
SELECT ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2012 at 3:40 pm
a logical read is the pages that are read in memory, a physical read is when the page is brought in from disk
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2012 at 3:39 pm
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 4:07 pm
yeohbk (10/5/2012)
Can anyone share with me the information on how to configure SQL Mirroring and MS Clustering for SQL? I need to configure them and it would be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 1:16 pm
SQLCrazyCertified (10/5/2012)
Hi All,If you have mirroring or logshipping setup as a DR solution......Do you need have a backup policy/plan on top of it?
Yes you do!
It sounds like you haven't so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 12:18 pm
MysteryJimbo (10/5/2012)
That's correct if you want minimal overhead but you can manually move files if you have different drives.
Yes, but if you read the post the user wants to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 9:30 am
Jeff Moden (10/5/2012)
CptCrusty1 (10/5/2012)
A caveat to this, Sir Moden, is that someone could actually have 10 years exp, but the question is the quality/type of exp they have.
That's precisely the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 8:43 am
CptCrusty1 (10/5/2012)
Sir Moden
😀 he should defo get a pork chop in the boat for that one
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 8:39 am
For an add file to be seamless you need to ensure the paths on both instances match
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 5, 2012 at 8:33 am
Viewing 15 posts - 4,861 through 4,875 (of 9,241 total)