Forum Replies Created

Viewing 15 posts - 9,871 through 9,885 (of 13,460 total)

  • RE: Poor Performance in function AFTER Updating Stats

    Ben have you ruled out parameter sniffing?

    if your procedures have default values for some of the parameters, no matter whether you updated statistics or not, parameter sniffing could occur,...

    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 8, 2010 at 9:42 am

    #1130112

  • RE: Quick question on how to judge if an integer equal to any integer

    Lowell (3/8/2010)

    halifaxdal (3/8/2010)

    thanks. it won't work.

    The records are all associated with a UserID, all non 0 value.

    When the input parameter is 0, all records should be pulled out.

    When the input...

    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 8, 2010 at 9:19 am

    #1130090

  • RE: Quick question on how to judge if an integer equal to any integer

    halifaxdal (3/8/2010)

    thanks. it won't work.

    The records are all associated with a UserID, all non 0 value.

    When the input parameter is 0, all records should be pulled out.

    When the input parameter...

    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 8, 2010 at 9:19 am

    #1130088

  • RE: Compare 2 Tables

    2Tall (3/8/2010)

    Hi. I have 2 tables I wish to compare.

    PS: Would sample data, table structures help?

    yeah, to get you an intelligent example, instead of a crappy peudocode example, we'd need...

    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 8, 2010 at 9:00 am

    #1130071

  • RE: allmembers

    moraisilva (3/8/2010)

    how I'm the connetion SQL to visual studio c++ 2005

    since you posted this in SQL Compact Edition, I'm guessing you are asking how to connect to a compact database?

    http://www.connectionstrings.com/sql-server-2005-ce

    Data...

    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 8, 2010 at 8:41 am

    #1130056

  • RE: Query on optimization

    there's a lot of factors in optimization; you'd really want to attach the execution plan here to get any really significant answers.

    are all your joins on PK to FK relationsships?...

    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 7, 2010 at 5:54 am

    #1129746

  • RE: Linkedserver to Remore MS ACCESS FILE

    Rajesh this is a common security issue. The problem is that when you access any resource OUTSIDE ofSQL server, like network shares, local hard drives,sp_OA type functions etc, 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 7, 2010 at 4:42 am

    #1129744

  • RE: Insert to another DB and unigue key issues, etc.

    Jeff i think you want to join the archiv table to the SELECt so you can exclude records already transferred;

    i don't know the PK of the tables, but this should...

    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 5, 2010 at 12:22 pm

    #1129391

  • RE: Cross Server Query Performance;

    how up to date does the data need to be between servers? does it really need to be up-to-the-second as a linked server?

    if it can be a day or so...

    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 5, 2010 at 10:14 am

    #1129293

  • RE: Need to empty my database?

    in my experience, deleting all rows in all tables is not the right thing to do; i'm sure there are many tables that are "lookup' tables used to populate drop...

    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 5, 2010 at 8:58 am

    #1129236

  • RE: Cross Server Query Performance;

    jayanth linked servers can be notoriously slow, and there's a couple of reasons.

    if you are joining two tables, i.e.

    SELECT *

    FROM Server1.Db.dbo.Customers X

    INNER...

    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 5, 2010 at 6:42 am

    #1129130

  • RE: how can i check whether role is working or not

    masterpeice the part you are missing is how to test (along witht he DENY statement already identified.

    here's a working example: note the EXECUTE AS and then the REVERT when i'm...

    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 5, 2010 at 6:27 am

    #1129118

  • RE: Finding Missing Items

    if you can't infer the missing item due to the sum(0 of the dollar amounts not matching, is there some other logic to help infer something is missing?

    for example, if...

    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 4, 2010 at 11:28 am

    #1128664

  • RE: Insert multiple records for a single ID

    would something like this help?

    if i know you are going to take 12/21/2010 off thru 12/25/2010 for the holidays, you want to generate teh 5 days of records?

    --results:

    myuserID ...

    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 3, 2010 at 12:13 pm

    #1128025

  • RE: How to attach databases with the same name on the server

    when you resotre, or when you attach, you have the option to change the database name; it would fail of course if there is already a database with that name;

    if...

    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 3, 2010 at 11:25 am

    #1127977

Viewing 15 posts - 9,871 through 9,885 (of 13,460 total)