Forum Replies Created

Viewing 15 posts - 10,696 through 10,710 (of 13,460 total)

  • RE: Code Formatting

    looks like you've already fixed the issue where the multiple single quotes; that was fast.

    I still see the issue in my example where a less-than-symbol was assumed to start an...

    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!

    August 3, 2009 at 9:52 am

    #1033737

  • RE: handelling of IDENTITY Column in a Table

    While I'm thinking about it, can you give us some metrics as well? how many total rows in the table? how many rows are affected in that 15 minute update?

    how...

    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!

    August 3, 2009 at 6:36 am

    #1033605

  • RE: handelling of IDENTITY Column in a Table

    i would guess that you are looking at it wrong; an identity, if you are not searching by that now, would not help performance in the slightest.

    I'd like to see...

    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!

    August 3, 2009 at 6:27 am

    #1033603

  • RE: Purchase of SQL Server 2005 Developer Edition

    you might want to consider getting SQL 2008 Developer Edition; it is the latest and greatest and all that.

    I just got one earlier last week; I'd been running 2005 forever,...

    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!

    August 1, 2009 at 3:44 pm

    #1033405

  • RE: Display address in vertical format

    am i missing something? it looks like a comma delimited string, so you could replace the comma with CrLf (Char(13) + CHAR(10) ) for display purposes, or did you want...

    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!

    July 31, 2009 at 10:59 pm

    #1033278

  • RE: How COMMIT works in SQL Server?

    you need to explicitly start a transaction, because SQL server assumes by default that every command is auto-committed unless there is a BEGIN TRAN command;but other than that it is...

    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!

    July 30, 2009 at 8:07 pm

    #1032764

  • RE: Is there a way to programatically alter a function

    ahh, i got you...so you are simply altering them with identical code so the dependencies get entered in correctly, 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!

    July 30, 2009 at 2:33 pm

    #1032682

  • RE: Installing reporting services on SQL server default instance

    if it's grayed out, then it's already installed, 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!

    July 30, 2009 at 2:32 pm

    #1032681

  • RE: How spool the out put to a file

    your only option is SSMS's output results to file.

    SQL server does not have a native TSQL command to output to a file; the expectation is the presentation layer would do...

    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!

    July 30, 2009 at 12:12 pm

    #1032588

  • RE: You are being asked, Your tempdb is full How do you troubleshoot...

    i agree with GSquared;

    if the disk is NOT full, that implies someone might have put a hard limit on the max size of tempdb; you'd need to allow 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!

    July 30, 2009 at 11:37 am

    #1032569

  • RE: Installing reporting services on SQL server default instance

    functionally, developer version and enterprise are identical, except for licensing.

    also, enterprise can't install on a non-server version of a machine...it requires a server OS.

    developer version has everything you need, without...

    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!

    July 30, 2009 at 11:15 am

    #1032547

  • RE: Last Modified Trigger in Management Studio Edit Mode

    glad i could help and thanks for the feedback!

    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!

    July 30, 2009 at 10:57 am

    #1032540

  • RE: Last Modified Trigger in Management Studio Edit Mode

    dunno if it will make a difference, but instead of using IN()

    i always use a join for the inserted table instead:

    UPDATE Vendors

    SET Vendors.Modified=getdate()

    FROM INSERTED

    WHERE Vendors.kpVendorID = INSERTED.kpVendorID

    in that situation,...

    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!

    July 30, 2009 at 10:25 am

    #1032514

  • RE: BULK insert problem

    saved in my snippets: bulk insert will not accept a variable, so you need to use the EXEC command instead:

    --bulk insert won't take a variable name, so make a sql...

    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!

    July 30, 2009 at 10:12 am

    #1032502

  • RE: Is there a way to programatically alter a function

    i saw your other thread on dependancy order...what does that have to do with altering your functions? i'm confused on 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!

    July 30, 2009 at 9:25 am

    #1032464

Viewing 15 posts - 10,696 through 10,710 (of 13,460 total)