Viewing 15 posts - 451 through 465 (of 476 total)
Are all those
convert(VARCHAR(10), SomeDate, 101)
functions preventing the query from being SARGable, and thus indexes not used?
Personally I'd save all the variations of those into suitable @DataVariables and use those within...
September 11, 2015 at 11:24 am
SQLTougherGuy (9/10/2015)
loads data into a table with all VARCHAR(MAX)
That may not sit very well with NCHAR(65533) ... I'm not sure, but it might be better to change your staging...
September 11, 2015 at 11:07 am
coolchaitu (9/11/2015)
I tried rebuilding the index with fillfactor=80 yesterday night. I checked the fragmentation and it is 98%. I will rebuild the index with fillfactor=70 tonight.
If GPSDateTime and/or DataReceviedDateTime are...
September 11, 2015 at 11:04 am
Sean Lange (9/11/2015)
You can click the "Active Threads" links
Thanks, that looks better.
Is there any means to
a) Click a link for the "first unread post" within the thread?
b) Any ICON that...
September 11, 2015 at 9:27 am
SQLTougherGuy (9/11/2015)
Any ideas?
Perhaps NCHAR(65533) is not actually the offending character?
At the least I would suggest doing
UPDATE TABLE
SET DS = REPLACE(DS,NCHAR(65533),'')
WHERE DS LIKE '%' + NCHAR(65533) + '%'
to reduce the number...
September 11, 2015 at 9:13 am
mohelsheikh (9/11/2015)
when i execute the procedure i have no issue (this mean the procedure syntax is correct and using OPENROWSET is not wrong), but when i call it from...
September 11, 2015 at 8:48 am
btio_3000 (9/10/2015)
No magic tricks?
Dunno if it is a magic trick but I find that the "WHERE MyDateColumn < @CutoffDate" doesn't perform well in a delete loop. The time to find...
September 11, 2015 at 8:41 am
"How many different ways can you specify an alias for a column in a SELECT clause?"
In this organisation? One. What's known as "Kristen's Way" 🙂
An annoyance I have...
September 11, 2015 at 8:25 am
mohelsheikh (9/10/2015)
Your trigger is not set based and will NOT work when there is more than 1 row being inserted.
I am inserting the new records one by one
so only one...
September 11, 2015 at 8:05 am
P.S. SQL Server's performance monitoring tools are also useful for our own in-house APPs. We do indeed discover improvements that we can make that we didn't even know needed making!!...
September 11, 2015 at 7:59 am
erichansen1836 (9/10/2015)
September 11, 2015 at 7:56 am
Not sure which index this relates so, but reading this thread I have seen mention of two. The original was
CREATE NONCLUSTERED INDEX [idx_tblJobbooking_C3_C7] ON [dbo].[tblJobBooking]
(
CustomerMobileNo ASC, CustomerContactMobileNo ASC
)
INCLUDE
(
JobID], PickUpTime,...
September 11, 2015 at 6:46 am
Not the answer to your question, but in case worth discussing / debating.
We have both IDENTITY and GUID in quite a lot of tables. The GUID is there so that...
September 11, 2015 at 6:30 am
How are you doing the UPDATE?
Over the years I have found the whole Oracle Linked Server thingie to be very fragile, and what seems to have worked for us is...
September 11, 2015 at 6:14 am
If you can create a Linked Server then you could do:
INSERT INTO dbo.MyTable
SELECT *
FROM RemoteServer.RemoteDatabse.dbo.RemoteTable
WHERE ...
if not then I would use BCP to produce a file containing the records. ...
September 11, 2015 at 5:56 am
Viewing 15 posts - 451 through 465 (of 476 total)