Forum Replies Created

Viewing 15 posts - 7,216 through 7,230 (of 13,460 total)

  • RE: Displaying Entire VARCHAR(MAX) from a SQL Query

    SSMS is not the ideal tool to display varchar(max) fields, as GSquared was implying:

    one of the settings it uses for increasing perforamnce can also prevent the full text of 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!

    July 5, 2011 at 9:58 am

    #1348390

  • RE: UPDATE statement is not restricted as intended using WHERE clauses

    an update statement with a WHERE follows the WHERE restrictions, so if you are getting more rows affected than you expect, the best thing to do is look at...

    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 5, 2011 at 9:15 am

    #1348351

  • RE: using SqlbulkCopy to do data migration

    i've used SQLBulkCopy for moving data from other sources to SQL, and i like it a lot...it is really fast.

    i suspect the SELECT * stuff you are seeing is probably...

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

    #1348326

  • RE: sqlparser parseresult - How do you parse?

    OK Babu, say you've presented a list of views in your GUI, and the end user selected one of them.

    i don't think you need any other parsing DLL at...

    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 5, 2011 at 6:17 am

    #1348223

  • RE: sqlparser parseresult - How do you parse?

    yeah it was a little work to find;

    all this work is from a Win7/64 bit OS.

    my example assumes you installed SQL Server 2008; although i installed 64 bit, the specific...

    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 2, 2011 at 11:32 am

    #1347467

  • RE: Can I make my database to work only for particular web site and not any other

    if you are not hosting it yourself, you just have to trust that the DBA is a professional, and does not to want to steal your data

    there's another thread running...

    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 1, 2011 at 2:57 pm

    #1347356

  • RE: Backup file size 150 GB - Restore requires 3 times that size on disk

    too many windows open!

    i editit it off in another window, and then when i thought it was ready, hit the "reply" on the wrong tab...

    I'm properly admonished now, thanks!

    :w00t:

    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 1, 2011 at 2:47 pm

    #1347352

  • RE: SQL Account Loses Mapping

    here's a simple script to search both the job steps in msdb as well as the current database's stored procedure definitions.

    this might point you to something to investigate.

    I actually had...

    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 1, 2011 at 2:28 pm

    #1347340

  • RE: SQL Account Loses Mapping

    Lowell (7/1/2011)

    any chance there is a script or job doing something like this?

    since you said it happens "regularly, maybe there's an obscure snippet in a job or something

    IF EXISTS...

    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 1, 2011 at 2:16 pm

    #1347331

  • RE: Backup file size 150 GB - Restore requires 3 times that size on disk

    any chance there is a script or job doing something like this?

    since you said it happens "regularly, maybe there's an obscure snippet in a job or something

    IF EXISTS (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!

    July 1, 2011 at 2:16 pm

    #1347330

  • RE: Help with SQL query

    i've always done this with dynamic SQL; it makes for better execution plans.

    my "search function makes all searches with "starts with" for text fields, and exact matches for numbers.

    so searching...

    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 1, 2011 at 2:02 pm

    #1347323

  • RE: sqlparser parseresult - How do you parse?

    Babu thanks for giving me something new and interesting to play with; being able to parse a statement has a lot of possibilities.

    i found an example in german here: http://olafhelper.over-blog.de/article-34700638.html

    i...

    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 1, 2011 at 11:48 am

    #1347241

  • RE: Unable to export to excel using BCP

    mihir.nasikkar (7/1/2011)

    Is there any option other than OPENROWSET to export the result set into excel spreadsheet ?

    Thanks

    I'm getting caught up on words i guess.

    OPENROWSET is not used to export...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!

    July 1, 2011 at 9:27 am

    #1347106

  • RE: Unable to export to excel using BCP

    OLE DB provider "Microsoft.Jet.OLEDB.4.0" is a 32 bit driver...so if your sql instance is 64 bit, you'd get that error.

    you probably need to download the updated 64 bit ACE drivers...

    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 1, 2011 at 8:08 am

    #1347035

  • RE: Unable to export to excel using BCP

    what error do you get?

    i think bcp exports as raw text only, so any resulting file, no matter what extension you put on it, needs to be opened in something...

    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 1, 2011 at 7:02 am

    #1346998

Viewing 15 posts - 7,216 through 7,230 (of 13,460 total)