Luis Cazares

Forum Replies Created

Viewing 15 posts - 766 through 780 (of 8,731 total)

RE: Difference between dates displayed in days, hours, minutes and seconds

Lynn Pettis - Thursday, December 28, 2017 11:54 AM
Not sure what forum thread you are talking about, Luis.
Here's the thread.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 28, 2017 at 12:06 pm

#1973748
RE: Difference between dates displayed in days, hours, minutes and seconds

Didn't we gave some faster alternatives in the forums for this function?
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 28, 2017 at 10:37 am

#1973723
RE: Christmas 2017 - Part 4

Rune Bivrin - Thursday, December 28, 2017 12:30 AM
Very hard to know if 'Adult' refers to the Age or Genre for the...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 28, 2017 at 7:45 am

#1973701
RE: SHREDDING XML - Can it be done quickly?

I'm not sure what's the problem as I get those results immediately in my laptop. A different option that we use here is using OPENXML which requires sp_xml_preparedocument and sp_xml_removedocument.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 27, 2017 at 12:46 pm

#1973626
RE: The Slow Week

wreiman 78397 - Wednesday, December 27, 2017 9:40 AM
It feels like I'm on vacation...... but still in the office. Nothing to fix,...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 27, 2017 at 12:12 pm

#1973623
RE: Added a SELECT inside INNER JOIN. Very Slow Performance

You could try to change the DISTINCT with GROUP BY. That might force it to eliminate duplicates before creating the XMLs (although, it doesn't seem like you need the DISTINCT...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 27, 2017 at 9:14 am

#1973600
RE: suggestion on table order inside a join ?

drew.allen - Wednesday, December 27, 2017 7:55 AM
Luis Cazares - Wednesday, December 27, 2017 7:40 AM
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 27, 2017 at 8:11 am

#1973589
RE: suggestion on table order inside a join ?

vsamantha35 - Tuesday, December 26, 2017 9:15 PM
Hi All,
Does the order in which the tables are placed inside a join matter...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 27, 2017 at 7:40 am

#1973583
RE: ReSETting the value

drew.allen - Tuesday, December 26, 2017 2:05 PM
Luis Cazares - Tuesday, December 26, 2017 1:54 PM
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 26, 2017 at 2:26 pm

#1973528
RE: ReSETting the value

drew.allen - Friday, December 22, 2017 10:35 AM
Koen Verbeeck - Friday, December 22, 2017 12:32 AM
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 26, 2017 at 1:54 pm

#1973520
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, December 19, 2017 12:33 PM
Luis Cazares - Tuesday, December 19, 2017 12:29 PM
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 19, 2017 at 12:39 pm

#1972772
RE: Are the posted questions getting worse?

Chris Harshman - Tuesday, December 19, 2017 11:21 AM
so... how about that weather we've been having lately?

As variable as the critics for the new Star War...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 19, 2017 at 12:29 pm

#1972770
RE: Issues with matching pattern using LIKE

jonathan.crawford - Monday, December 18, 2017 8:17 PM
Luis Cazares - Friday, December 15, 2017 7:40 AM
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 18, 2017 at 8:26 pm

#1972617
RE: Difference between dates displayed in days, hours, minutes and seconds

I would take some benefit of using the integers behind and performance improvement of using an inline table-valued function.

CREATE FUNCTION dbo.ifn_DifferenceBetweenDates
(
@Date1 Datetime, --...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 18, 2017 at 1:44 pm

#1972584
RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

I thank you for the test, Jeff. However, I still don't believe that someone will be updating 10 million rows at a time. The most common scenario would be to...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

December 18, 2017 at 11:01 am

#1972560

Viewing 15 posts - 766 through 780 (of 8,731 total)