Forum Replies Created

Viewing 15 posts - 286 through 300 (of 687 total)

  • RE: Need help with a query

    Data definition scripts, sample data, and expected results would help us tremendously in assisting you with your question.

  • RE: Disaster Recovery: Rebuild system databases on SQL Server 2008 cluster

    Good real life scenario, thanks for sharing!

  • RE: E-mail Notifications of Replies to Threads You Post In

    my thread

    I asked the same question a while ago.

    The subscription type chosen on replies is saved as the default. So reply to this thread and set Topic Subscription Notification...

  • RE: Setting Color on a table's Field

    You are missing a value in your switch statement. Try this,

    switch((Fields!Neg_Total_Count.Value/Fields!Total_Count.Value*100) <= 5, "Lime",

    (Fields!Neg_Total_Count.Value/Fields!Total_Count.Value*100) <= 10, "Yellow",

    (Fields!Neg_Total_Count.Value/Fields!Total_Count.Value*100) > 10, "Red" )

  • RE: Talking baseball

    Yeah, DH... hmmm

    I guess I like it.

    Not much more to say. lol

  • RE: Dabase size question

    No real way to tell what caused the shrink but here's something that would show you if it did in fact shrink.

    SELECT TE.name AS [EventName] ,

    ...

  • RE: Sorting in SQL Server

    I knew there was a collation solution!

    Good call Jason!

  • RE: Sorting in SQL Server

    Hmmm, I'll take a stab.

    In your order by clause use a case statement. Similar to this,

    SELECT col1

    FROM tableA

    ORDER BY

    CASE

    WHEN col1 = '!' THEN

    1

    WHEN col1 = '"' THEN

    2...

  • RE: Enable a job

    here is a ms connect item with similar issues as yours. This SSC thread is what lead me to it.

  • RE: Enable a job

    Job properties-

    If enabled it can be run by a schedule. If disabled the schedule will not run the job.

    Schedule properties-

    If enabled the schedule will fire jobs that reference that...

  • RE: Talking baseball

    Pleasantly suprised to see "MLB Baseball" on my TiVo guide again. Watched a few pitches from the Nats game. ahhh, baseball.

  • RE: Sql sever 2008 advice

    ddafunk (3/5/2012)will you not advise me to get a cert to atleast show i do have knowledge of what i can do?

    That's the issues with only having a cert. A...

  • RE: Sql sever 2008 advice

    It will be a little tough getting your foot in the door but it's possible. You just need to show some gusto. Speak with an IT manager and let them...

  • RE: Sql sever 2008 advice

    I wouldn't worry about exams right now. Although the 70-432 is an exam prep book, the exam itself is meant to prove you know something and not to teach you...

  • RE: Sql sever 2008 advice

    First, welcome to the site. I hope you visit frequently, there's tons of information to be found here.

    DBA, good career choice 😀 That 70-450 book is a little advanced for...

Viewing 15 posts - 286 through 300 (of 687 total)