Viewing 15 posts - 33,991 through 34,005 (of 49,552 total)
sqldba551 (2/16/2010)
February 16, 2010 at 1:36 pm
It looks like there are some non-printable characters that aren't spaces but look like spaces. Edit the whole thing onto a single line then re-format. Seems to work
February 16, 2010 at 7:28 am
kingscriber (2/16/2010)
It would seem that Exists needs to perform full table scans within that view?
No it doesn't
Maybe the optimizer doesn't work for functions like this?
Sure it does.
The execution plan...
February 16, 2010 at 7:05 am
muthukkumaran (2/16/2010)
The OP create a Non clustered index,so i guess the table was Heap.
How do you conclude that?
February 16, 2010 at 7:03 am
How about looking in Books Online?
allow updates Option
This option is still present in the sp_configure stored procedure, although its functionality is unavailable in SQL Server. The setting has no...
February 16, 2010 at 7:00 am
The error's not about the filestream. Check the setting for allow updates, I'd guess someone for some reason has set it to 1.
February 16, 2010 at 6:35 am
muthukkumaran (2/16/2010)
Object have cluster index ?
It's not required that a table have a clustered index in order to defragment a nonclustered index.
February 16, 2010 at 6:34 am
Please post new questions in a new thread. Thanks
February 16, 2010 at 5:58 am
Dave Winchester (2/16/2010)
1: IsDeleted / FlaggedForDelete FlagI believe that when a record is deleted, the tables is locked whilst this happens and then released?
No. The row will be locked,...
February 16, 2010 at 5:58 am
It's not a program, it's just a class of commands that the SQL engine understands, just like CREATE TABLE and the like.
You can use sp_helptext to see the definition of...
February 16, 2010 at 5:48 am
How big's the table? How many pages?
February 16, 2010 at 5:46 am
Not if those tasks have been scheduled nightly.
You can move master from one server to another. It often results in lingering, hard to debug issues, especially around server principals, but...
February 16, 2010 at 5:42 am
GT the risk that you're running there is that if that manual stats update was needed, some queries may now exhibit slow performance occasionally, when the stats are stale enough...
February 15, 2010 at 9:58 pm
Take a look at this, see if the error you're getting is detailed and worked through. If not, post the error.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
February 15, 2010 at 9:55 pm
GT-897544 (2/15/2010)
February 15, 2010 at 11:46 am
Viewing 15 posts - 33,991 through 34,005 (of 49,552 total)