Viewing 15 posts - 13,741 through 13,755 (of 22,213 total)
Apologies. I think that might have sounded more argumentative than I meant for it to.
I agree. There are a number of ways to skin this particular cat. None of them...
December 29, 2010 at 7:46 am
If it's all for a single application, I'd go with schema's to seperate out storage, access, security. This way you can have referential integrity across the schema's as needed, something...
December 29, 2010 at 7:44 am
For the absolute best PowerShell training, I recommend tracking down Don Jones and seeing when he's offering a class in your area. His training is excellent.
December 29, 2010 at 7:42 am
I'm not sure what the problem might be, but why are you taking a differential backup at one minute intervals, but only backing up the log once an hour. It...
December 29, 2010 at 7:40 am
I think the error you're getting is "fallback certificate initialization failed"
I've never heard of this error myself, but it seems that it's not uncommon[/url]. It may have something to do...
December 29, 2010 at 7:37 am
If you want to capture performance counters in TSQL, instead of using extended calls, which can be very problematic, and require different security settings that might not be all that...
December 29, 2010 at 7:32 am
2005 or above, I'd go to sys.dm_exec_requests to see which processes are running slow, which ones have wait states, which ones are blocked. You can combine it with sys.dm_exec_sessions to...
December 29, 2010 at 7:28 am
Agreed with Pradeep. However, the best way to be sure the backup is valid is to have tested it against another server in an actual restore. For some of our...
December 29, 2010 at 6:39 am
You can use Profiler to capture statement starts, but if a statement errors out, Profiler doesn't catch that completion event because it didn't fire. I agree with everyone else. I'd...
December 29, 2010 at 6:37 am
Sounds like you got past the issue. I strongly recommend the approach you took, rewriting the query to use better mechanisms as a tuning method. I really, really, hate what...
December 29, 2010 at 6:32 am
GSquared (12/28/2010)
What I recommend, however, is if the data is the same in each database, move it to one database and have the...
December 29, 2010 at 6:28 am
Steve Jones - SSC Editor (12/28/2010)
WayneS (12/28/2010)
(From a higher...
December 29, 2010 at 6:22 am
WayneS (12/28/2010)
(From a higher level) How to set up...
December 29, 2010 at 6:19 am
Henry Treftz (12/28/2010)
December 28, 2010 at 12:33 pm
Viewing 15 posts - 13,741 through 13,755 (of 22,213 total)