Forum Replies Created

Viewing 15 posts - 6,361 through 6,375 (of 13,460 total)

  • RE: Conerting a DateDiff Average time from an int to HH:mm:ss

    i'm sure there are other ways, but here's one way:

    --3 hrs 55 min 12 secs

    /*

    ----------- ----------- ----------- -------

    3 ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 22, 2011 at 6:27 am

    #1411423

  • RE: Faster way to INSERT INTO large table

    Amy.G (11/21/2011)

    WOW. Lowell and Craig -- you guys really went above and beyond in helping me with this mundane issue. Thank you so much.

    Amy keep us posted on this! getting...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 2:43 pm

    #1411059

  • RE: Faster way to INSERT INTO large table

    for a quickie compare Amy, peek at the estimated planfor this, and also go ahead and run it;

    what kind of performance differnece do you get?

    i think it will be several...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 2:27 pm

    #1411050

  • RE: Faster way to INSERT INTO large table

    Amy.G (11/21/2011)

    OK, yes, you have a point that I should be paying much more attention to the indexes on a table and utilizing them. With that in mind, I want...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 1:42 pm

    #1411032

  • RE: Faster way to INSERT INTO large table

    Amy.G (11/21/2011)

    Lowell, If you want the actual execution plan, you'll have to wait quite a while. There are two indexes on the insert into table (PK clustereed and non-unique, non-clustered)...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 12:26 pm

    #1411001

  • RE: No.of weekdays in each month

    bhaveshp.dba (11/21/2011)

    Thanks For reply but Can you provide me exact Solution...

    I do not want to create calender table.

    Thanks

    Bhavesh

    ugg; to me, that sounds like "i don't want to use multiplication....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 12:06 pm

    #1410985

  • RE: Faster way to INSERT INTO large table

    amy lets see the actual execution plan; that may tell us if an index would help, or statistics, or much more.

    i'm not sure if that is real code or pseudocode;...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 12:02 pm

    #1410982

  • RE: No.of weekdays in each month

    yet another who concurs on the value of a Calendar table;

    then, depending on the columns /construction you add, you could do somethign as simple as this:

    SELECT COUNT(*) FROM TallyCalendar

    Where [Weekday]='Monday'

    AND...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 11:59 am

    #1410980

  • RE: 64 bit linked server to a folder of text files?

    bumping my own thread; someone out there manage to get a folder of text files worrking in 64 bit?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 11:40 am

    #1410959

  • RE: Replace part of field

    Jim Woods (11/21/2011)

    Getting message that unable to parse query with that - complete script:

    UPDATE PM.Ailment_Info

    SET chunk = replace(chunk, '|3^VA',...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 11:36 am

    #1410955

  • RE: Change SQL admin/sa password across all the servers

    powershell could run the command for each server, however, if you had, say 20 servers, and all 20 servers have sa witht eh same password, that's still not very secure...i'd...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 9:07 am

    #1410807

  • RE: How to do manual failover for sql server cluster 2008

    stop the service on the server which has the active cluster node would be easiest,

    from there you get ideas like unplugging the network cable, turning on the firewall to block...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 8:20 am

    #1410754

  • RE: Converting from Gregorian to Julian Dates For JDE

    nice alistar; only thing i would suggest is an improvement to avoid converting from int-to string and back to int again...you can use integer division and modulous to get the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 21, 2011 at 5:41 am

    #1410629

  • RE: QUOTENAME on a Varchar(Max) column

    Andrew the SSMS Add In from http://www.ssmstoolspack.com/ *** the ability to script data easily from SSMS....

    for a scripted solution , i've used this script from Narayana Vyas Kondreddi a lot,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2011 at 2:38 pm

    #1410213

  • RE: Backup from shared hosting to another server

    joe-1142036 (11/18/2011)

    Thanks everyone for your help. I'm going to conclude that it can't be done with this particular hosting company. As pointed out, that's the drawback of shared...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2011 at 2:29 pm

    #1410209

Viewing 15 posts - 6,361 through 6,375 (of 13,460 total)