Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,838 total)

  • RE: xp_cmdshell heartaches

    fizzleme (12/22/2016)

    ...

    a) I set up a bat file in the C root using a CD dos command to access the subfolder and a DIR command with a b...

    December 22, 2016 at 2:09 pm

    #1919429

  • RE: Why Shouldn't I use Linked server?

    SQL Learner - VKG (12/22/2016)

    Nice update. Does location of data center effects replication or linked server? One server is one state and other is in another state.

    With a linked server...

    December 22, 2016 at 1:30 pm

    #1919422

  • RE: Get unique data

    Is there any other column in the real source data besides this one? It's not clear how to enforce the order of data as specified from just this column.

    December 22, 2016 at 1:20 pm

    #1919418

  • RE: RAID recomendations

    GilaMonster (1/11/2012)

    ... RAID 5 has about the worst write performance of the common RAID levels because of the need to compute and then write parity...

    I had asked for tempdb on...

    December 22, 2016 at 6:47 am

    #1919320

  • RE: I am very new to SQL

    Certification or not, one thing is to never stop learning. Hanging out around here is a good start, I learn new things every day from the articles, editorials, stairways,...

    December 22, 2016 at 6:28 am

    #1919316

  • RE: Unique index but no constraints on table

    Indianrock (12/21/2016)

    Yes it's there under keys and in your query results. So apparently I can disable the unused index and the constraint ( key ) remains in force.

    name...

    December 21, 2016 at 10:59 am

    #1919198

  • RE: Unique index but no constraints on table

    Indianrock (12/21/2016)

    I should probably know this but would like confirmation. This unique index is not being used for reads and that has been the case in QA and prod...

    December 21, 2016 at 9:51 am

    #1919184

  • RE: Request for review of Star schema design

    Andrew P (12/20/2016)

    You're right, it would have been better if I had only attached one of those schemas, they're all very similar. I had just split them from one giant...

    December 21, 2016 at 8:27 am

    #1919167

  • RE: Why Shouldn't I use Linked server?

    SQL Learner - VKG (12/21/2016)

    In the nutshell, it is well said above that using Replication or other option is better to be used in place of linked server. Just adding...

    December 21, 2016 at 7:31 am

    #1919144

  • RE: Find the maxId and update the ID by 1 when a null is found

    SQLTestUser (12/20/2016)

    ...the new values should have the assetID incremented by 1. So something like

    Insert into TableA (AssetName,AssetID,SomeID,ActiveOrNot) Value ('some', Select MAX(AssetID) + 1, 1, True)

    Is there a reason...

    December 21, 2016 at 6:41 am

    #1919131

  • RE: Request for review of Star schema design

    There's certainly a lot to digest in that ER diagram. I have a couple of questions offhand, but they may just be my lack of understanding of the requirements...

    December 20, 2016 at 4:18 pm

    #1919058

  • RE: Copy File in SSIS using VB.NET

    For a simple file copy, since you're using Integration Services, would it make more sense to use the File System Task rather than trying to build your own in script?

    https://msdn.microsoft.com/en-us/library/ms140185.aspx

    December 20, 2016 at 12:48 pm

    #1919009

  • RE: Causing the Job to fail based on a condition

    sarwar.ali490 (12/20/2016)

    I have a package which loads a file to staging table and rename the filename.Now i am trying to work on data quality stuff.Based on the validation rules the...

    December 20, 2016 at 11:49 am

    #1918992

  • RE: TRUSTWORTHY ON to let sproc execute across Dbs

    Maxer (12/19/2016)

    I could sign the stored procedure with a cert but...that's a PITA....

    That's probably the safest option, and when you do it once, it becomes quite easy after that. ...

    December 19, 2016 at 9:57 am

    #1918722

  • RE: The Toolchain for the Job?

    Jeff Moden (12/18/2016)

    ...Now, at work, we have this $350K (not to mention a huge monthly license and support fee) monster piece of garbage that only two people know use and...

    December 19, 2016 at 9:41 am

    #1918718

Viewing 15 posts - 1,171 through 1,185 (of 1,838 total)