Viewing 15 posts - 42,976 through 42,990 (of 49,571 total)
MarkusB (11/25/2008)
It will consider all queries which qan since the last time SQL Server started.
Not quite. It will consider all queries whose execution plans are still in cache. As soon...
November 26, 2008 at 7:59 am
Magy (11/25/2008)
Im sorry...I'm using SQL Server 2000...what is sp_stmtcompleted?
It's a profiler event. Under the Stored Procedures group. It traces each statement within a proc. It can get intensive so make...
November 26, 2008 at 7:55 am
kotlas7 (11/25/2008)
can we put the database in recovery mode after taking the tail backup in sql server 2000?
Sure. Add the NoRecovery option to the log backup statement along with no_truncate.
The...
November 26, 2008 at 7:49 am
I don't understand exactly what you're saying.
If you have space constraints, get more space. Repeatedly shrinking the dataabse and log (and having them grow again) will cause index fragmentation, internal...
November 26, 2008 at 7:46 am
Sure. Tonnes
Try these for starters:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
November 26, 2008 at 7:45 am
shekihan (11/24/2008)
November 26, 2008 at 7:28 am
Jerry Hung (11/25/2008)
Thanks GailI think Total Working Sets dropped when it happened (_Total and sqlservr)
it was 7000000+, and now 1.3e+010 (sql: 1.2818e+010)
That's not a decrease. 1.3e+010 is scientific notation...
November 26, 2008 at 7:26 am
Windows groups are best. Get the developers added to a windows group, grant that group a login to SQL. Create roles for permissions and add those roles to the group.
Make...
November 25, 2008 at 12:23 pm
How big were the tables in question?
Small tables don't show changes in fragmentation, and there's no need to worry about fragmentation on small tables. (~100 pages)
November 25, 2008 at 12:16 pm
Stick a print or select inside the IF block, see if that prints out, or if the update is coming from somewhere else.
You can also trace the exact steps that...
November 25, 2008 at 12:05 pm
Check the Total Working Sets counter in perfmon. See if the total working set of all processes decreases or if it remains steady when this happens.
What else is running on...
November 25, 2008 at 11:55 am
It prints results on each execution? Means that the exists is correct, there are always rows.
November 25, 2008 at 11:51 am
Couple more recommendations
Chat with other people between sessions. Everyone has something that they can teach you, and you can make friends that you can chat with long after the conference
Chat...
November 25, 2008 at 11:48 am
The first problem is that you have two table scans. Second problem is that you're getting a hash join because you have no indexes.
Add indexes to support the join and/or...
November 25, 2008 at 11:43 am
Viewing 15 posts - 42,976 through 42,990 (of 49,571 total)