|
|
|
January 2003 March 2003 April 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 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 List of bad practices Posted by anonymous NO[at]SPAM discussions.microsoft.com at 9/18/2004 10:54:39 PM I have a list of bad practices in SQL Server below. If I
am missing something can you please share it?
1) Do not use cursors. Cursor "type" opersations should
be done in a middle tier.
2) Do not use temp-tables. Use derived-table or view
3) Too much normalization is not good.
4) T...more >>
How can I get a non consecutive numbers in collum. Posted by Enric Guinovart at 9/18/2004 9:24:31 PM Hello; I have a table with a column with consecutive numeratios (for example
an invoice number) and I need to get the unused values in this collum. How
can I write a select sentence in order to get the unused valued. For example
I have the following values: 1, 3, 5, 7 etc. etc. then the select mu...more >>
Help with an SQL Statement Posted by Reapes at 9/18/2004 9:07:22 PM Hi Group,
I have two tables in SQL Server.
Table one is called Category with fields :
CategoryID and CategoryName.
Table two is called SubCategory with fields:
SubCategoryID
CategoryID
SubCategoryName
In Table one I have say 2 categories, Birthday and Easter.
In Table two I have...more >>
Query performance Posted by Ramnadh at 9/18/2004 8:33:01 PM Hi
There are two tables TableA and TableB , where TableA consists of 100,000
rows and TableB consits of 60,000 rows.
In the TableA Id is the Primary Key (Clustered Index) and in the TableB
MessageId is the Foreign Key for TableA (Id), which is a non-Clustered Index.
When i Write a quer...more >>
Display only one value where there are more than one values for the first table Posted by GD at 9/18/2004 6:30:49 PM Hi,
Here is the query:
-------------------------------------------
select employees.LastName,orders.OrderID
from employees, orders
where employees.employeeID = orders.employeeID
----------------------------------------------------
It displays:
LastName OrderID
-----------------
Buchanan ...more >>
Batchupdate fails - no error Posted by Len at 9/18/2004 5:20:44 PM VB6, sp6, sql2000
3 tier app, disconnected recordsets.
When the client calls the DLL to update,
the recordset contains newly added data and changes.
Upon breakout I can print the new/added data in immediate
mode. Batchupdate reports no error.
Public Sub UpdateRS(rs As ADODB.Recordset)
...more >>
Secutiry of db files Posted by Amin Sobati at 9/18/2004 2:46:47 PM Hi,
As you know, books recommend to admins to remove login for
computer\administrators to prevent all administrators from accessing the sql
server, unless we create a login for particular one.
But all administrators are able to stop sql server service and copy
mdf,ldf,ndf files to other compute...more >>
Need basic CPP example to update a row using ATL OLEDB Consumer Posted by Don Miller at 9/18/2004 1:09:44 PM I am trying to write a simple .NET CPP program using the ATL OLEDB Consumer
that opens a table in a database, retrieves each row from the table and,
depending on the value in one column, updates the value in a second column.
I am currently reading data from the table just fine, but when I try to
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Trying to implent (Joe Celko's) Nested Sets, but need more data columns Posted by Jonah Olsson at 9/18/2004 12:49:58 PM Hi guys,
I just ordered the 'SQL for Smarties' by Joe Celko, and I think I definitely
need it :-)
I'm having a Group By problem with his Nested Sets. I understand the concept
and think it's a great idea, but when converting an old adjacency model into
a nested sets model I just added the...more >>
Need to move tempdb Posted by DBA at 9/18/2004 10:59:01 AM I need to move the tempdb log for space. Is there any best prcatices on this...more >>
use a quote for integer data type in SQL statement? Posted by Matt at 9/18/2004 10:32:22 AM I posted this question before but no replies.
If the data type is int, we can use quote or without quote to represent the
value
For example, the following will work, so we can use either one??
SELECT * FROM STUDENT WHERE ID='1001'
SELECT * FROM STUDENT WHERE ID=1001
However, if the dat...more >>
Slow SPROC Posted by anonymous NO[at]SPAM discussions.microsoft.com at 9/18/2004 7:13:36 AM I have a new sproc i just create and it is running real
slow. How would I go about troubleshooting it?...more >>
Stored procedure that runs query string Posted by mistercrabs NO[at]SPAM mail.ru at 9/18/2004 6:21:27 AM I wonder, is there any stored procedure in SQL Server 2000 that could
be used to run a query passed as a string parameter?
Thanks...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |