Viewing 15 posts - 45,781 through 45,795 (of 49,571 total)
Carl Federl (7/11/2008)
create table...
July 11, 2008 at 3:11 pm
Check what perfmon says.
Process:Working set (and select sqlservr.exe)
Also check the total and target server memory (I think that's under SQL Server memory manager. It's under one of the SQL...
July 11, 2008 at 3:06 pm
Makes no difference. The order you specify the columns just determines the columnIDs, no guarantees that the columns will actually be stored in that order in the data pages.
July 11, 2008 at 3:01 pm
Set up profiler, monitor failed logins and make sure you get the hostname and applicationname columns. That should show you where the logins are coming from.
July 11, 2008 at 2:58 pm
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...
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...
July 11, 2008 at 2:48 pm
Jeff Moden (7/11/2008)
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...
July 11, 2008 at 2:38 pm
Is the job still running?
What does that proc do?
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...
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...
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...
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...
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...
July 11, 2008 at 2:15 pm
All it means is that the statement in question is not valid SQL. It could be anything
July 11, 2008 at 7:56 am
Viewing 15 posts - 45,781 through 45,795 (of 49,571 total)