Viewing 15 posts - 46 through 60 (of 177 total)
[p]Scott was exactly right. The OUTPUT clause of the UPDATE allows us to get data back from the inserted and deleted tables (the same as we reference in DML triggers)....
October 12, 2009 at 6:41 am
I recently (within the last 2 years) created a system to monitor our SQL instances from a central instance. Without going into details about the whole process, I had a...
October 12, 2009 at 4:33 am
It was apparently a known bug in the Oracle driver - both BIDS and SSMS are 32-bit apps and need the 32-bit client, but the 32-bit client can't handle special...
December 10, 2008 at 9:35 pm
INDEXDEFRAG should create less log growth than REINDEX, however, if the growth is still excessive, you may have to come up with a different Log-Shipping strategy.
(1) You can switch to...
August 28, 2008 at 12:12 am
Transactional Replication doesnt allow for transformations, so it wont work as a single solution.
Have you thought about a third-party product to do the data movement, such as Informatica /...
August 19, 2008 at 3:06 pm
Is IX_ptLabResults_UniqueRecord the clustered index?
August 19, 2008 at 8:29 am
:blink: that's a very wide table. What indexes are defined on the table?
And, why the IF (SELECT count(*) FROM sys.tables WHERE name = 'ptLabResults') > 0? It's been quite...
August 18, 2008 at 9:28 pm
I thought the explanation was really lacking something ... like explaining
The REPLICATE function only returns 8000 characters (defaults to VARCHAR(8000)) if the character value to be replicated isn't explicitly CAST...
August 10, 2008 at 8:58 pm
Michael Valentine Jones (8/5/2008)
400 TB would make it one of the world’s largest databases...
August 6, 2008 at 7:18 am
NP. Sorry I can't give you a defintive answer on performance gains.
I don't tend to revisit older systems to reformat disks - business units dont have much appetite for...
July 24, 2008 at 12:52 pm
That depends on several things - the size of the database vs the amount of RAM, I/O profile of the database, number of updates in the database, etc. I have...
July 24, 2008 at 12:25 pm
Actually, it's DangerMouse ... http://www.chf.co.uk/shows/past/dangermouse/. :smooooth:
And, I just realised - 'Reply' worked this time ... go figure :crazy:
July 24, 2008 at 8:54 am
GilaMonster (7/24/2008)
Sandy (7/23/2008)
Simon,but how you identify this?....;)
To get out of a while loop, there must be a statement within the loop that sets the variable involved in the while condition...
July 24, 2008 at 8:50 am
david.sims (7/23/2008)
...
...while @TotalBilled is not null
begin
update projectcustomtabfields
set custJTDBilled =@TotalBilled
where wbs1 = CAST(@projnum AS char(6)) and wbs2=''
end
...
This loop is never going to quit - the value for @TotalBilled never changes...
July 23, 2008 at 10:22 pm
Viewing 15 posts - 46 through 60 (of 177 total)