Forum Replies Created

Viewing 15 posts - 136 through 150 (of 13,460 total)

  • Reply To: How to load/import a pdf file into azure dB table as base64 column

    we store files in our databases and varbinary(max)

    you would be adding an extra step to convert varbinary to base64/varchar(max). then if you need the file, you have to double convert...

    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!

    October 23, 2019 at 5:20 pm

    #3691408

  • Reply To: remove double quotes from file ssis- azure

    dang i missed that part.

    https://social.msdn.microsoft.com/Forums/SECURITY/en-US/dfa95b28-e2aa-465d-b34a-b230b3d0b624/ssis-azure-blob-source-limitation?forum=sqlintegrationservices

    that literally says bring it into someplace where you can use a flat file connection manager, since it is not supported yet.

     

    sorry:

    Azure Blob Source does not...

    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!

    October 22, 2019 at 7:59 pm

    #3691107

  • Reply To: remove double quotes from file ssis- azure

    in your flatfile connection manager, change the text qualifier to a double quote. it will remove the dbl quotes when it builds that path to the destination for clean 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!

    October 22, 2019 at 7:27 pm

    #3691101

  • Reply To: Used Stored procedure in SSIS with different database name in DEV, Test and Prod

    one of the core caveats of the development life cycle is that  the code is tested in dev, and is promoted UNCHANGED to the next layer for acceptance and testing.

    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!

    October 21, 2019 at 7:20 pm

    #3690724

  • Reply To: How to monitor a stored procedure to capture execution times

    you can check teh procedure cache.

    if you run this, you might see the same procedure multiple times, because each has a specific execution plan due to different parameters:

    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!

    October 21, 2019 at 1:13 pm

    #3690562

  • Reply To: service pack Question

    does the machine in question have more than one instance installed? could you have updated just one of the multiple instances on that machine to SP4 instead of all of...

    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!

    October 17, 2019 at 5:19 pm

    #3689823

  • Reply To: Issues trying to restore a backup file from SQL Server 2016 to SQL Server 2012

    generating the schema scripts for tables/views/procs is easy in SSMS, but don't script the data. 60 gig of data is unmanageable as flat files, you want to use The import...

    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!

    October 16, 2019 at 8:35 pm

    #3689439

  • Reply To: Issues trying to restore a backup file from SQL Server 2016 to SQL Server 2012

    it is not possible to restore a SQL database from a higher version to a lower version.

    you can only restore from lower to higher versions.

    you will have to use 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!

    October 16, 2019 at 6:40 pm

    #3689393

  • Reply To: how to print NULL for datetime column

    I think you want to convert the date to varchar, and if the results is NULL, use the string NULL

    ISNULL(convert(varchar(20),@Date,GETDATE()),110),'NULL')

    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!

    October 16, 2019 at 6:03 pm

    #3689383

  • Reply To: Script multiple queries

    by queries, i am guessing you mean tables, instead.

    you can sue the metadata to script out the actual queries by getting the column names, is that what you are 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!

    October 16, 2019 at 4:47 pm

    #3689353

  • Reply To: empty sys.dm_exec_query_stats

    have you set your max server memory to a low threshold, so it ends up clearing the procedure cache?

    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!

    October 16, 2019 at 2:29 pm

    #3689289

  • Reply To: Performance Tuning Question?

    in my experience, most performance problems come from coding that works, but performs poorly on large data sets.

    as a result, i look at the code, here are some of the...

    • This reply was modified 6 years, 7 months ago by Lowell. Reason: added FOR XML hint

    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!

    October 15, 2019 at 2:02 pm

    #3688886

  • Reply To: Saving Hebrew text as nvarchar

    ok the forum converts to varchar as  well! so my  nvarchar string characters got converted to question marks!

     

    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!

    October 9, 2019 at 5:06 pm

    #3687461

  • Reply To: Saving Hebrew text as nvarchar

    your query did not appear, but i suspect it has to do with implicit conversions.

    you have to use the N'' denotation to make sure SQL knows it is nvarchar data.

     

    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!

    October 9, 2019 at 5:05 pm

    #3687460

  • Reply To: partition table design issue

    are you using a sliding partition strategy for archiving?

    don't look at the file groups. file groups is how it is stored, and potentially archived. that is independent from the logical...

    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!

    October 4, 2019 at 6:56 pm

    #3686130

    • Viewing 15 posts - 136 through 150 (of 13,460 total)