Viewing 15 posts - 42,541 through 42,555 (of 49,552 total)
I see why.
It's the insert into A straight after the creation of the temp table. That forces a recompile of the entire proc (because the temp table didn't exist when...
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
December 5, 2008 at 10:25 am
Script looks fine. The SQL service has to be restarted for this to take effect. Until it is, the change is only made in the database metadata.
Edit: I would strongly...
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
December 5, 2008 at 10:21 am
raviraikulkarni (12/5/2008)
sequence is not available available the how to
restore to point in time
for eg. i have transactional...
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
December 5, 2008 at 10:12 am
Garadin (12/5/2008)
RESULT:Server: Msg 207, Level 16, State 1, Procedure Seth_ACTest, Line 13
Invalid column name 'B'.
No clue why it works in one and not the other.
I ran your second...
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
December 5, 2008 at 10:11 am
Table definitions please, index definitions and the execution plan, saved as a .sqlplan file, zipped and attached to your post.
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
December 5, 2008 at 9:46 am
Oksana March (12/5/2008)
Can you explain why? it is because of performance reasons?
They're used waay too much by people who think they're a great solution and they perform terribly. SQL...
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
December 5, 2008 at 9:45 am
baumgaertner (12/5/2008)
There must be a possibitly.
To do what?
Why do you need to add columns to a table inside a stored procedure?
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
December 5, 2008 at 9:41 am
Schadenfreude-Mei (12/5/2008)
I have recently setup BES replication, to do this the instructions prompted me to change recovery model to FULL.
What's BES Replication?
I've got, on my desktop, a replication...
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
December 5, 2008 at 9:26 am
Nicholas Cain (12/5/2008)
Transactional replication is the way to go.
Agreed. This is almost a textbook case for transactional replication
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
December 5, 2008 at 6:24 am
It looks like it needs an existing DB selecting, but you can type a new DB name into that box
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
December 5, 2008 at 6:21 am
Schadenfreude-Mei (12/5/2008)
So its only Transaction Replication that needs Full/Bulk? I didnt know that i thought it was Replication in general.
No. As I said above
Replication does not require any particular recovery...
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
December 5, 2008 at 6:20 am
Taking one step back... Why do you need to add columns to a table in a stored procedure?
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
December 5, 2008 at 4:49 am
Did the installation of the patch give any errors?
I think you may want to take this issue to Microsoft's customer support. They're probably going to be able to help you...
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
December 5, 2008 at 4:48 am
Schadenfreude-Mei (12/5/2008)
To allow replication you db must be in Full or Bulk recovery model.
Replication does not require any particular recovery model. All forms of replication (snapshot, transactional, merge) work fine...
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
December 5, 2008 at 4:41 am
Consider transactional replication rather.
Mirroring is a high-availability solution, not for reporting.
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
December 5, 2008 at 1:53 am
Viewing 15 posts - 42,541 through 42,555 (of 49,552 total)