Viewing 15 posts - 15,991 through 16,005 (of 39,901 total)
Assertions are a great extra check, Eric. Thanks for the note.
May 31, 2011 at 9:47 am
Fair points, Elliot and it's one of the reasons I'm annoyed that TDE isn't in other editions. This is great for protecting the data at rest for situations where it...
May 31, 2011 at 9:46 am
there isn't anything wrong with what you see, nor will there be from our perspective. What you need to do is take these comments and run them against both servers...
May 31, 2011 at 9:14 am
Victor Kirkpatrick (5/31/2011)
May 31, 2011 at 9:10 am
If you've never done it, use the Profiler utility to connect to the server and start a basic trace (File New) against the server. This will tell you what commands...
May 30, 2011 at 7:00 pm
Run a trace when the application connects, see what is happening and check the same code on the main server, perhaps something is missing.
May 30, 2011 at 5:04 pm
Ultimately you do have to make some decisions on what to keep. Can your systems go back 2 weeks and still work? Or course, but if you go back that...
May 30, 2011 at 12:56 pm
Is this what you mean? Note that it doesn't cascade the values forward.
CREATE TABLE Foobar
( a1 datetime
, a2 datetime
, a3 datetime
, a4 datetime
, a5 datetime
)
GO
INSERT foobar (a1) SELECT '1/1/2011'
INSERT...
May 29, 2011 at 3:29 pm
I recommend keeping 2 fulls and the logs since around. After that, I've never seen the need to recover a database in the past to a point in time, so...
May 29, 2011 at 1:58 pm
Jeff Moden (5/28/2011)
Steve Jones - SSC Editor (5/27/2011)
Now we got the $27k Prius in '07, but got a $1500 tax credit and saved a ton of gas.
What did it do...
May 29, 2011 at 11:04 am
Stefan Krzywicki (5/27/2011)
I've been meaning to ask, how are your horses doing? I hear there's a quarantine in Colorado right now.
We're fine. Horses have been on property for weeks, so...
May 27, 2011 at 8:06 pm
bitbucket-25253 (5/27/2011)
May 27, 2011 at 5:27 pm
Jack Corbett (5/27/2011)
GilaMonster (5/27/2011)
Precon and spotlight! Could this PASS Summit get any better?
Sure, I could go, and attend the precon and the spotlight!
Side note for those not on Twitter, I...
May 27, 2011 at 2:49 pm
bitbucket-25253 (5/27/2011)
May 27, 2011 at 2:47 pm
Viewing 15 posts - 15,991 through 16,005 (of 39,901 total)