Forum Replies Created

Viewing 15 posts - 556 through 570 (of 13,460 total)

  • RE: Presentation Software Recommendations

    hey guys my non profit's event is coming up again, and i'm still looking to replace something i cobbled together that is more professional.
    i really need a organized deck...

    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!

    April 21, 2017 at 4:17 pm

    #1939401

  • RE: Need advice on encryption to be implemented on custom application

    Those three are not quite the same; they really are different technologies with different requirements.
    TDE(Transparent Data Encryption) protects your data at rest: that means a backup, or a san...

    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!

    April 19, 2017 at 11:00 am

    #1938886

  • RE: Convert Date Time Parameter to String

    I'm with Luis, one of the most recurring performance and bad data issues i see is not maintaining data types when comparing data to parameters.
    datetimes are datetimes, varchars are...

    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!

    April 13, 2017 at 11:04 am

    #1938104

  • RE: Remove SQL Comments

    Lynn Pettis - Monday, April 3, 2017 3:22 PM

    Just curious, why would you want to remove comments from your SQL code/scripts?

    I've done...

    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!

    April 13, 2017 at 7:12 am

    #1938031

  • RE: Get DDL for any SQL 2005 table

    For those of you subscribed to this thread, I've made some fixes today for a couple of things i found.
    These changes are  noted in section V3.17.
    When scripting foreign...

    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!

    April 10, 2017 at 10:51 am

    #1937477

  • RE: How to find out error record and column which is causing error during data load into a table ????????

    your data type sized obviously don't match...since it's a linked server, you can properly interrogate their sizes.

    if both sides are SQL server, a simple EXCEPT operator should work:

    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!

    April 7, 2017 at 2:20 pm

    #1937288

  • RE: Store result in Variable of dynamic query

    i think the issue is you did not declare an outer variable to capture the results as an output , nor did you actually use the variable declared in 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!

    April 7, 2017 at 12:55 pm

    #1937276

  • RE: FSTREAM - Get Filename?

    i think you want to use a different function right?

    this page from Microsoft has a decent example:
    https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/getfilenamespacepath-transact-sql

    what does this return for you?
    SELECT...

    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!

    April 7, 2017 at 7:01 am

    #1937199

  • RE: SSIS Package runs fast through SQL Agent first time only

    Probably not enough information...what, specifically, is the package doing?
    i would be looking at performance in the database first and foremost, assuming the package is doing something in the database....

    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!

    April 7, 2017 at 6:52 am

    #1937197

  • RE: Script for below requests

    i'll help with the slightly more difficult one(#2)
    for number 1, sys.databases has a create_date column.

    for #2, i put this together, and it returns serveruptime, vs service uptime.

    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!

    April 6, 2017 at 2:31 pm

    #1937154

  • RE: identity insert

    SGT_squeequal - Thursday, April 6, 2017 12:55 PM

    unfortunately i cant, i must be missing something, if i create 2 new tables 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!

    April 6, 2017 at 1:22 pm

    #1937142

  • RE: identity insert

    SGT_squeequal - Thursday, April 6, 2017 12:40 PM

    Cheers Guys,

    Lowell, 
    i am executing my script exactly in the way you explain however, i...

    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!

    April 6, 2017 at 12:45 pm

    #1937125

  • RE: identity insert

    sgmunson - Thursday, April 6, 2017 12:32 PM

    Lowell,

    Is there a simple query to determine what table has that property turned on ?

    i...

    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!

    April 6, 2017 at 12:40 pm

    #1937122

  • RE: identity insert

    youll need basically three commands for each identity insert, because you have to toggle the setting off on one table, before you set it ON for the next.

    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!

    April 6, 2017 at 12:30 pm

    #1937119

  • RE: Issue with OUT Param

    i could not tell you; the logic looks strange.
    if rows get inserted, that is considered an error? IF ( @Count <> 0 ) INSERT INTO dbo.Log(Error....

    designwise, the procedure itself...

    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!

    April 6, 2017 at 12:25 pm

    #1937114

Viewing 15 posts - 556 through 570 (of 13,460 total)