Viewing 15 posts - 4,351 through 4,365 (of 8,731 total)
Note that UNION will remove any duplicates. To avoid this problem and receive a possible performance improvement, use UNION ALL.
August 20, 2015 at 11:32 am
Why would you have a 100GB database in a developer workstation?
I agree that improving the query would help. As you say that you can't at this moment, you should start...
August 20, 2015 at 11:23 am
Databases don't have backward compatibility. Once you restore or attach a database to a version of SQL Server, you can't restore it or attach it on a previous version.
August 20, 2015 at 11:18 am
Are you seriously asking how to change the query to return 1 day instead of 14? Do you even know how does your query work?
Also, I'm not sure what you...
August 20, 2015 at 11:14 am
Eric M Russell (8/20/2015)
Hopefully there hasn't been much action on the server, since the database has been offline.
Well, considering that it has been 6 years now since the "accidental...
August 20, 2015 at 10:21 am
dineshhp (8/20/2015)
Thanks Luis !!! You have solve my problem.....
That's great! Do you understand how or why does it work?
August 20, 2015 at 10:10 am
squvi.87 (8/20/2015)
PFA execution plan with new spliter
Where?
August 20, 2015 at 10:03 am
I submitted the article, I'm not sure if it is what you had in mind or if I should have taken a different approach.
August 20, 2015 at 9:32 am
Have you replaced the splitter?
Can you share the execution plan and performance results with the new splitter?
August 20, 2015 at 7:39 am
Ed Wagner (8/19/2015)
4. The subquery in the JOIN to dbo.BenefitPlanDeterminant. Needs DDL and data to test this. Given the subject, I know that can't happen.
If you refer to this...
August 19, 2015 at 1:14 pm
Revenant (8/19/2015)
ZZartin (8/19/2015)
whereisSQL? (8/19/2015)
BL0B_EATER (8/19/2015)
Ed Wagner (8/19/2015)
djj (8/19/2015)
whereisSQL? (8/19/2015)
Luis Cazares (8/19/2015)
BL0B_EATER (8/19/2015)
Ed Wagner (8/19/2015)
BL0B_EATER (8/19/2015)
crookj (8/19/2015)
Ed Wagner (8/19/2015)
Ed Wagner (8/19/2015)
djj (8/19/2015)
Eirikur Eiriksson (8/18/2015)
DonlSimpson (8/18/2015)
BearingGrease
Seal
Approval
Process
Procedure
medical
Costs
cash
Johnny
Country
Living
Well
Water
Conservation
Fire
Alarm
Clock
August 19, 2015 at 11:28 am
Or this:
declare @myDate datetime;
set @myDate = cast(dateadd(day, -1, getdate()) as date);
SELECT *
FROM [ThomasSci].[dbo].[tsi_gdserial_vw]
where date_shipped >= @myDate
AND date_shipped < DATEADD( dd, 1, @myDate)
order by
order_no desc,
...
August 19, 2015 at 11:23 am
Or you could do it directly in SSIS
August 19, 2015 at 10:51 am
Use the REPLACE() function.
This response is intentionally vague to match the vague requirements posted.
August 19, 2015 at 9:41 am
Sean Lange (8/19/2015)
August 19, 2015 at 8:55 am
Viewing 15 posts - 4,351 through 4,365 (of 8,731 total)