Forum Replies Created

Viewing 15 posts - 7,726 through 7,740 (of 13,460 total)

  • RE: How to retrieve Image file from a SQL Table

    I just tested this for proof of concept;

    the idea here is to loop through all records in a table via a datareader and write each binary object to disk; 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!

    April 14, 2011 at 12:59 pm

    #1311814

  • RE: How to retrieve Image file from a SQL Table

    TSQL is the wrong tool for this; TSQL's really designed for set based information, and passing it as recordsets/datatables to an application layer.

    TSQL's not designed to be writing to...

    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 14, 2011 at 11:49 am

    #1311760

  • RE: import access db in sqlserver

    toddasd (4/13/2011)

    There is no importing an Access database in SQL Server.

    not sure what you mean by that... a data source is just a data source.

    maybe you mean the other...

    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 14, 2011 at 11:31 am

    #1311750

  • RE: table order in joins and performance

    On SQL Server the order of your joins doesn't matter, because query engine will reorganize JOIN order depending on statistics for indexes and other things.

    To prove it to yourself, what...

    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 14, 2011 at 9:55 am

    #1311703

  • RE: Conversion/Mirgration Project

    one thing you could grab a free cityname/state/zipcode database off the web(42K rows or so) and join it to your data on city/state/zip and see what doesn't match 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 14, 2011 at 9:10 am

    #1311684

  • RE: db_datareader

    just having a login gives you read rights to some master tables and the ability to create #tmp tables; that's perfectly normal.

    you do not even need to be a user...

    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 14, 2011 at 9:04 am

    #1311676

  • RE: Need new laptop

    I'm just like you...i used to have a Dell , upgraded to an HP win7 64 bit with an I5 processor & 4Gigs , and have had tons of hardware...

    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 14, 2011 at 8:58 am

    #1311667

  • RE: How to import Multiple csv files from Multiple Folders into single sql server table

    another obvious fix would be to simply copy all the files form 140 folders to a single folder, and use the example i gave against that one folder.

    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 14, 2011 at 8:24 am

    #1311634

  • RE: How to import Multiple csv files from Multiple Folders into single sql server table

    I presented an idea and example to get you part of the solution. I thought it would get you started...you really didn't provide anything concrete as far as true requirements.

    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!

    April 14, 2011 at 8:19 am

    #1311629

  • RE: guidance needed for troubleshooting an application timeout issue

    is your DNN instance local, on your network, or on some shared hosting server like ihostasp? I know my shared hsoting sometimes bogs down, but it's hard to diagnose 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!

    April 14, 2011 at 8:09 am

    #1311616

  • RE: How to import Multiple csv files from Multiple Folders into single sql server table

    here's an example i like to post using BULK insert. you can do this via SSIs as well, but it's a different technique.

    in my example below, i have 4 known...

    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 14, 2011 at 6:56 am

    #1311552

  • RE: where is sql server management studio

    note: thread is 4 months old.

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

    #1311307

  • RE: convert CASE logic to IF

    ok, i've seen people knee jerk on things like that...

    You could mask the CASE statement as a SELECT (or JOIN it to your other data) like this:

    /*--Results

    (No column name)StartParamEndParam

    DailyNULL2011-04-13 14:44:10.230*/

    DECLARE...

    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, 2011 at 12:45 pm

    #1311259

  • RE: Database Mail Ip

    how about nslookup mail.yourserver.com to see what the DNS reverses to, or a ping mail.yourserver.com and see the address it's going to;

    why do you need it's IP vs the DNS...

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

    #1311218

  • RE: Finding the Culprit for deleting Linked Server

    ok actually, I believe this shows you some of the info specific to a linked server:

    SELECT *

    FROM ::fn_dblog(NULL, NULL)

    where [allocUnitName] IN('sys.sysxsrvs.cl','sys.syslnklgns.cl')

    but without a way to tie it to a user,...

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

    #1311217

Viewing 15 posts - 7,726 through 7,740 (of 13,460 total)