Forum Replies Created

Viewing 15 posts - 1 through 15 (of 23 total)

  • RE: The Quiet Zone

    130 db? I am an audio tech on the side and I have trouble imagining that level of sound. As your link says, think jet engines at close range.

    I have...

  • RE: Index usage overview

    j-1064772 (2/12/2015)


    In the meantime, just comment out the 4 lines dealing with the filegroupname, the rest works.

    That works -- thanks!

  • RE: Index usage overview

    I just tried your script and it works for smaller databases but fails on any of our large (and heavily fragmented) production databases with

    Msg 220, Level 16, State 1,...

  • RE: Developing with SQL Server – What must a beginner know?

    One issue I have encountered quite a bit recently is with the ability to think and write in non-procedural languages and to employ functional programming techniques. Thinking procedurally and state-wise...

  • RE: Cursor-Killing: Accessing Data in the Next Row

    Yikes, it would never even occur to me to use a cursor in that situation (but I know there are those that do). I have always used a self-join. Pre-2005,...

  • RE: The SQLCLR Impact

    At one time I used a CLR string aggregator (catenate with commas between) with code taken from the SQL Server developer samples, and for a while I used an open...

  • RE: How Often Do I Backup my Log?

    "Tolerance for being yelled at" is a great way to put it. I can't think of a better one.

    If the data is financial transactions, event registrations, or something else where...

  • RE: Oddball Interview Questions

    Miles Neale (2/7/2014)


    ...If we give some wisecrack as a response, the potential employer might see us as arrogant and a non-team player.

    Or just not serious about the position....

  • RE: Oddball Interview Questions

    Too much time in T-SQL. My straight answer is "I wouldn't -- it's not a practical tool for that job."

    There is a distinct possibility that a question like that is...

  • RE: Oddball Interview Questions

    I have encountered some "interesting" behavioral interviewing questions, but nothing quite like these examples. When I see job requirements or interview questions that just don't seem right, that's a yellow...

  • RE: Database User Superfluousness In SQL Server

    mauriciorpp (2/4/2014)


    @Megan, in that situation I usually take advantage of the SID property: I copy the login from Prod to Dev servers, changing the password on Dev. Whenever we need...

  • RE: Database User Superfluousness In SQL Server

    mauriciorpp (2/4/2014)


    ..if we restore a DB to a distinct server, how can we handle the permissions if we get rid of "users"? I mean, if all we have is a...

  • RE: Stunned

    If the remark had come from a political figure, many of us would get it right away. Is there any reason to think that such people don't exist wihin other...

  • RE: Upgrading to 2012

    I have been using SQL Server 2012 in production since SP1 was released. We are a small organization, however, and it is easier to make changes. My main motivation for...

  • RE: Activity Monitor - % Processor Time Grayed Out

    adejola.oyetti (6/29/2011)


    Activity Monitor does %Processor Time greyed.

    On SQL SERVER 2008 servers

    Fix

    On the host to the sql server instance.

    Go my Start -> Right click Computer , select Manage....

Viewing 15 posts - 1 through 15 (of 23 total)