Viewing 15 posts - 2,851 through 2,865 (of 3,232 total)
Pros: Your server guys will not need to dedicate you a stand alone server.
Cons: Keep in mind that your Virtual Server will be sharing physical resources with other Virtual Servers. ...
May 23, 2006 at 10:08 am
DECLARE @Insert int,
@EndString int
SELECT @Insert = CHARINDEX('e',Anystring) FROM Test
SELECT @EndString = (LEN(Anystring) - @Insert) FROM Test
UPDATE Test
SET Anystring = SUBSTRING(Anystring,1,@Insert) + '1234' + SUBSTRING(Anystring,(@Insert + 1),@EndString)
FROM Test
SELECT Anystring
FROM Test
May 23, 2006 at 9:29 am
Your answer lies in the phrase 'result sets'. A result set is the dataset returned as the result of a DML statement. To get multiple result sets, you must run...
May 23, 2006 at 9:00 am
As far as performance goes, its hard to say what kind of gain, if any, you will get with this query without knowing more about your database/environment. But here is...
May 22, 2006 at 2:29 pm
I could be mistaken, but I think you need to reinstall SQL Server to change license modes.
May 22, 2006 at 12:45 pm
Yes, that is what I am asking. So, if I'm hearing you correctly, you run this query go SELECT your data into variables and then you call the INSERT stored...
May 18, 2006 at 4:11 pm
Odds are, it is not due to the memory consumption. Most of that memory, as R2ro said, will be used for buffer cache. This is where your recent data pages will...
May 18, 2006 at 3:52 pm
As things stand, your stored procedure is already setup to accept in all of the column values that you need for your INSERT statement. You've got 2 choices here:
1. Whereever...
May 18, 2006 at 2:56 pm
"I'm not at all familiar with coding looping structures within SQL Server 2000."
Consider yourself lucky!! Most people are TOO familiar with looping structures. Anyway, you say that you need to...
May 18, 2006 at 1:29 pm
Run this through QA, output to File. Open the file in QA and run. Or, output to text and cut/paste into new QA window and run.
set nocount on
SELECT 'CREATE TABLE...
May 18, 2006 at 9:50 am
I think I fell asleep at the wheel on this one. The solution in my previous post has flaws. Back to the drawing board.
May 17, 2006 at 3:16 pm
This appears to be more than just your normal self-join. In fact, I can not find a way to do this one without use of a temp table. Maybe some...
May 17, 2006 at 3:10 pm
It looks like you have 3 sessions with that specific creative ID. Am I mistaken?
May 17, 2006 at 2:00 pm
This syntax should work. I could not test it as you did not include your table DDL and sample data. It may need tweaked slightly, but the idea is sound.
UPDATE...
May 17, 2006 at 1:20 pm
Viewing 15 posts - 2,851 through 2,865 (of 3,232 total)