FullText outer joins
Mon, 15 Mar 2010 20:04:14 -0700
I have a procedure I am looking at that can take about 1 - 3 minutes to run
depending on how much data is passed back.
This is part of the query that is taking most of the time. Sometimes it
will take 10 seconds if you put something that passes back about 10 rows.
But if it passes back 2400 rows, it takes ...
|
Indexing
Mon, 15 Mar 2010 15:27:24 -0700
I have a table that has only 275 records that has a composite primary key
(not my table).
CREATE TABLE MyTable
(
FirstID int,
SecondID int,
CONSTRAINT [MyTable] PRIMARY KEY CLUSTERED
(
[FirstID] ASC,
[SecondID] ASC
)
)
In one of our large queries that is taking some time, this table is jo ...
|
Send DB Mail Failures
Mon, 15 Mar 2010 14:02:01 -0700
I am using the following code to send emails using the following code.
Only about 50% are being sent.
I have checked the sysmail_unsentitems - it is clear.
I have checked the sysmail_faileditems - it has about 50 failures in it. I
don't know why. Any input?
Thanks!
Declare @email_subject nvarchar(1000)
D ...
|
Trigger Modify Record Date
Mon, 15 Mar 2010 12:53:01 -0700
I want to create a simple trigger to put in a timestamp when the record was
last modified.
This works when I am updating a record in SQL Server, but if I am using an
external source, such as MS Access, the trigger does not update the record
with the modify date.
The trigger should run, irregardless of where ...
|
How to get the column name a UDF is executing in as a default func
Mon, 15 Mar 2010 11:37:01 -0700
I have two tables and an UDF
CREATE TABLE [dbo].[t1](
[t1_id] [int] ,
[t1_col_name] [nvarchar](50)
) ON [PRIMARY]
CREATE TABLE [dbo].[t2](
[t2_id] [int] NOT NULL,
[t2_col_name] [nvarchar](50) NOT NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[t2] ADD CONSTRAINT [DF_t2_t2_col_name] DEFAULT
([dbo].[calc ...
|
How to use WHERE and HAVING together?
Mon, 15 Mar 2010 17:44:58 GMT
Hi,
Im having difficulty in using the HAVING statement with more than 1 criteria
and would like to know how I might find the following?
I have a table (fullres2) with horse racing details over numerous columns but
need to find out..
How many of the horses that have the greatest % price interest go onto win.
...
|
Could not find stored procedure - fails on first attempt only
Mon, 15 Mar 2010 17:40:02 +0200
Hi all,
I have a sp that fails to execute the first attempt after it is created.
After the first attempt all other attempts succeed. I'm using sql server
2005. I do not know if it is related or not, but the sp that fails the
first time is dropping and creating other stored procedurs.
The er ...
|
|
|
Trigger question
Mon, 15 Mar 2010 10:09:50 -0500
CREATE TABLE tblA (
Symbol varchar(50) NOT NULL,
APIFormat varchar(50) NULL,
DataFormat varchar(50) NULL
)
I would like to do the following:
If a new row is added or APIFormat is edited, and DataFormat is NULL, I
would like to set DataFormat like this:
If ...
|
Testing database
Mon, 15 Mar 2010 15:05:22 +1100
Assuming a company that releases software to the public, what methods do you
use to manage testing/development database. This can sound pretty simple but
when you have a team of developers it can get pretty complicated. Do you
have a single database that everyone develops in or seperate databases on
each mac ...
|
alter function
Sun, 14 Mar 2010 18:11:01 -0700
Hi, using SQL2005. I want to replace a function and can't because the
function is being referenced by an object. I have tried to drop it first and
then create the function. This has the same error result.
Is there a way to ignore any referenced object and drop a function (and then
re-create it). Alternati ...
|
