Forum Replies Created

Viewing 15 posts - 5,746 through 5,760 (of 13,460 total)

  • RE: Script all tables contraints, indexes, keys and triggers

    yes, SSMS provides a built in GUI functionality to do that; it's highly configurable via checkboxes to determine what to script or not.

    simply right click on the database and follow...

    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!

    March 21, 2012 at 7:47 am

    #1462137

  • RE: Stored Procedure Not Reading Duplicate Entries

    With actually seeing the procedure itself, all we can do is offer basic advise.

    if the Prof is skipping data, it is usually because a WHERE or JOIN statement in it...

    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!

    March 21, 2012 at 4:42 am

    #1462075

  • RE: Fast procedure execution but super slow report rendering in R2

    do you have a lot of defaults for the parameters, for example @datefrom dateime = NULL in your definitions?

    it might be because of parameter sniffing exactly because of the defaults...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!

    March 20, 2012 at 1:07 pm

    #1461846

  • RE: Prevent or log Truncate Table commands

    a serverside trace for DML changes is very lightweight; if you have it rollover you won't have to worry too much about log file sizes,a nd it may help you...

    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!

    March 20, 2012 at 12:41 pm

    #1461831

  • RE: Procedure is taking much time

    first guess:

    does this return the same results as the two hour procedure?

    SELECT

    ent.document_version_id,

    ent.[name],

    ent.[value],

    ent.entry_path

    FROM mydb.dbo.entry ent WITH (READCOMMITTED)

    LEFT OUTER JOIN

    (SELECT

    d.document_id,

    MAX(dv.document_version_id ) AS document_version_id

    FROM

    Dot_Net_Installer_REP.dbo.document d WITH...

    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!

    March 20, 2012 at 12:26 pm

    #1461822

  • RE: Explain Plain

    does a plan for this look any better?

    Declare @param int

    SET @param=5506

    SELECT [this_].[EcomConfigurationId] [EcomConf1_3_0_],

    [this_].[EcomEmailAddress] [EcomEmai2_3_0_],

    [this_].[SecondryEcomEmailAddress] [Secondry3_3_0_],

    ...

    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!

    March 20, 2012 at 12:08 pm

    #1461808

  • RE: Explain Plain

    I'm guessing that because the command sent was ...

    WHERE [this_].[SiteId] = 5506

    the 5506 has to be implicitly converted to the approriate type(the column it is compared to)

    if you...

    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!

    March 20, 2012 at 11:28 am

    #1461794

  • RE: unable to connect to localhost

    go to Control panel>>Administrative Tools>>Services.

    you want to make sure the service exists first.

    if it doesn't, then you probably only installed the client tools.

    if it does, look at the name of...

    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!

    March 20, 2012 at 10:26 am

    #1461761

  • RE: Explain Plain

    is the datatype of the parameter passed also int, or is there an ISNULL(@param,0) used anywhere in the code?

    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!

    March 20, 2012 at 10:21 am

    #1461757

  • RE: Creating a text file in SQL Server 2008 on a remote - non domain PC

    it's permissions still.

    this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and folders,xp_cmdshell,bcp with...

    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!

    March 20, 2012 at 10:02 am

    #1461740

  • RE: How to copy a Project from one stand-alone PC to another

    gary.p.heath (3/20/2012)

    Lowell, you have made more sense and taught me more in the past hour than I have been able to learn in the past week over at CodeProject.com !!!...

    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!

    March 20, 2012 at 9:41 am

    #1461723

  • RE: How to copy a Project from one stand-alone PC to another

    I think you'll be fine if you just add a little flexibility into your application for handling the building of the connection string.

    for example, what should happen if i wanted...

    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!

    March 20, 2012 at 9:09 am

    #1461693

  • RE: How to copy a Project from one stand-alone PC to another

    gary.p.heath (3/20/2012)

    OK, thank you, that makes sense.

    No, my program is a Windows Form with multiple Tabs that allows the user to update the database (yearly maintenance) and then process 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!

    March 20, 2012 at 8:33 am

    #1461662

  • RE: How to copy a Project from one stand-alone PC to another

    nope. a database connection would be part of the project, not the database or the database service....the application "assumes" it's there.

    you would typically parameterize the elements required for the connection...

    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!

    March 20, 2012 at 7:52 am

    #1461628

  • RE: Procedure is taking much time

    without seeing the procedure itself, all i can offer is basic suggestions.

    you might be suffering from parameter sniffing.

    you might want to update your statistics.

    the SET options (ansi_nulls, etc) between SSMS...

    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!

    March 20, 2012 at 7:43 am

    #1461619

Viewing 15 posts - 5,746 through 5,760 (of 13,460 total)