Viewing 15 posts - 1 through 15 (of 85 total)
Nevermind:
sp_configure 'default trace enabled', 0
go
reconfigure
go
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
March 19, 2008 at 2:55 pm
In my sitituation, at least in DEV and QA, the preponderance of "disasters" involve an errant query. In this case, I restore to a new database and copy the...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
March 19, 2008 at 2:41 pm
Is there any way to turn this trace off?
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
March 19, 2008 at 2:05 pm
Couldn't you effectively do this by putting data and indexes on separate filegroups and only restore the data filegroup? Then just drop/recreate indexes?
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
March 18, 2008 at 1:02 pm
Baseline is the same as a benchmark.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
January 28, 2008 at 5:54 pm
That's what establishing baselines is all about. This tool can help you do that, but no tool does it for you.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
January 28, 2008 at 4:52 pm
I don't think you'd want to use this facility for point in time monitoring. However, you could use the data to establish benchmarks. And, as we do, use...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
January 28, 2008 at 10:53 am
This actually happened to me...twice! Both times I reported it; either to my supervisor or the payroll department.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
January 25, 2008 at 6:41 am
If it's the same error I've encountered in the past, it's because the step command (enclosed in single quotes ') spans multiple lines in the script.
What I usually...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
December 12, 2007 at 1:16 pm
Based on the rest of Microsoft's documentation, I'd choose the former. :crying:
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
December 12, 2007 at 12:50 pm
I cannot speak for Microsoft, but my guess would be they eliminated superfluous constructs from the physical model in the interest of performance.
I do the same thing. ...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
December 12, 2007 at 11:17 am
My 2 cents:
Logically, every table should have a primary key. Once we move into the physical realm, my philosophy is "less is better" or "prove you need it". ...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
December 11, 2007 at 7:14 am
I started working on it this morning. I should have something available no later than mid-week.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
November 27, 2007 at 7:51 am
That makes sense. I've run into that myself before.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
November 27, 2007 at 6:37 am
Perhaps that restriction pertains to a #TEMP table? All I know is the DTS works as coded.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
November 20, 2007 at 5:27 am
Viewing 15 posts - 1 through 15 (of 85 total)