Forum Replies Created

Viewing 15 posts - 12,571 through 12,585 (of 13,460 total)

  • RE: Strange performance problem using ADO

    Tony may be on to something....a typical problem where something works fine, and then slows down over time often points to out of date statistics on the database; this can...

    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!

    May 3, 2007 at 6:42 am

    #704045

  • RE: user_name() vs system_user - why does one not return the correct name?

    i think what you are seening is whenever anyone is given the role db_owner(), their user_name is considered to be dbo for the queries performed.... since everyone else comes in...

    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!

    May 2, 2007 at 8:40 am

    #703825

  • RE: SQL -> Progress db

    i fat fingered the link and added a backslash..sorry.

    I edited the link and it does take me to the right spot now.

    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!

    May 2, 2007 at 8:33 am

    #703823

  • RE: SQL -> Progress db

    a better explanation of index hints than BOL supplies can be found here:

    http://www.sqlservercentral.com/columnists/rmarda/performanceaddinghints_printversion.asp

    it's bad to second guess SQL Server's abilities as far as deciding which index to use, but...

    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!

    May 2, 2007 at 7:31 am

    #703797

  • RE: Size of table created on the fly is limited

    you didn't really describe what the problem was...whether it was slow running, received a real error, or just bad performance.....so here's my guesstimate:

    There's no problem creating a really big temp...

    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 30, 2007 at 4:41 am

    #703238

  • RE: MSDE shutting down and restarting when calling an SP

    Glad you worked it out , Dave;  keep reading SSC; lots of good stuff here.

    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 26, 2007 at 11:33 am

    #702717

  • RE: Use of temp table

    it looks to me like you are using a loop to insert one group of data at a time, when you could do it all as a single set based...

    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 24, 2007 at 8:05 am

    #702173

  • RE: Copying a file from a webserver to local disk

    are you sure you want to do in in SQL Server? why not a programming language, like .NET,VB6 or something?  you stated you just want to copy it to disk,...

    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 23, 2007 at 10:29 pm

    #702068

  • RE: opening table in EM causes vb applications run time errors

    pointing out the obvious, but you should not be trying to display all 4.8 million rows in EM while connected to a production database....

    you are right, EM and SQL server...

    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 23, 2007 at 10:04 pm

    #702067

  • RE: MSDE shutting down and restarting when calling an SP

    i can only suggest some general/generic things to look at; nothing obvious or strange in your query, so I'd look at things like service pack on the machines that fail...

    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, 2007 at 10:46 am

    #701507

  • RE: stored procedure within stored procedure

    what Guru is saying is you will receive an error if you try and use EXEC to populate a @table variable;you must use a #temp or ##temp table

    here's a proc...

    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, 2007 at 9:52 am

    #701486

  • RE: One Major Dbase V Many Small Dbs

    we recently did the same thing in our shop...we had separate databases for each application.  whenever one of our clients had more than one application, the issue of duplicate 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!

    April 19, 2007 at 8:23 am

    #701452

  • RE: MSSQL 2000 on Virtual Server ?

    don't know if this will help, but this thread talks about differences in file/folder permissions screwing up an install on a normal machine:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=357952#bm358701

    HTH

    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, 2007 at 6:22 am

    #701400

  • RE: Last update/insert

    you cannot do that natively. the change/insert information related to data is not captured.

    usually, if this is required,  you'd add two columns to the table, as well as a trigger....search...

    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, 2007 at 8:49 am

    #700394

  • RE: Differences in SQL 2000

    this will be data related....

    on db1, the recordset frm.AdodcTemp.Recordset was loaded with a select statement...

    but on db2, the same select statment returned no data, so the recordset is at 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 12, 2007 at 4:58 am

    #700007

Viewing 15 posts - 12,571 through 12,585 (of 13,460 total)