Viewing 15 posts - 1,831 through 1,845 (of 3,232 total)
Here's a decent read on scaling out your application:
March 28, 2008 at 1:34 pm
So you've already given it a shot with SUBSTRING? Why don't you post what you tried so we can have a look.
March 28, 2008 at 1:30 pm
I would say that CPU usage of 95% and connections timing out is not reasonable!! It sounds like you are sharing your development box with multiple development groups? ...
March 28, 2008 at 1:29 pm
Thanks for posting your final solution. It helps those who may come accross this thread months from now see what ended up working for you.
March 28, 2008 at 9:53 am
Thanks for following up with the end solution Diann! Also, now that you have the UNION, you no longer need to include the CASE statement for your Types. ...
March 28, 2008 at 9:51 am
Shamsudheen,
I think this was a case where we were not privy to the full scope of the problem domain that Diann was trying to solve. The solution that...
March 28, 2008 at 9:17 am
Check out the PIVOT statement in Books Online.
March 27, 2008 at 4:24 pm
The tables in question have around 100 columns and 900 or so rows. It looks like your query would require writing a line for every column and every row...
March 27, 2008 at 4:19 pm
From the looks of your code, you are trying to do this procedurally, maybe even with a cursor...correct?? This whole operation can be done with 2 set based queries....
March 27, 2008 at 3:08 pm
Wow, that was great Jeff...thanks. I'll have to admit, I've been just watching this thread waiting for a solid explanation of the benefits of any of the solutions provided....
March 27, 2008 at 8:37 am
I wouldn't quite call it casting. This may help:
DECLARE @Table TABLE (RowID int, RowValue varchar(10))
INSERT INTO @Table
SELECT 1, 'Mister' UNION ALL
SELECT 2, 'Senior'
SELECT REPLACE(RowValue,'Mister','Mr') FROM @Table
March 26, 2008 at 3:50 pm
It looks like a permissions issue. Make sure that the Peru8\SYSTEM account has permissions to do everything the package needs to do. When you ran the package outside...
March 26, 2008 at 3:47 pm
You can run SQLDiag.exe to give you detailed locking/blocking/process info.
March 26, 2008 at 3:44 pm
Ah, I did not see that your tables are not on the same server. Yes, you'll need linked servers and you'll need to watch performance.
March 26, 2008 at 12:57 pm
What?? In his example, the relationship persists because the RowID is maintained between the two. With the example shown, you can re-link the Names and Addresses by running...
March 26, 2008 at 10:17 am
Viewing 15 posts - 1,831 through 1,845 (of 3,232 total)