Viewing 15 posts - 42,976 through 42,990 (of 49,566 total)
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
Try putting a check just before the exists, run the proc from management studio and see what you get back.
SELECT @foundFolderId
SELECT * FROM pageList WHERE folderID = @foundFolderId AND...
November 25, 2008 at 11:29 am
Multiple separate RAID arrays is best. The log and data files should be physically isolated from one another.
November 25, 2008 at 11:17 am
supatpong (11/25/2008)
Thank you for many support. Now I trying to find software tool.
Don't bother. All the log reader tools need the database to be online. Besides, all that you'll...
November 25, 2008 at 11:06 am
Exists doesn't return false results.
Are you sure that the variables are such that rows may not exist? Maybe put a statement just above that to insert the rows that...
November 25, 2008 at 10:53 am
It's not a new concept. It existed on SQL 2000 as well. Probably 7 too, though I don't have any docs.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
Significant quotes:
Tail of transaction log
The transactions that have been committed...
November 25, 2008 at 10:26 am
Viewing 15 posts - 42,976 through 42,990 (of 49,566 total)