|
|
|
January 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 |
Filter by week: 1 2 3 4 5 Multi-column Index vs Single Column Indexes Posted by Sonny at 8/7/2007 6:10:03 PM Hi,
Would like to know the performance differenece between Multi-column
Index vs Single Column Indexes. Let's say I have a table with col1,
col2, col3 along with a primary key column and non-indexed columns.
In queries, I will use col1, col2, and col3 together and some times
just one or two ...more >>
SQL 2000 performance issues Posted by Fox1977 at 8/6/2007 10:17:50 PM hi there,
Just wondering if anyone can offer any advice on an a SQL performance
issue i have repeatedly come up against in work. I am a sys admin for
an internet company and we are having problems with SQL eating up too
much of the CPU on a brand new server. I am new to SQL so apologies
is ...more >>
Most common connection method to SQL 2005 Posted by Charlie at 8/5/2007 7:16:18 PM I am currently using ADO from an application to connect to SQL 2005. Is this
the preferred way, or is that the most common method? I was told I need to
use an API. Which API? Thanks.
Charlie
...more >>
What version of SQL Server to buy? Posted by Charlie at 8/3/2007 6:21:03 PM I am a single developer, and new to SQL Server. I have Windows XP Pro, and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.
...more >>
IF UPDATE(@column_name) Posted by ben NO[at]SPAM jammin.co.uk at 8/3/2007 9:44:41 AM I would like to know if it is possible to use a variable to use with
the IF UPDATE(column) statement. Only, the column should be a variable
[e.g. IF UPDATE(@column_name)] which should be substituted at run-time
with the real column name.
TIA
...more >>
Use of large field definitions for small values Posted by David Greenberg at 8/2/2007 12:00:00 AM Hi
This is a question of "what does it cost me".
Lets say I have an integer value which would fit into a smallint field
but the field is actually defined as int or even larger as bigint.
What would that "cost" me ? How would definitions larger than I need for
the values in the field affect ...more >>
Numeric value only for a character field Posted by David Greenberg at 8/2/2007 12:00:00 AM Hi
I have a character field (char ot varchar) that I want to force only to
contain numeric characters.
Can that be done by way of defining a constraint on the field ?
or by any other way in the field/table definition ?
What id the syntax ?
Anyone have examples ?
Thanks
David Greenberg
...more >>
To have SQL Server 2000 + 2005 working on a single windows 2003 server Posted by fhernandezve NO[at]SPAM gmail.com at 8/1/2007 8:28:43 PM hi all.
Can i have two instalation of SQL 2000 and SQL 2005 in a single server
WIN 2003 as programs seperate, without i have=B4nt conflict ?
If el anwser is Yes, What it is the order of instalation and what
prevention will do?
Thank you for you help.
Bye.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
help with sql select Posted by at 8/1/2007 1:38:10 PM As you can probably tell from my query I am not a guru, just trying to
"gitter done". This query is for Dynamics GP. It is a select with left
outer and a union. Can someone help debug my syntax? Please? I'll
create a view out of it and use it in a crystal report.
SELECT openheader.custnmbr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |