Viewing 15 posts - 11,026 through 11,040 (of 22,214 total)
It's like I said. An address table instead of fields in the person table. That way you can store a single address one time. Then an interim table, a table...
April 24, 2012 at 6:01 am
I am not certified, so take my advice with a HUGE grain of salt...
Considering the differences between 2008 & 2012 and the fact that MS has changed the certifications and...
April 24, 2012 at 4:56 am
It's basically OK. I'm not crazy about how you've set up the contacts relationship. I would have two different interim tables, one for relations between a person and an address...
April 24, 2012 at 4:54 am
The best way to track T-SQL commands that have been issued in the past is through an extended event session. They're easy to set up and there's a function to...
April 24, 2012 at 4:46 am
Assuming that's an accurate representation of the query, you don't have a WHERE clause. That means you're processing everything in the table. You're not going to be able to improve...
April 24, 2012 at 4:34 am
Now that you have a batched process, the right way to go, you need to worry about how the optimizer is handling it. Do you have an index on the...
April 24, 2012 at 4:32 am
Lynn Pettis (4/23/2012)
Grant Fritchey (4/23/2012)
Lynn Pettis (4/23/2012)
Grant Fritchey (4/23/2012)
And I'm out.Oh well, you can't say I didn't try.
Well, we could say it, but we would be lying... 😉
I had...
April 23, 2012 at 3:43 pm
Lynn Pettis (4/23/2012)
Grant Fritchey (4/23/2012)
And I'm out.Oh well, you can't say I didn't try.
Well, we could say it, but we would be lying... 😉
I had to show him one...
April 23, 2012 at 2:57 pm
And I'm out.
Oh well, you can't say I didn't try.
April 23, 2012 at 2:33 pm
riya_dave (4/23/2012)
I AM ALREADY PUTTING IT INSIDE CURSOR BUT ITS REPEATING AGAIN AND AGAIN
I've no doubt you know this, but I'll point it out, just in case, all caps like...
April 23, 2012 at 2:31 pm
Sounds like what you want is a cursor. Read up on those here.
But, please note, that's a very problematic way of dealing with data within SQL Server. Performance is notoriously...
April 23, 2012 at 2:14 pm
riya_dave (4/23/2012)
i need something like untill there is value the loop should go.
i cant give any condition
suppose files
item1
...
April 23, 2012 at 2:03 pm
Brandie Tarvin (4/23/2012)
Hijacking the thread for another book announcement.You can read the details on the top post of my Google+ stream here: Legend of the Beemen
Huge congratulations. Quite the...
April 23, 2012 at 12:10 pm
riya_dave (4/23/2012)
kindly help me
i want insert
insert into #temp3
select I1,account,id from account(p1)
union
select I1 from #temp2
i cant do this coz of union,what are other ways of i...
April 23, 2012 at 9:09 am
Viewing 15 posts - 11,026 through 11,040 (of 22,214 total)