Forum Replies Created

Viewing 15 posts - 1,066 through 1,080 (of 13,460 total)

  • RE: Can a peoplesoft database developer be a data analyst?

    I'm always confused about what a data analyst title really covers as well, i tend to think of it as using statistics to find both trends and outliers, maybe with...

    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!

    May 6, 2016 at 7:24 am

    #1877131

  • RE: Corrupt Record - Non-relational database Structure

    wow that's an interesting puzzle.

    so is the varbinary string stored as a string datatype, or is it a varbinary(max)?

    for a solution , we need the datatype as it is stored...

    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!

    May 6, 2016 at 6:56 am

    #1877116

  • RE: Please provide t-sql script SQL queries Executed from last 24 hours with Data and time stamp

    unless you have an extended event or audit already in place, you cannot capture that data; SQL executes a query and throws it away, but it might save the plan(the...

    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!

    May 6, 2016 at 6:27 am

    #1877096

  • RE: Beginner Help

    for a sandbox, My labs exist in either VirtualBox or VMWare; i have both installed on my beefy laptop. VirtualBox even has a portable edition, so you can keep them...

    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!

    May 6, 2016 at 6:08 am

    #1877087

  • RE: Query to compare user in application and AD

    is the CAC card number in table anyplace, or can it be used to get CACNumber +email, so it can be joined to your ADObj table?

    your snippet was incomplete/not syntactically...

    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!

    May 5, 2016 at 12:11 pm

    #1876942

  • RE: Beginner Help

    also SQLServercentral is an awesome resource, besides the Stairways Series , and free ebooks,

    read these forums.

    a lot of us go to a bit of trouble to make sure there...

    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!

    May 5, 2016 at 9:56 am

    #1876900

  • RE: SSIS download

    Danny987654 (5/5/2016)

    Thanks for the responses.

    I have installed the tools on my workstation but this was from the free version. I assume the developer edition is one we would need 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!

    May 5, 2016 at 8:31 am

    #1876866

  • RE: SSIS Error handling using Script Task

    this link has a couple of screenshots and an explanation that can help:

    http://stackoverflow.com/questions/5772667/how-to-create-an-error-log-or-custom-error-log-within-an-ssis-package

    basically, SSIS has a built in error logging mechanism, and you can have it write to one or...

    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!

    May 5, 2016 at 6:45 am

    #1876810

  • RE: Compare two databases

    Redgates tools are awesome, i ponied up and bought them for myself, but they are expensive.

    on a cheaper note, if you've installed SSDT, you can easily use the built 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!

    May 5, 2016 at 6:13 am

    #1876803

  • RE: SSIS download

    I see you posted in SQL2008, you need to install the tools like SSMS and BIDS on your workstation from some production media, or from a 2008/R2 developer editions...

    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!

    May 5, 2016 at 5:57 am

    #1876802

  • RE: SSIS Job Proxy Best Practise

    i'm pretty close to Jez's methodology; i've pretty much had one specific account for 90% of my proxy situations; it's mostly about accessing network resources. i tend to use that...

    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!

    May 5, 2016 at 5:43 am

    #1876799

  • RE: Help with select statement when WHEN Clause involving multiple databases

    you probably need to simply join three groups of data together to create your view; it might be slow;

    CREATE VIEW vwGeneralTransactionsMultiSite

    AS

    SELECT T1.Site,

    T1.Trans_num,

    ...

    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!

    May 5, 2016 at 5:27 am

    #1876795

  • RE: How to show CAPS lock status in Management Studio status bar?

    my keyboard has a light to signify caps lock on or off, isn't that significantly easier than asking for one specific application to show it's status? just glance 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!

    May 4, 2016 at 2:16 pm

    #1876727

  • RE: xp_cmdshell not working for users

    carol can you simpyl test your users xp_cmdshell permissions? does this still give permissions errors?

    EXECUTE AS USER='pvtreader' --test as our specific users permissions.

    exec xp_cmdshell 'whoami'

    REVERT; --change back into myself

    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!

    May 4, 2016 at 1:23 pm

    #1876718

  • RE: DB Maintenance Plan - SQL Server Agent job failing due to incompatible version??

    I think the issue is you developed/created the package in a higher version of BIDs (or potentially 2012/2013 SSDT), right?

    Pretty sure you created it in Visual Studio 2010, but the...

    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!

    May 4, 2016 at 9:58 am

    #1876656

Viewing 15 posts - 1,066 through 1,080 (of 13,460 total)