Viewing 15 posts - 316 through 330 (of 356 total)
Thanks Craig you already helped me.
I will check tomorrow the options you mentioned: LOB fields - as far as I remember there is none - but holly double check :-),...
November 23, 2010 at 4:38 pm
Hi,
How are you upgrading the databases?
See this for understanding the FileStream:
http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx
Regards,
Iulian
November 23, 2010 at 4:27 pm
I am sorry Chris I don't have the table structure at hand.
Thanks,
Iulian
November 23, 2010 at 4:14 pm
I have a few columns: nvarchar(255) and a few with varchar(50) could this be the cause?
50MB is not such a bog size I just can not explain how 1000...
November 23, 2010 at 4:13 pm
Below query returns the required result:
select * from tempdb..sysobjects where name like '#testvm%'
Indeed Hardy21 it works, I also tried with:
select * from tempdb..sysobjects where name like '#testvm'
and...
November 22, 2010 at 3:37 am
Thanks for the explanation vk-kirov and mtassin.
Regards,
Iulian
November 20, 2010 at 1:59 pm
The question is challenging and asks for more attention on details when reading, this is not one of my main strengths.
I read the documentation, was lucky to find here:
...
November 19, 2010 at 4:30 am
One innocent remark that does not minimize the high value of the question. I am thinking to drop tbl1 and tb2 tables at the end of the script:
DROP TABLE tbl1
DROP...
November 18, 2010 at 1:50 am
Great point. Amazing, the compiler see two creations of the #tmpID table and stops the procedure from compiling.
Do you have at hand some best practices for using DML statements?...
November 18, 2010 at 1:43 am
Great question, thank you.
I answered wrong by assuming there is no place for compressing bit fields more than it already does, in this case to one byte, I should have...
November 17, 2010 at 12:33 am
Thank you UMG, undeed great statistics.
Looking at the alternative with nested select I tend to chose the GROUP OVER, it seems to me more elegant.
Regards,
Iulian
November 10, 2010 at 2:55 pm
Nice one Andrew. I can hardy wait to test it.
Regards,
Iulan
November 4, 2010 at 2:19 am
Nice question, thank you.
It works for me.
Iulian
November 4, 2010 at 2:13 am
Viewing 15 posts - 316 through 330 (of 356 total)