|
|
|
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 variables in constraints, scripting partition sliding Posted by at 9/14/2007 8:17:12 PM Hi,
I'm trying to create a bunch of scripts that will automatically roll
the partitions of one of my database tables. The partition scheme can
be arbitrary, but for my purposes i'm testing with a scheme that
breaks on "days", has 5 partitions, and every day would cycle out the
oldest, and br...more >>
Reducing many-to-many to one-to-one Posted by nick NO[at]SPAM nova5.net at 9/14/2007 2:43:33 PM Hi,
I have the following three tables below containing Resources,
Categories and a link table so each Resource can belong to one or more
Categories. I would like to create a view (ResourceID, ResourceName,
CategoryID, CategoryName) that includes one row for each Resource with
just one of the...more >>
Select Records and Insert into Text File? Posted by junkmail115 NO[at]SPAM gmail.com at 9/14/2007 10:12:49 AM Greetings,
A novice needs some advice:
I am able to bulk insert data from a text file into a table. Is it
possible to run a query and insert the results into a text file on the
local or network hard drive?
Thanks For Reading,
Aaron
...more >>
Search for specific length string in column Posted by mike NO[at]SPAM mcarlson.net at 9/14/2007 7:19:25 AM SQL 2000.
I need a query that will search a field in the table that is 14
characters long and begins with a number.
I have a client that was allowing people to store credit card numbers,
plain text, in an application. I need to rip through the table and
replace every instance of credit card...more >>
HTTP POST in SQL Server 2005 Posted by Nick Chan at 9/14/2007 1:48:12 AM hello, i have this summarized stored proc. Problem is, when using
'Send', my aspx page reads (asp.net)Request.Form as empty
However, when I use a simple html file to post, it works. Does anyone
know what's wrong?
EXEC @iHr = sp_oaCreate 'Msxml2.ServerXMLHTTP.3.0',@iObject OUTPUT
declare @...more >>
Partition Optimization Posted by traceable1 at 9/13/2007 6:56:59 PM
I am trying to update my optimization jobs so they will not optimize
the older partitions (for performance and snapshot space reasons).
ALTER INDEX {indname} ON {tabname} REORGANIZE PARTITION = ?
I can get the partition, but my question is, how do I determine if the
index is in a partition...more >>
Track which condition was true in a stored procedure Posted by Nate at 9/13/2007 4:36:03 PM I have the following stored procedure:
ALTER PROCEDURE [dbo].[GetRepeatIssues]
@thirty datetime
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Repeat varchar(50);
SELECT
e.first_name,e.last_name,db1.number,db1.date,db2.number,db2.date from
dashboard db1, dashboard db2, employees e where
(db1.dat...more >>
Storing pictures in database Posted by Zeljko Bilandzija at 9/13/2007 2:16:57 PM Hy, could someone help me in this:
In design mode, i want to put pictures in database. I made column named
pics, and its type as image. How can I put pictures or some address of these
pictures in that column, or i maybe need to put pictures in Add_Data folder
and make reference from there, ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Procedures Posted by Michael Kintner at 9/13/2007 1:43:37 PM Does any body have any VB (inside of Access) examples of creating SQL
produces inside a access form via vb and then executing those procedures and
returning the results to the screen?
Thank you in advance,
Mike
...more >>
indexes Posted by DaveP at 9/13/2007 12:46:54 PM where can i find a example on how to
build a script to reindex all my tables
Tks
DaveP
...more >>
Replication issues after a Database Restore - Unable to drop or create Transactional Replication Posted by Query Builder at 9/13/2007 10:01:29 AM Hi,
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.
When...more >>
strange error: ran out of internal resources Posted by Emin at 9/12/2007 7:42:12 PM Dear Experts,
While running a query with a lot of joins, I got the following error
message:
-------------------------------------------------------------------
The query processor ran out of internal resources and could not
produce a query plan. This is a rare event and only expected for
e...more >>
import database to another server - howto Posted by info at 9/12/2007 3:30:19 PM How import database mysql to mysql server 2005?
--
magix
...more >>
Deadlock in SQL Server 2005 sp2 running queries using temp tables or table variables Posted by Sputnik at 9/12/2007 8:56:59 AM We are running a query in SQL Server 2005 that makes use of temporary
tables and table variables. Occassionally a call to this query locks
up and subsequent calls timeout. The only way to get out of this is to
restart SQL Server which is a real pain.
This is an extract from the error log with ...more >>
Trying to create a linked server from an SQL Server to another SQL Server on another machine. Posted by gdev at 9/12/2007 3:59:22 AM I'm Trying to create a linked server from an SQL Server to another SQL
Server on another machine.
Can anyone suggest some good reference material or tutorials?? So far
I'm only finding examples for a linked server to an ACCESS database.
Thanks in Advance!
...more >>
simple OUTER JOIN (I thought) Posted by tescodiscolondon NO[at]SPAM googlemail.com at 9/11/2007 2:38:36 PM Two tables:
Fruit
fruitID, fruitName
Basket
buyerID, fruitID
(ie. we can see which buyer has what fruit in their basket)
I simply want to display all available fruit and whether or not it's
in a specific persons' basket.
SELECT Fruit.fruitID, Fruit.fruitName, IsNull(buyerID, 0)
FR...more >>
How would you... (binary info in a table) Posted by James Fraser at 9/11/2007 12:11:40 PM
I have run into a challenge that I'm not sure how to best solve. I'd
appreciate any opinions or input.
I am working with a third party database. They are storing some data
that I need to use in a binary field. I've got the code to parse the
binary and reconstruct what I need. Unfortunately, ...more >>
Query Help using SQL Server Posted by amj1020 at 9/11/2007 9:05:50 AM Need help with a query.
I need to get a date from table1 where the symbol is equal to OQY7 but
the symbol in table table2 is OQY07.
How do I get it to look for the first three characters plus the fifth
character by skipping the fourth character?
...more >>
Can't log in as sa Posted by at 9/11/2007 2:42:39 AM SQL Server 2005
All of a sudden we cannot log in using sa. The "enforce expiration"
option is not set.
How could this have happened outside of a user deliberately changing
the password? Can sa get
locked out for other reasons?
Bill E.
Hollywood, FL
...more >>
CREATE TABLE syntax error... Posted by bodyboarder20 NO[at]SPAM gmail.com at 9/10/2007 4:48:04 PM CREATE TABLE Agents
(ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,
Name VARCHAR(255),
Supervisor INTEGER,
MasterCalendarVisible BOOLEAN default false)
I'm using this against an Access DB using JET driver... I keep getting
a syntax error which goes away when I remove the ...more >>
Identity Column in INFORMATION_SCHEMA or the sys tables Posted by Wing9897 NO[at]SPAM hotmail.com at 9/10/2007 7:13:57 AM Hello,
Where can one find the identity column for a table in the
INFORMATION_SCHEMA or the sys tables? Or is there a function that can
return the name or id of the identity column for a particular table?
Thanks.
...more >>
Compare based on table values. Posted by Rex at 9/9/2007 7:24:38 PM Hi
Below is a table with sample data to explain what I want to achieve.
trackID member marker
allele1
------- ------ --------------------------------------------------
-----------------------------------------------------
4734 4577 01-D8S1179 13...more >>
Multiple records in one row Posted by Ray at 9/9/2007 2:31:17 PM Hello,
I have a table that contains multiple prices for multiple
location (yes I know is should have been done with an Xref table or
something, but I didn't create it and it's too late to do right now).
The records are similar to this...
priceID, productID (non-unique), productName, locati...more >>
Space Required to store a file in database Posted by apondu at 9/9/2007 11:50:21 AM hi,
I had a query on sql database, we know we usually store files of
different type in sql database and its helpful for searching and
retrieving the documents from the database, but one query i had was
related to the amount of space required to store the files in the
database. For Eg....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |