Forum Replies Created

Viewing 15 posts - 16 through 30 (of 153 total)

  • RE: SPROC Stored Proc vs SSIS for Enterprise Wide Dev

    Eric M Russell - Monday, February 13, 2017 2:22 PM

    For bulk importing data, I'd use SSIS over a stored procedure. If a...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: How does SQL Server host communicate with Client - what ports on both machines?

    anthony.green (11/17/2015)


    The client uses the RPC port range, so anything between TCP 1024 and 65535 to communicate to SQL on, its random as it depends what ports are already in...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Auto deployment of SQL scripts

    anthony.green (10/20/2015)


    The client I'm working with at the moment want to streamline some of their processes and try to automate where possible.

    One of the main tickets that gets raised is...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Development Environment for Linux Developers accessing SQL Server

    Orlando Colamatteo (9/19/2015)


    sqlsurfing (9/18/2015)


    Hi I wanted to ask what do 'other' organizations do from an infrastructure and workstation setup look like for staff

    that develop Java code in IDE on...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Addressing parameterized queries in SQL SERVER DATABASE AUDIT for HIPAA / SOX / PCI ?

    Grant Fritchey (10/9/2015)


    To my knowledge SQL Audit will capture ad hoc queries, parameterized queries and stored procedures. It just doesn't keep the values that are passed to parameters. This is...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Microsoft SQL Server 2012 SP2 - 11.0.5343 hot fix apply error.

    Check the bootstrap logs, I believe during installation more detailed logs are written there.

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Query performance

    Maybe Server one is slow because it's sharing bandwidth with other databases? or if it's on a SAN perhaps it's gotten slower. Is it on a different SAN storage system?...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Opinion on automated Deployment to Production

    Manic Star (8/6/2015)


    Can be useful if done correctly.

    Test it to a staging environment first and make sure you're aware of all the gotchas and caveats the system introduces.

    Thanks for...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: IOPS Provisioning in AWS

    Michelle-138172 (7/30/2015)


    I'm green on the storage system, so bear with me. I have a production SQL Server that has a lot of writes and reads. If I want to accommodate...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: SQL Server Idle Time

    Jeff Moden (3/11/2015)


    One of the things I have running is a PerfMon that takes a sample every 15 minutes. I use PerfMon because I'm still currently stuck in the...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: High CPU usage

    jitendra.padhiyar (3/11/2015)


    Hello Masters,

    One my SQL Server (SQL 2008 R2) throwing High CPU utilization alerts. I checked and found that SQL server consuming almost 89% to 90% of CPU usage.

    Current...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: EMC XtremeIO

    SQLJocky (3/11/2015)


    Has anyone had any experience with EMC's XtremeIO product? We're getting ready to implement one of their four brick SAN's and it looks like it's going to be...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Super long running queries (bad users)

    Eric M Russell (2/13/2015)


    It sounds like in your case the users are actually working for external clients, so unfortunately you're in a position where both you and your managers have...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Remote access to SQL database

    mister.magoo (1/31/2015)


    That sounds an awful lot like you have this server sat "on the internet", so please make sure you don't open the firewall!

    Also, it sounds like you are trying...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

  • RE: Remote access to SQL database

    Lee Savidge (1/30/2015)


    Hi,

    I have SQL Management Studio installed on my local computer. What I would like is to allow someone to connect to the VPN so that they have access...

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

Viewing 15 posts - 16 through 30 (of 153 total)