|
|
|
March 2003 May 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 December 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 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Sql database search slow Posted by John at 3/31/2005 8:27:19 AM We have winxp workstations with a client software that connects to a win2k3
server with sql 2k & sp3 installed to access a medical database where we
pull up the patients information. About a week ago 2 of the stations became
slower then normal when searching information from the database cause n...more >>
Spread table. Posted by Rogers at 3/31/2005 6:43:04 AM If your database is very large and very busy, multiple files can be used to
increase performance. Here is one example of how you might use multiple
files. Let's say you have a single table with 10 million rows that is heavily
queried. If the table is in a single file, such as a single database...more >>
Query Analyzer outputs, copy & paste Posted by Alex Müller at 3/31/2005 4:05:02 AM I did not yet find out how to change options so that I can copy & paste query
analyzers output into Excel or Outlook.
In Excel, I need the Columns Headers, they never appear.
In Outlook or word, I'd like a tabular form, not just plain text.
I have checked the Option "print column headers"...more >>
Help Posted by John at 3/30/2005 10:12:03 PM Can any one let me know about SQL Server dedicated server. Like I have
installed SQL Server on the dedicated machine and configuration are as
follows.
RAM : 8x 512KB
Hard disk : 2x 36GB Hot Swap
CPU : 3.06GHz
I need to ask one question like what best practise I have to adopt f...more >>
what does the SQL Server Client Tools (Client Connectivity Only) install option do? Posted by I was under the impression that the Client Connectivity install was required
for every machine on a LAN network that wanted to connect via OLEDB to an
sql server database. However, I recently created an adp project in MS
Access that seemed to connect without any problems, even though the Client
...more >>
Text file in text column Posted by Rogers at 3/30/2005 1:55:02 PM Can any one let me know like I wanna save the text file into text column and
see the data through select statement....more >>
Point in time recovery. Posted by Rogers at 3/29/2005 12:49:01 PM Can we do point in time recovery if I have a full backup... I don't have a
log backup....more >>
Data File and Log File Posted by Rogers at 3/29/2005 5:59:05 AM In our current scanario log and data file on the same drive, I want to move
the log file into another drive for optimization and database is in use. how
can I
Current Scanario :-
MyDB1_DATA 1 C:\MSSQL\data\MyDB1.mdf
MyDB1_TLOG 2 C:\MSSQL\data\MyDB1.ldf
Desiring Scanario
MyDB...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |