Forum Replies Created

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

  • RE: Launch SSMS from command prompt

    use the entire path when trying to call 2012 ssms

    "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

    Jason, Thanks. It is working.

    If you wanted to have the 2012 SSMS open with just ssms.exe you...

    October 4, 2013 at 1:43 am

    #1655763

  • RE: Experiment in High Availability

    Dhananjay-440114 (9/24/2013)

    Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..:-)

    Thanks Dhananjay. Let me search. 🙂

    October 2, 2013 at 11:19 am

    #1655284

  • RE: Ignore Error in T-SQL

    No you can't simply ignore errors like vb used to do. The closest you can get is the example posted above. 🙂

    Ok Sean, Thanks.

    October 2, 2013 at 11:09 am

    #1655281

  • RE: Ignore Error in T-SQL

    Sean LangeI hope your code is just for an example of how to force an error because a loop is not very efficient in sql.

    Yes, An example

    Cadavre

    I can't think...

    September 24, 2013 at 8:44 am

    #1652782

  • RE: Experiment in High Availability

    Virtual machines. No additional hardware necessary.

    Thanks Gail

    September 24, 2013 at 8:07 am

    #1652748

  • RE: Experiment in High Availability

    Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.

    Thanks, have read that...

    September 21, 2013 at 2:35 am

    #1652118

  • RE: Path to a Database Architect

    LOL 🙂

    Thanks Jeff.

    Usually when I think something about database; the first thing is coming to picture is SQL Server Central. Then, Google. I already tried this. Got some introductions.

    Shaiju...

    September 8, 2013 at 7:31 am

    #1648383

  • RE: Path to a Database Architect

    It's a low-level certification that tests basic database design concepts.

    Oh.. Ok. Thanks Gail.

    September 7, 2013 at 7:57 am

    #1648334

  • RE: Path to a Database Architect

    Hi All,

    What about this 2012 certification?

    Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

    September 7, 2013 at 12:36 am

    #1648289

  • RE: Path to a Database Architect

    Thank you guys,

    In short, we need to know everything about SQL and related to SQL. Even if we know everything, doubts are there from where I need to start my...

    September 5, 2013 at 9:54 am

    #1647775

  • RE: urgent help with stored procedure performance tuning

    Neeraj Prasad Shama

    BLOG : Sql Server Tutorials

    Neeraj Prasad Sharma

    Sql Server Tutorials

    Hi Neeraj,

    The link (Sql Server Tutorials) is not working for me

    July 31, 2013 at 11:54 pm

    #1637651

  • RE: plz i need help!!!!

    Correct. In the first post he wants NULL and 2nd post 0 or Nothing (NULL). Thought he might be doing something with NULL. That's why I posted that script as...

    January 28, 2013 at 11:07 pm

    #1581893

  • RE: plz i need help!!!!

    Yes Jeff,

    I had that thing in my mind. But in the first post he wants "result with a null value". I should have post both the scripts 😀

    Thanks Jeff

    almany_13...

    January 28, 2013 at 8:34 am

    #1581660

  • RE: plz i need help!!!!

    almany_13 (1/27/2013)

    Did not understand the question properly. But can you please try the below script.

    SELECT name, (CASE WHEN(salary) <= 0 THEN NULL ELSE salary END)

    + (CASE...

    January 27, 2013 at 11:21 pm

    #1581415

  • RE: Scalability v/s High Availability

    okbangas (6/21/2012)

    Scalability: Solutions used for adapting to higher load.

    Availability: Solutions used to reduce downtime.

    Scalability: More hardware, Replication, Always On (SQL Server 2012), Service Broker, to some content Database Mirroring.

    Availability: Clustering,...

    June 21, 2012 at 4:04 am

    #1503846

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