Viewing 15 posts - 2,551 through 2,565 (of 7,164 total)
I do, just wondering how the spreadsheet you shared was created. Deleting extra rows + save As or copy rows into a new sheet. It could have made a difference...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 1:01 pm
I meant in the one you attached to this thread. How did you construct the one you attached, the one I was able to load with no issues?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 12:03 pm
GilaMonster (1/2/2013)
opc.three (1/2/2013)
Are you thinking of reorganize?
No.
I thought a rebuild would re-scan the clustered same as a drop+recreate which would work since all inconsistencies were found in the nonclustered...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 12:01 pm
DB_Newbie2007 (1/2/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 10:49 am
Golfer22 (1/1/2013)
I understand that change tracking writes changes to "internal tables." Are these in the database that the change tracking is occuring on?
The internal change tracking tables reside in...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 10:38 am
Bhuvnesh (1/2/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 10:17 am
Golfer22 (1/1/2013)
I believe hash joins can cause growth in the tempdb if there is insufficient memory. I don't think nested loops do.
No, I do not think nested loops would...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 10:16 am
Makes perfect sense. You're quite welcome.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 10:10 am
Did you mean DBCC CHECKDB or the operating system routine CHKDSK?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 10:07 am
xp_readmail is for SQL Mail, which is deprecated.
In my opinion this kind of work should be done way far away from the database engine. There are many applications out there...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 9:56 am
Why didn't I have trouble loading the data? Did you post a modified version of the original spreadsheet?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 9:52 am
wmalik001 (1/2/2013)
Thanks a lot Mark, that did the trick, could you also tell me the best resource/book for sql programming? 😀
I owe a great deal to the kind folks who...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 9:50 am
a_ud (1/2/2013)
My main doubt is: Can all these commands be placed one after another, like:DELETE FROM tblIDNames
....
UPDATE tblIDValues SET IDNumber=0, .....
etc
Sure. Use a batch separator to separate different "chunks" of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 9:37 am
Reformatting the Agent job output for easier reading:
Executing the query "DBCC CHECKDB(N'SLine2') WITH NO_INFOMSGS " failed with the following error:
Table error: table 'doc' (ID 142623551). Data row does not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 8:49 am
You'll have to zip it first and then attach the zip file. dtsx is not a supported extension afaik.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 2, 2013 at 8:41 am
Viewing 15 posts - 2,551 through 2,565 (of 7,164 total)