Viewing 15 posts - 211 through 225 (of 687 total)
what is the collation and data type of the field storing the current date?
August 6, 2012 at 6:55 am
The topic of Derek Jeter comes up a lot with a coworker of mine. I think he's a pretty decent player. He holds a few club records and a few...
August 3, 2012 at 12:24 pm
Ray K (8/3/2012)
nwerner (7/31/2012)
grumble, grumble, grumble.The best days are when BOS loses.
+1
+10 😀
hey hey hey!
Enough ganging up on me or I'm tellin' Steve!
August 3, 2012 at 11:34 am
So when you right click the job and start it it does nothing.
When you right click the job and check the job history, what does it say is the result...
August 1, 2012 at 7:08 am
Perhaps you can run the backup code by itself, outside the scope of the job.
BACKUP DATABASE [database] TO DISK = '<path>'
If this works, it's not a backup issue but a...
August 1, 2012 at 6:59 am
What is the exact error you are getting. If the backup fails, it's gotta tell you why.
August 1, 2012 at 6:52 am
First way I think of is using a combination of NULLIF and ISNULL
SELECT
ID,
ISNULL(NULLIF(val,''),0) AS val,
ISNULL(NULLIF(ser,''),0) AS ser,
ISNULL(NULLIF(sa,''),0) AS sa
FROM @test1
August 1, 2012 at 6:51 am
TDE enabled databases can't be compressed. Although this shouldn't stop a backup from running, it is the only thing I can think of off the bat.
Are you compressing them?
Edit: I...
August 1, 2012 at 6:02 am
Steve Jones - SSC Editor (7/30/2012)
calvo (7/30/2012)
July 31, 2012 at 6:44 am
Oh man! It only took a double ejection, extra innings, and lady luck to pull it off but Boston took 2 of 3 in NY!
That's great news, it means...
July 30, 2012 at 11:54 am
I too like Ichiro, never hear bad things about him. Kinda weird though, the whole thing happening in Seattle. One day he's 51, next day he's 31.
Wow. If Lester hit...
July 25, 2012 at 6:24 am
A couple things, there is no date for 1/28/2011 as you specify in your expected result so I'm assuming that was a typo on the insert statement. I see another...
July 18, 2012 at 9:59 am
Please do not double post, it's not good.
All replies here
July 17, 2012 at 8:04 am
Is there an open transaction on which these processes are waiting?
select @@trancount
July 17, 2012 at 7:44 am
David Webb-200187 (7/2/2012)
Potential world enders:...
Population explosion
...
Literally? Yeah, I could see that ending life on earth...
/rimshot
July 16, 2012 at 6:45 am
Viewing 15 posts - 211 through 225 (of 687 total)