Viewing 15 posts - 38,761 through 38,775 (of 49,571 total)
Put square brackets around the linked server name.
June 2, 2009 at 5:35 am
Ok, you've neither given me all the table definitions nor any sample data so I can't test this, but give this a try. It should give you the idea if...
June 2, 2009 at 5:25 am
Can you try reinstalling the java drivers?
June 2, 2009 at 4:03 am
TheSQLGuru (6/1/2009)
use adventureworks
go
drop proc test
go
create proc test (@productid int = null, @quantity int = null)
as
set nocount on
select *
from [Production].[TransactionHistory]
where (@productid is null or @productid = ProductID) --indexed
and (@quantity is...
June 2, 2009 at 4:01 am
vikas bindra (6/2/2009)
Do I actually need NIX_WITHINCLUDE_1 and NIX_WITHOUTINCLUDE indexes?
I can't see any reason why you would. It is possible that SQL would use the smaller ones occationally, but the...
June 2, 2009 at 3:57 am
vidhyasudha (6/2/2009)
First I create a temp table to hold the data that satisfy the where conditionINSERT INTO #tmpP
select x.p_id, x.col1,x.col2,x.col3 from x where x.colm4 'N'
What is table x?
set @pidentity...
June 2, 2009 at 3:55 am
Yup. The setting is 'max degree of parallelism'. If it's 0, SQL will use as many of the CPUs as it feels necessary for a query. If you set it...
June 2, 2009 at 3:48 am
Do you mean SQL Server 2005? There is no version 2003.
June 2, 2009 at 3:47 am
rafidheenm (6/2/2009)
This can be write like this and avoid CASE statements from WHERE clause..
Yes, but it doesn't change the execution characteristics. Just like the case statement version, that will typically...
June 2, 2009 at 3:39 am
sql_lock (6/2/2009)
IF(UPDATE(Authorised))
That trigger is not going to do anything for the update you posted. It will only execute if the Authorised column is updated, that's what the IF UPDATED line...
June 2, 2009 at 3:38 am
In 2008, SQL can 'repair' damaged pages from the mirror automatically. Enterprise edition only.
Books Online:
A database mirroring partner running on SQL Server 2008 Enterprise or later versions automatically tries to...
June 2, 2009 at 2:10 am
It is about permission. Only the connection that created a temp table can drop it.
See if you can run sp_spaceused on that table and see how much space it's taking...
June 2, 2009 at 1:49 am
GURSETHI (6/1/2009)
slow performance?
A: Sleeping means waiting for a event to...
June 2, 2009 at 1:34 am
Is there code in the trigger to check that a row has actually changed?
June 1, 2009 at 2:39 pm
TRACEY (6/1/2009)
Is this total or per DRIVE DISKS...to select.
Individually for each drive that has SQL data or log.
Taking the total's not very useful as more idle drives can skew the...
June 1, 2009 at 2:30 pm
Viewing 15 posts - 38,761 through 38,775 (of 49,571 total)