Forum Replies Created

Viewing 15 posts - 12,886 through 12,900 (of 13,460 total)

  • RE: Help needed regarding keeping orders table history and data integrity

    If it were me, I think i'd add all the product details to the actual order detail table at the time of order creation. I'd add all the relevant product...

    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!

    November 20, 2006 at 8:00 am

    #672950

  • RE: DB Bloat (rhetorical rant)

    the usual story around my shop...we have tons of desktop-type machines, with a gig of ram and a P2.0 or above processor; I can have a dozen of em 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!

    November 17, 2006 at 1:04 pm

    #672741

  • RE: How to start SQL Server with desired size of tempdb?

    Pretty sure you just set it's size in Enterprise manager:

    right click on tempdb in EM and choose properties....

    Click the Data File tab; my db was defaulted to 8meg; changed 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!

    November 17, 2006 at 11:42 am

    #672720

  • RE: NOT EXISTS vs. NOT IN (subquery)

    SELECT ID FROM tblProjects WHERE

     NOT (ID IN (SELECT ProjectID FROM tblLinks))

    the above would return no rows if there is a ProjectId that is NULL.

    change to this:

    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!

    November 17, 2006 at 11:36 am

    #672716

  • RE: SQL 2000 Table Variables & UDFunctions

    you will have to update the base tables;

    a view is really just a saved SELECT statement. this article might help a little bit:

    http://www.sql-server-performance.com/nn_views.asp

     

    you'd most likely want to create 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!

    November 17, 2006 at 10:27 am

    #672689

  • RE: Rename a text file, move it, using a stored procedure

    this works for me, assuming the files and the folder structure exists: I'm moving a local file to a server named DAISY. The server has a share named C_DRIVE, 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!

    November 17, 2006 at 10:11 am

    #672684

  • RE: Dynamic SQL - Drop Table

    yeah a powerful procedure like that....falling into the wrong hands...i usually keep that one locked up using the WITH ENCRYPTION statment...it's just too much for some people....

    this is just another...

    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!

    November 16, 2006 at 1:58 pm

    #672447

  • RE: Performance and Tuning

    the built in tools work best in my opinion.

    Start>>Run>>Profiler

    connect to the database, and run a trace for a few hours.

    stop teh trace, and save to a trace file.

    open Enterprise manager,...

    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!

    November 16, 2006 at 1:24 pm

    #672441

  • RE: Dynamic SQL - Drop Table

    Remi is right; further you can create temporary stored procedures as well....so that everything is maintained in an individuals session; the combination of temp tables and temp procs would be...

    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!

    November 16, 2006 at 1:19 pm

    #672439

  • RE: Default Constraints

    default constraints are part of a column definition...so you could see them by running sp_help tablename on a table, and any/all constraints on the table would appear on the list....

    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!

    November 16, 2006 at 9:02 am

    #672332

  • RE: Bear with me

    if there's not much more than uppercasing and trimming the entered values, i think i'd use 10 separate statements; it depends on what kind of processing you are doing after...

    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!

    November 16, 2006 at 6:58 am

    #672253

  • RE: RT error 70 Permission Denied

    gotcha; if the file is open, then Word has an exclusive file lock on the document.

    The fix is to always use a COPY of the file every time...

    so you might...

    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!

    November 16, 2006 at 6:46 am

    #672247

  • RE: Bear with me

    hard for me to grasp what we are trying to do....can you give examples of the parameters and also the expected output/results?

    what does @Address contain?

    why can't you just jump straight...

    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!

    November 16, 2006 at 6:35 am

    #672241

  • RE: RT error 70 Permission Denied

    ahh was this web based? i didn't see that.

    I can tell you the error 70 is coming from vb or asp, because there is no error 70 fro 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!

    November 16, 2006 at 6:30 am

    #672240

  • RE: RT error 70 Permission Denied

    This has nothing to do with SQL Server...i suspect that since you made changes in your SQL, and NOW the error pops up, you think it is your changes that...

    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!

    November 15, 2006 at 8:13 pm

    #672185

Viewing 15 posts - 12,886 through 12,900 (of 13,460 total)