Viewing 15 posts - 2,176 through 2,190 (of 6,401 total)
These two links helps me out in scheduled jobs to ensure they only run on the primary
September 22, 2015 at 8:55 am
Ed Wagner (9/22/2015)
eccentricDBA (9/22/2015)
Ed Wagner (9/22/2015)
Eirikur Eiriksson (9/22/2015)
whereisSQL? (9/22/2015)
anthony.green (9/22/2015)
Ed Wagner (9/21/2015)
Revenant (9/21/2015)
djj (9/21/2015)
Eirikur Eiriksson (9/21/2015)
Deadweight
Lightweight
Prizefighter
UFC
MMA
Cage
Animal
Pet
Rock
Roll
tootsie
September 22, 2015 at 7:20 am
If you want to save it as REAL you will have to live with 1E+09 as REAL is actually FLOAT(24) and anything 24 or under is only a 7 digit...
September 22, 2015 at 3:12 am
Ed Wagner (9/21/2015)
Revenant (9/21/2015)
djj (9/21/2015)
Eirikur Eiriksson (9/21/2015)
Deadweight
Lightweight
Prizefighter
UFC
MMA
September 22, 2015 at 1:45 am
BL0B_EATER (9/18/2015)
Ed Wagner (9/18/2015)
anthony.green (9/18/2015)
Stuart Davies (9/18/2015)
Eirikur Eiriksson (9/18/2015)
SQLRNNR (9/17/2015)
DTAdistrust
circumspect
reckless
Driving
Fast
Limit
September 18, 2015 at 7:07 am
Stuart Davies (9/18/2015)
Eirikur Eiriksson (9/18/2015)
SQLRNNR (9/17/2015)
DTAdistrust
circumspect
reckless
September 18, 2015 at 1:49 am
Ed Wagner (9/17/2015)
anthony.green (9/17/2015)
BWFC (9/17/2015)
BL0B_EATER (9/17/2015)
Eirikur Eiriksson (9/17/2015)
anthony.green (9/17/2015)
Eirikur Eiriksson (9/16/2015)
Revenant (9/16/2015)
Ed Wagner (9/16/2015)
SQLRNNR (9/16/2015)
venomSnake
Eden
Utopia
Dystopia
Inferno
Heat
Hot
scoville
Habanero (yes, I'm one of those who actually like them)
capsaicin
September 17, 2015 at 6:15 am
Is it just the DB engine on the server or do you have IS/AS/RS installed also?
Any use of extended stored procs, sp_oa.... procedure calls or linked servers?
Whats the Memory: Available...
September 17, 2015 at 5:15 am
I had the same problem on a server with 64GB of RAM and SQL set to 60GB, reducing SQL's memory to 58GB ensured the plans where staying in cache.
Try dropping...
September 17, 2015 at 4:38 am
Whats the amount of RAM in the actual server
September 17, 2015 at 3:43 am
BWFC (9/17/2015)
BL0B_EATER (9/17/2015)
Eirikur Eiriksson (9/17/2015)
anthony.green (9/17/2015)
Eirikur Eiriksson (9/16/2015)
Revenant (9/16/2015)
Ed Wagner (9/16/2015)
SQLRNNR (9/16/2015)
venomSnake
Eden
Utopia
Dystopia
Inferno
Heat
Hot
scoville
September 17, 2015 at 3:24 am
IIRC xp_cmdshell runs as the engine account so you need to grant that account rights to the network shares.
September 17, 2015 at 3:20 am
Eirikur Eiriksson (9/16/2015)
Revenant (9/16/2015)
Ed Wagner (9/16/2015)
SQLRNNR (9/16/2015)
venomSnake
Eden
Utopia
Dystopia
September 17, 2015 at 2:00 am
If you do a select from sys.dm_exec_requests for the session_id in question it will give you the start and end statement offsets.
Its the number of characters into the statement the...
September 15, 2015 at 2:37 am
Viewing 15 posts - 2,176 through 2,190 (of 6,401 total)