Viewing 15 posts - 57,766 through 57,780 (of 59,066 total)
If you wish to delve into semantics, I suppose you are correct. Still, you didn't meet the spirit of the original posting nor have any of the 23 posts you've...
September 3, 2006 at 2:14 pm
In order to use non-local UNC's, the server services must start with a windows login that has access to the UNC's desired. Our DBA's setup a special "SQLDBA" user (with...
September 3, 2006 at 12:22 pm
Sreejith,
Good code but if you run it more than once, it inserts additional new "Expired" records for the same ticket(s) that already have "Expired" records... you forgot to check to...
September 3, 2006 at 12:14 pm
An hour for 30k records? Obviously, that's not good... I'm thinking that the ORDER BY is what is really slowing things down but I could be wrong... the UNIQUE IGNORE DUPLICATE...
September 3, 2006 at 11:44 am
That's one of the things I admire about you, Remi... absolute integrity and honesty...
Here's a couple of links I was involved with that explain it all...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=2
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1073&lngWId=5
September 3, 2006 at 11:37 am
Absolutely correct, Remi... you and I both know that "open text" columns that contain multiple pieces of data (city,state... full name, etc) are the absolute worst and will usually require...
September 3, 2006 at 10:02 am
It means the deadlock occurred on an Index level rather than a table or a page...
September 2, 2006 at 11:04 pm
You don't need dynamic SQL for this...
drop table #test
CREATE TABLE #Test( FieldOne varchar(10),
FieldTwo integer)
DECLARE @Parameter1 integer
SET @Parameter1 = 1
INSERT INTO #Test
SELECT 'Test...
September 2, 2006 at 10:50 pm
There's several ways to do this... here's one if you have SA privs... there are other methods if this one doesn't suit ya... let us know...
DECLARE @Cmd VARCHAR(8000)
SET @Cmd =...
September 2, 2006 at 10:40 pm
Naga's update is good and nasty fast... it just needs a filter...
update Customer
set address = LEFT (address, LEN(address) - CHARINDEX(',', REVERSE(address)))
WHERE LEN(Address) - LEN(REPLACE(Address,',','')) = 2
September 2, 2006 at 10:31 pm
Don't forget that ISNUMERIC sometimes allows an "e" or "d" and will also allow decimal points and dollar signs and etc, etc....
The method Ken uses is nasty fast and is...
September 2, 2006 at 10:17 pm
First of all, you shouldn't be inserting "Owner" into the Audits table because that's a form of denormalization you don't need here... bit, if you insist, here's a self supporting...
September 2, 2006 at 10:06 pm
Good tool... bad answer ... you still haven't answered the "generic" question. David got it, though...
(and it appears that you are not paying for this form of advertising which might...
September 2, 2006 at 9:33 pm
SELECT i.*
FROM IndSales i
LEFT OUTER JOIN mstBranch b
ON i.BankCode = b.BankCode
AND i.BranchCode = b.BranchCode
WHERE b.BankCode IS NULL
September 2, 2006 at 9:28 pm
Viewing 15 posts - 57,766 through 57,780 (of 59,066 total)