Forum Replies Created

Viewing 15 posts - 241 through 255 (of 13,460 total)

  • RE: SSIS packages slow BCP processing

    is this a pure bulk insert or a merge component or something?
    give is a bit more info onthe package design please.
    also , are you using lookups to join...

    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!

    February 21, 2019 at 1:55 pm

    #2022602

  • RE: Get DDL for any SQL 2005 table

    all those interim versions from 5+ years ago are gone,and only the latest are maintained.
    these are the links, which is @ version 3.18, i need to post my latest...

    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!

    February 21, 2019 at 9:41 am

    #2022565

  • RE: Trying to export data into csv file using bcp stored procedure

    you are trying to access a file in your private protected space
    C:\Users\mp88_\OneDrive\Desktop\samplefile.txt

    if you ran bcp from the command line itself. YOU have access to that file.
    but...

    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!

    February 19, 2019 at 2:24 pm

    #2022435

  • RE: Installing Office (Excel) on database server - security conserns

    this might be a case of you being familiar with using the Excel automation hammer, and everything looks like a nail....

    a lot of what you pointed out can...

    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!

    February 19, 2019 at 8:42 am

    #2022386

  • RE: Failed to initialize sqlcmd library with error number -2147467259

    I am in the same situation, I have reviewed the answers that you have received but I have only managed to get the procedure executed but no emails come...

    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!

    February 18, 2019 at 3:18 pm

    #2022324

  • RE: Installing Office (Excel) on database server - security conserns

    there is no need to install office on a server.
    SSIS will use the ACE drivers to create excel documents, so there is no need to install  Office , 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!

    February 18, 2019 at 6:52 am

    #2022270

  • RE: Finding which database who has a specifik string in one field

    something like this should work:

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
    GO

    IF OBJECT_ID('tempdb.[dbo].[#Results]') IS NOT NULL
    DROP TABLE [dbo].[#Results]
    GO
    CREATE TABLE [dbo].[#Results]...

    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!

    February 12, 2019 at 8:38 am

    #2021785

  • RE: Characters are changing after an alter table alter column executed?

    restore the  table from a backup. you have permanently converted the previous data to bad data/question marks instead of retaining the original values.
    Turkish characters sets use  

    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!

    February 12, 2019 at 7:04 am

    #2021767

  • RE: SSMS 17.9, Process Pane columns

    it changes, base don the version of SQL you connect to.
    a connection to SQL2008R2, for example, does not have the columns [NetAddress],[ExecutionCount],RequestID], but a connection to SQL 2016 does...

    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!

    February 12, 2019 at 6:29 am

    #2021763

  • RE: Odd issue, DBA says due to parameter sniffing, could use advice, please...

    parameter sniffing gone wrong can often(almost always?) be related to statistics being out of date. 
    look at the tables being used in the procedure; it only takes a small percentage...

    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!

    February 11, 2019 at 1:46 pm

    #2021714

  • RE: control order of execution within a stored procedure?

    from inside the procedure, the commands run in the order you created them in, and there is no way for the third to execute before the previous commands complete.

    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!

    February 10, 2019 at 6:39 am

    #2021605

  • RE: Case When Between issue

    you want to use Datetime for all values

    here i am stripping out time to get the first day of the current week/Monday, and adding either one or two...

    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!

    February 4, 2019 at 11:14 am

    #2021062

  • RE: upgrade to 2016 causing performance problems

    one of the know requirements when you upgrade is to update statistics for all tables, as the optimizer is different.
    did you rebuild your indexes/update statistics yet, after upgrading 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!

    February 3, 2019 at 8:24 am

    #2020964

  • RE: Can you add line breaks in stored text?

    you want to store it with the line feeds in place already.

    INSERT INTO YourTable ( ID, NickName,Category,Phrase)
    SELECT 1,'excitedBirthday','Birthday',
    'I bet you''re so excited
    Excited...

    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!

    February 3, 2019 at 6:34 am

    #2020957

  • RE: Export multiple query results with different columns (name and number of columns) into one sheet of CSV file

    its also possible with OpenXML and a script task, but the learning curve to learn to get that right is pretty steep.
    once you have it though, you can decide...

    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!

    February 3, 2019 at 5:36 am

    #2020952

    • Viewing 15 posts - 241 through 255 (of 13,460 total)