|
|
|
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 31 Common issue - query response time Posted by jack at 3/4/2007 10:05:52 PM I am maintaining the application and database which is been developed
2 years ago. Initially the database response time was perfect. but as
an when the size of data increased the response time also increased.
The database tables are indexed in such a way which leaves the scope
of creating furt...more >>
Mathematical operations between two sets Posted by mikejacobz NO[at]SPAM gmail.com at 3/4/2007 9:32:02 PM Hi, I have two tables which contain information which I need to use to
populate a new table
The first table (TableA) looks like the following
ID | Age1 | Age2 | Age3
=================
1 2 3 9
2 Null 4 2
3 6 Null 4
4 7 1 ...more >>
Subqueries Posted by Nathan Nevin at 3/4/2007 9:26:46 PM What are your thoughts, questions and/or concerns about complex and
subqueries??
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Hierarchy loop lookup syntax Posted by Allan at 3/4/2007 8:16:19 PM I have the following Table
USE [MyDatabase]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer.Location](
[LocationID] [int] NOT NULL,
[CustomerID] [smallint] NOT NULL,
[LocationName] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_...more >>
Select query question Posted by John at 3/4/2007 6:01:01 PM Hi
I am using below query to retrieve records from backend sql server 2005 db;
SELECT ID, Company ....
FROM tblClients
WHERE (Status = @status)
Problem is that sometimes I need all records regardless of what is status.
How can I achieve that? Can I add something like OR ...more >>
SqlParameter() length of VarChar field? Important? Optional? Posted by \ at 3/4/2007 5:39:53 PM I have an MS SQL 2000 table with a VarChar field that's 20 characters long.
So what's the difference between these lines of asp.net/vb.net/ado.net code?
What are some of the good/bad things that would happen if I used them?
> dbCommand.Parameters.Add(New SqlParameter("@Group", SqlDbType.VarCh...more >>
SQL Server 2000 Linked Server Problems after Server was attacked Posted by MatthewNewsom NO[at]SPAM yahoo.com at 3/4/2007 2:12:53 PM I am having problems on a Win 2003 sp1 server running MSSQL 2000 sp4.
I can not create a proper linked server to any other SQL Server
machine. I realized I had a problem after our network admin stated
the server was attacked by hackers....so who knows what could have
been screwed up. I have re...more >>
Row Level Security Posted by hufaunder NO[at]SPAM yahoo.com at 3/4/2007 2:12:01 PM I am looking into row level security and found a good article:
Title: Implementing Row- and Cell-Level Security in Classified
Databases Using SQL Server 2005
URL: http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx
Is this still a good approach to take for a secure database...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Transaction Log Size Posted by vbnetdev at 3/4/2007 10:26:08 AM My transaction log on SQL 2005 SP1 has gotten extremely huge. How can I go
about shrinking this. I tried teh option of "Shrink Database" but that did
not help much.
Thanks.
...more >>
column alias in where (looking for alternative) Posted by eladla at 3/4/2007 10:09:11 AM Hi all!
I have the following query:
SELECT DISTINCT ProductID,
(SELECT COUNT(CustomerID) FROM orders
WHERE(CustomerID IN(SELECT CustomerID FROM orders AS r
WHERE (ProductID = 1)))AND(ProductID = r2.ProductID)) as counter
FROM orders AS r2 WHERE (ProductID > 1)
and I want to add ...more >>
Making Word object visible from T-SQL Posted by urkec at 3/4/2007 8:07:08 AM I am experimenting with sp_oa* procedures. I was able to create
Word.Application COM object and destroy it, but when tried to make it visible
with this
EXEC @hr = sp_OASetProperty @Word, 'Visible', 1
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @Word
RETURN
END
it didn't work. Can ...more >>
need help in sql query Posted by kamales at 3/4/2007 7:20:07 AM Hello.my question is..How to retrieve binary data to mp3 format from sql server 2000 database?
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com...more >>
SQL 2005 not using index on large tables? Posted by Orwell at 3/4/2007 7:06:22 AM I have an odd issue -- I have a table ("CUSTOMERS") that has about
500,000 rows on it. I need to do a "SELECT" to retrieve rows from a
particular company, ordered by company and zip code. I have several
indexes, including an index for the primary key ("COMPANY" and
"CUSTOMER_NUMBER"), and an i...more >>
how to select records 1-25 or 26-50, etc Posted by Stimp at 3/4/2007 6:30:46 AM Hi all,
We run a website that outputs a dataset of listings held in a SQL Server
database.
Each page shows 25 listings from the dataset.
At the moment, we pull back the entire list into the dataset and from
there, output the first 25, or second 25 depending on which page the
user is l...more >>
Procedures working from Management Studio but not from Access 2003 Posted by acx NO[at]SPAM centrum.cz at 3/4/2007 5:56:54 AM Dear colleagues,
currently I face the following problem. My client application is
programmed in MS Access 2003 and my DB resides on MS SQL Server 2005.
In my DB, I have programmed a stored procedure which runs about 8
minutes. This sp is called from the client application via pass-
through qu...more >>
Data manipulation question? Posted by Lasse at 3/4/2007 12:00:00 AM This is the scenario;
I have a table with the columns Time, Open, High, Low, Close, Volume.
Every record represents one hour of data and thus the table would look
something like the following;
1/1/2000 18:00:00, 22.45, 23.75, 22.30, 23.30, 12345678
1/1/2000 19:00:00, 23.35, 23.85, 22.10,...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |