Viewing 15 posts - 11,986 through 12,000 (of 49,552 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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 8:58 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 7:10 am
Don't please. That thread has enough mess in it already.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 6:35 am
Each procedure has its own execution plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 6:02 am
Reduce max server memory or add more memory to the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 3:28 am
Viewing 15 posts - 11,986 through 12,000 (of 49,552 total)