Viewing 15 posts - 46 through 60 (of 111 total)
siamak.s16 (1/14/2011)
dant12 (1/14/2011)
you should follow up the code to get context on whats actually being done and why. asking around is your best bet
Working on that.
In the meantime, I guess...
January 14, 2011 at 11:25 am
you should follow up the code to get context on whats actually being done and why. asking around is your best bet
January 14, 2011 at 10:26 am
TheSQLGuru (1/14/2011)
dant12 (1/14/2011)
if on SQL 2008 issueALTER TABLE table SET (LOCK_ESCALATION = DISABLE)
to disable lock escalation on that table, after that sql server will respect locking hints
Incorrect. Per BOL:
DISABLE
Prevents...
January 14, 2011 at 10:14 am
i feel your pain, i also once worked on a place that had stuff like this.
apart from changing how the system works to get away from that loop, the best...
January 14, 2011 at 10:01 am
as i understood the question, he was trying to figure out how DEF DEF ended up in the results.
Steve explains it well, that what he is really doing here is...
January 14, 2011 at 9:51 am
search around, there are a couple of ready solutions around
imo, Jeff Moden offers the best split function for strings with less than 4000 chars and Adam Machanic CLR split functions...
January 14, 2011 at 9:42 am
if on SQL 2008 issue
ALTER TABLE table SET (LOCK_ESCALATION = DISABLE)
to disable lock escalation on that table, after that sql server will respect locking hints
January 14, 2011 at 9:39 am
A.Col1 = B.Col1 matches INSERT INTO #AAA (Col1, Col2) VALUES ('DEF', 'DEF') and INSERT INTO #BBB (Col1) VALUES ('DEF')
no?
January 14, 2011 at 9:37 am
for perfect matches HASHBYTES can be used instead of checksum
SELECT HASHBYTES('SHA1','123')
SELECT HASHBYTES('SHA1','321')
December 2, 2010 at 10:46 am
ALZDBA (12/2/2010)
So...
December 2, 2010 at 9:19 am
ALZDBA (12/2/2010)
Seems to me pulling this kind of stuff into your CLR space could easily blow up...
December 2, 2010 at 5:23 am
ill post on what i been testing
create the 2 tables
IF OBJECT_ID('TEMP_1') IS NOT NULL
DROP TABLE TEMP_1
IF OBJECT_ID('TEMP_2') IS NOT NULL
DROP TABLE TEMP_2
GO
--CREATE TABLES
DECLARE @a VARCHAR(1000),@B INT
December 1, 2010 at 1:30 pm
have you tried a Parallel.ForEach or some sort of parallel processing?
with your server specs it might reduce the execution time.
i'll post some code soon if you want to try
December 1, 2010 at 12:29 pm
are you able to use a CLR?
i believe this sort of processing is best done within the .net framework
December 1, 2010 at 4:59 am
ALTER TABLE snapshots.trace_data ADD UniqueCol AS (CAST(SNAPSHOT_ID AS VARCHAR) + '-' + CAST(EVENTSEQUENCE AS VARCHAR)) PERSISTED NOT NULL
adding the column like this made it work.
since its a computed column...
October 19, 2010 at 11:23 am
Viewing 15 posts - 46 through 60 (of 111 total)