|
|
|
January 2003 March 2003 April 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 July 2007 August 2007 September 2007 October 2007 |
question about log file size when alter Huge table Posted by Gordowey at 10/30/2005 4:33:42 PM I have the next question, and i would like to hear what do you think
about, and if is there a better solution for "my problem"
here is the question, I have a huge table with 60GB of data (image
files). The problem happen always when i try to ALTER the structure of
the table. For example I ch...more >>
How to search for a '%' using like and/or Full-Text Posted by albertoiriarte NO[at]SPAM gmail.com at 10/20/2005 11:53:39 AM Hi all, I have 2 questions
1.- How can i search for "%" using like
select * from table where sfield like '%%%'
is not working!
2.- I am using Full-text catalog in one table of my db, i would like to
know if i can search for % using
CONTAINSTABLE(TABLE.....
thanks
Alberto
...more >>
Need help with the sample size of auto-updated statistics Posted by pshroads NO[at]SPAM gmail.com at 10/17/2005 9:27:58 AM I have several indexes on large tables that are very selective when I
update the statistics manually with a full scan but are much less
selective when a small sample size is used (which seems to happen when
the statistics are automatically updated).
Is there a way to guarantee that when statis...more >>
Log File Posted by Reggie at 10/17/2005 4:19:28 AM Hi and TIA! Here's my log file and was wondering why the WSMDDT starts so
many times. Also was wondering that why when I script out my database and
install it on my other server several of the views don't get created(error)
due to the fact the some of the views that ar included in the error ...more >>
SQL Performance Counters Show 0 Posted by chongyew NO[at]SPAM pobox.com at 10/1/2005 6:15:53 AM Hi!
I've recently installed SQL Server Workgroup Edition. When I add in the
SQL performance counters in Performance Monitor, they all give me a
reading of 0!
I've got another server running SQL Standard Edition and it shows up
fine... also, I've read and done the steps described in this...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |