Viewing 15 posts - 11,986 through 12,000 (of 49,562 total)
Why?
What problems are they causing?
Do you know what they were doing?
Do you know if the applications can handle a terminated connection?
August 23, 2013 at 9:34 am
That's a client error, not server. It's a .Net memory error (sql server is not written in .net)
You're running Management Studio, on your client machine out of memory. Nothing to...
August 23, 2013 at 9:06 am
Sean Lange (8/23/2013)
SQLRNNR (8/23/2013)
Koen Verbeeck (8/23/2013)
ChrisM@Work (8/23/2013)
GilaMonster (8/23/2013)
Fal (8/22/2013)
We...
August 23, 2013 at 8:58 am
Don't please. That thread has enough mess in it already.
August 23, 2013 at 7:06 am
There is no difference!
But with logshiping allows/does f1(manual restore,with standby option),t1,t2(logship restore full backup job),f2(replace,restore manually full backup) then t3(logship restore job) (all with standby options).
No, log shipping does NOT...
August 23, 2013 at 6:35 am
Each procedure has its own execution plan.
August 23, 2013 at 6:03 am
You wouldn't restore f3 in that scenario, there's no point it will just overwrite what's already there. Log shipping does not ship and restore full backups, that would be an...
August 23, 2013 at 6:02 am
Reduce max server memory or add more memory to the server.
August 23, 2013 at 5:52 am
Rather than tracing the statement started and completed, maybe trace the User Error Message event.
p.s. It won't be trying to delete from a table in a schema that doesn't exist,...
August 23, 2013 at 5:48 am
What do you mean 'the delete does not delete'?
Fails with an error?
Hangs forever?
Completes but affects 0 rows?
Implodes the server and creates a black hole in the server room?
Something else?
August 23, 2013 at 4:47 am
The only comparison with NULL that can return TRUE is the IS NULL/IS NOT NULL comparison.
'x' = NULL returns UNKNOWN, not TRUE or FALSE
'x'<> NULL returns UNKNOWN, not TRUE or...
August 23, 2013 at 4:43 am
anoop.mig29 (8/23/2013)
GilaMonster (8/11/2013)
anoop.mig29 (8/10/2013)
But suppose before T3 i take full backup F2 then i cannot restore T3 untill F2 is restored.
Sure you can. Full backups do not in any way...
August 23, 2013 at 4:40 am
ChrisM@Work (8/23/2013)
Do you know which granite, Gail?
It's mostly dark red with black specks.
August 23, 2013 at 3:32 am
Figure out what problems are causing the stack dumps that generate the files. Fix whatever the root cause is.
To be honest, the priority shouldn't be stopping the file generation, it...
August 23, 2013 at 3:28 am
Viewing 15 posts - 11,986 through 12,000 (of 49,562 total)