Forum Replies Created

Viewing 15 posts - 11,656 through 11,670 (of 13,460 total)

  • RE: How can i remove the history of server name selection in login window

    the info is stored in the registry.

    open regedit and search for one of the servers you know you want to eliminate. you can see which ones exist from there.

    on my...

    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!

    February 4, 2009 at 10:00 pm

    #938595

  • RE: sql query manual increment

    first it's not too late. It is never too late to fix an issue and make something better.

    it is very easy to fix, you just have to break out 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!

    February 4, 2009 at 9:29 pm

    #938585

  • RE: Proc call runs longer than code execution in 2000

    Excellent! glad we could help!

    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!

    February 4, 2009 at 9:00 am

    #938058

  • RE: Proc call runs longer than code execution in 2000

    yeah, i don't know if it can be resolved...SP1 doesn't prevent a a bad execution from being built....SQL2005 still parameter sniffs, right?

    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!

    February 4, 2009 at 8:53 am

    #938038

  • RE: Slow Stored Procedure run time

    yep same issue as the post here:http://www.sqlservercentral.com/Forums/Topic649831-8-1.aspx

    i put a decent explanation and fixes there.

    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!

    February 4, 2009 at 8:46 am

    #938025

  • RE: Proc call runs longer than code execution in 2000

    I think the issue you are hitting is called "parameter sniffing"; when the code is compiled into a procedure, the compiler makes a best guess on the parameters when 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!

    February 4, 2009 at 8:41 am

    #938018

  • RE: Changed to a StarWars Avatar...am I part of the Club now?

    I didn't want to be obvious and choose Darth Maul or something; obscurity is good sometimes.

    how about we go with Bill and Teds Excellent Adventures? I could dig an avatar...

    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!

    February 4, 2009 at 7:26 am

    #937956

  • RE: Family Name Issue with Proper Case

    the best way is to update from a list of known last names...you cannot assume that every last name that starts with mac... gets it's 4th letter capitalized...

    macaroni, machiavelli 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!

    February 3, 2009 at 12:22 pm

    #937437

  • RE: Looking for the term used to describe the Status/State problem

    i think your HOUSE_EVENT table is going to have just certain statuses that are relevent to the current status of a property...many can be ignored i assume?

    correct me if 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!

    February 3, 2009 at 12:17 pm

    #937429

  • RE: Replication without a primary key in the publisher ?

    lol...you know the answer....you'll have to add a primary key to the table

    ...even if nothing uses it business wise, you can add an idnetity() column, make it the primary key,a...

    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!

    February 3, 2009 at 7:20 am

    #937106

  • RE: SQL Server 2005 -- name of the dataserver

    when you install, you have the choice on installing a default instance or a named instance

    if you chose default instance, the SQL server is the name of the machine....

    sqlcmd -U...

    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!

    February 3, 2009 at 6:47 am

    #937083

  • RE: 1ST/2ND/3RD SUPPORT

    It's kind of intuitive once you understand it's just a support hierarchy.

    1st level support is typically the person that answers the phone or email, but may be more customer service...

    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!

    February 3, 2009 at 6:34 am

    #937074

  • RE: Increasing User connections in SQL SERVER 2005

    yeah, not directly configurable without turning on advanced options.

    i think this is what you are after:

    [font="Courier New"]

    --advanced options get enabled

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE

    GO

    --'user connections' 0=unlimited,...

    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!

    February 3, 2009 at 6:20 am

    #937065

  • RE: how to convert seconds to HH:MM:SS format?

    it's kind of easy...

    in your case, you only care about the time portion of any date....not the date itself.

    so you ADD the number of seconds to an arbitrary date,

    then one...

    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!

    February 2, 2009 at 11:26 am

    #936616

  • RE: Backup database on a host provider

    i meant here on SqlServerCentral.

    Teh script ssections contains thousands of script contributions to do a variety of things; there's at least half a dozen to help you scritp out your...

    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!

    February 2, 2009 at 8:01 am

    #936446

Viewing 15 posts - 11,656 through 11,670 (of 13,460 total)