Indid 255 is text, ntext or image data. Do you have any of these types within your table?
You may also want to review the fill factor's of your indexes on this table as well as others. If you are hitting 20% fragmentation on a daily...
Hi, Not really, no. I did spend a couple of weeks trying to work on an algorithm - I even worked with some engineers at Microsoft who could also...
As suggested, you'll need to set up SQL Agent to use the mail system too. As for the net send and pager, I don't use these at all. Net send will...
That's a lot of work. More than one plan for sure. In order for the community to assist, I think you need to ask for help on one topic at a time...
I performed a quick test by running a remote query from within a cursor. The connection was reused in my tests. I tried several sequential queries...
If you are in a position to do so, I would recommend buying SQL Compare and SQL Data Compare from redgate software. We use both frequently. If it...
First things...Have you run a profiler trace to identify any queries that are particularly running slow? I'd suggest running a profiler trace as...
The level of fragmentation is really dependent on your environment. I generally look for anything over 10% but it's really dependent on your...
Doubt my company would send me..... <img src='/community/emoticons/emotion-3.gif' alt=':o' />(<br /><br />Boooooooooo!! Would love to attend one of...
Although I agree with the number of the indexes on the tables is exessive, you didn't mention the state of the indexes. Is there regular...
How did you actually move the databases to the new server? Full restore of system and user database? The standard sql server installation out of...
Try running SET ROWCOUNT 0 and then run the query... Clive Strong SQL Server DBA
Hi, In these circumstances, I would schedule some downtime. Once I have the downtime, I would stop the application's, disable any services that...
Well...Unfortunately, the code is owned by another company. And I don't know if this code was written by the original developers or if it was one...
Hey, Quick update. Although there is some fragmentation, it's not really this database that is causing the problem! The environment is set up with...
Thanks for that. I'll take a read through those resources...I wish I stored my favourites lists when I changed jobs...Lost all my saved links!...
OK... I am looking at a customers database with complaints of slow performance. I am looking at a specific table that has some 135k rows. This...
Separate names with a comma.
