Viewing 15 posts - 17,911 through 17,925 (of 22,202 total)
I'd suggest picking up a copy of Craig Mullins book "Database Administration." It's technology agnostic and just talks about the job of being a DBA. It's a great read.
March 26, 2009 at 5:33 am
One option is to change the output of the results from a grid to text. Then the columns and the I/O all come out in a single window.
March 26, 2009 at 5:31 am
You should look up full text indexing for the varchar(max) column. That's the best mechanism for use with this sort of thing.
Are there other indexes on the table? A PK?
March 26, 2009 at 5:30 am
As Flo says, you shouldn't have to rebuild the index right after creating it.
Are you sure the index is working well with the query? Did the execution plan change before...
March 26, 2009 at 5:25 am
The truncate_only operation has been deprecated in SQL Server 2008. There is no replacement. The log is automatically truncated when the db is in simple recovery. There are more details...
March 26, 2009 at 5:22 am
This may not give you the answer, but it could help. Get the estimated execution plan instead of the actual one. I usually prefer to work only with the actual...
March 25, 2009 at 6:00 pm
I think I lost all the posts from this morning. That stinks. I wrote a couple of decent ones (for once). Ah well, no joy in Mudville.
March 25, 2009 at 4:46 pm
From conversations I've had with people who were on the committee, the DBA track has the fiercest competition. Since you're on that track... it'll be tough. But you know what,...
March 25, 2009 at 4:24 pm
GilaMonster (3/25/2009)
RBarryYoung (3/25/2009)
You know I am not getting my email alerts/updates this morning either. Something is definitely off.
Likewise. I've had one notification since about 9am this morning (GMT+2).
I...
March 25, 2009 at 9:39 am
RBarryYoung (3/25/2009)
I tried deleting the duplicates, but I don't think that...
March 25, 2009 at 9:37 am
The basic code doesn't cause locking all by itself. So, the problem must lie elsewhere. Are you getting errors? Does the code that's calling the proc have a transcation wrapper?
March 25, 2009 at 7:25 am
It does sound like you might be seeing the results of different paths through the execution plan working better for one data set than another. Check the execution plan for...
March 25, 2009 at 6:42 am
No, SQL Server will determine the order of resolution based on the indexes and their statistics on the table (or the lack thereof). You have very little control over the...
March 25, 2009 at 6:33 am
Viewing 15 posts - 17,911 through 17,925 (of 22,202 total)