Viewing 15 posts - 45,766 through 45,780 (of 49,552 total)
Dugi (7/11/2008)
It seems that you should close the conn, but also try to restart all services on the Instance where you are working!:w00t:
That's a tad extreme to get rid of...
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
July 11, 2008 at 2:50 pm
Michael Valentine Jones (7/11/2008)
They didn't really announce that they are releasing SQL Server 2008. They announced that they are adding it to the price list.
True, but the TPC benchmark...
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
July 11, 2008 at 2:48 pm
Jeff Moden (7/11/2008)
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
July 11, 2008 at 2:44 pm
William (7/11/2008)
So based on what you've quoted from BOL would you say that those conditions when a Checkpoint occurs are not RECOVERY MODEL specific so that my using a...
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
July 11, 2008 at 2:38 pm
Is the job still running?
What does that proc do?
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
July 11, 2008 at 2:32 pm
David Griffiths (7/11/2008)
So my point remains: some deadlocks are unavoidable because they are inherent in the design of SQL Server.
Could you post some code for the update and the select...
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
July 11, 2008 at 2:32 pm
If you did not create the temp table, you cannot drop it. Only the connection that created the temp table can drop it.
The table will be deleted when it goes...
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
July 11, 2008 at 2:22 pm
There are examples of how to use it in Books Online.
CheckDB generates a lot of info messages as it runs. If it finds any errors it will tell you. As...
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
July 11, 2008 at 2:21 pm
Michael Earl (7/11/2008)
Ok, I have to ask, what possible method of tracking changes could you be using that would be impacted by when a checkpoint happens?
Reading the active portion of...
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
July 11, 2008 at 2:16 pm
Perry Whittle (7/11/2008)
GilaMonster (7/11/2008)
The related effect of the fill factor is to increase the number of pages in the index.and consequently the overall file size.
As well as the depth of...
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
July 11, 2008 at 2:15 pm
All it means is that the statement in question is not valid SQL. It could be anything
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
July 11, 2008 at 7:56 am
Bear in mind that was a very simple 2 table database that I played with there. Don't assume that the 0% will apply to more complex DBs with more...
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
July 11, 2008 at 7:51 am
A time table - Physics 101, Lecture room 2B, 9am every monday.
Movie schedules. Movie X shows every day this week at 17:00, 20:30 and 23:00
A store list with their opening...
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
July 11, 2008 at 7:35 am
Michael Earl (7/11/2008)
However, use the JOIN keyword. The old syntax with tables spearated by commas and...
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
July 11, 2008 at 5:48 am
Freeproccache clears out all cached plans, for both stored procs and adhoc queries.
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
July 11, 2008 at 5:39 am
Viewing 15 posts - 45,766 through 45,780 (of 49,552 total)