Forum Replies Created

Viewing 15 posts - 121 through 135 (of 644 total)

  • RE: LOCK TABLE PROBLEM

    pallab.santra1987 (1/24/2013)

    For SQL Server 2008:

    What is the procedure to delete some data from Lock Table?

    We can't use NOLOCK for Update, delete & Insert for that.

    A table Name like Business_History which...

    January 24, 2013 at 4:02 am

    #1580458

  • RE: Finding the size of databse at Server level

    Shadab Shah (1/24/2013)

    Antony,

    Is there any easy way to traverse throught all the database. Because i am finding the above query a little bit of difficcult to understand.

    Might be this is...

    January 24, 2013 at 3:53 am

    #1580455

  • RE: Can a Table Really Have a Clustered Index?

    Dennis Q Miller (12/26/2012)

    To say a table "is" a clustered index is specious, at best. I suppose you might approximate truth by saying the table "is" the leaf nodes...

    December 26, 2012 at 5:54 am

    #1571542

  • RE: How to check license information

    GilaMonster (12/18/2012)

    SQL doesn't keep track of how it's licenced, that's paperwork. (other than SQL 2012 in one case)

    As for server name, version and edition, have a look at the MAP...

    December 18, 2012 at 5:02 am

    #1569489

  • RE: Server Hangs

    Gazareth (12/6/2012)

    Have you configured max server memory in SQL Server?

    SQL loads data into RAM and will use as much memory as you allow it to.

    +1

    You must configure the min. &...

    December 6, 2012 at 4:24 am

    #1566086

  • RE: Backup failing

    Joie Andrew (12/5/2012)

    Hemant.R (12/5/2012)

    --------------------------------------------------------------------------------

    but if you are running maintainance plan for backup job then it is necessary that intergartion service in running state .

    if it not started then your job...

    December 5, 2012 at 6:04 am

    #1565703

  • RE: Backup failing

    Hemant.R (12/5/2012)

    but if you are running maintainance plan for backup job then it is necessary that intergartion service in running state .

    if it not started then your job will...

    December 5, 2012 at 5:23 am

    #1565690

  • RE: Memory utilization by a single sqlserver instance alone.

    Mithra (11/30/2012)

    Team,

    Is there any way to find how much how much memory the single sqlserver instance is actually using in the node? I can see the max memory allocated...

    December 3, 2012 at 4:25 am

    #1564796

  • RE: Back to Basics: Capturing Baselines on Production SQL Servers

    Thanks a lot Erin for writing such a nice article :-). It provides much more than we could have asked!

    November 27, 2012 at 7:24 am

    #1562673

  • RE: Isolation Levels

    Very good question. I am surprised that more than 60% got this wrong!

    November 21, 2012 at 4:16 am

    #1561180

  • RE: 5 Reasons You Must Start Capturing Baseline Data

    Very nice article Erin. Glad to see an article on such an important topic. Hope this will be a great series.

    November 19, 2012 at 4:27 am

    #1560273

  • RE: Halloween Protection

    Nice interesting question Steve:-)

    October 31, 2012 at 6:53 am

    #1554578

  • RE: STR

    Very well explained Hugo 🙂

    October 18, 2012 at 4:24 am

    #1550386

  • RE: STR

    L' Eomot Inversé (10/18/2012)

    Good question

    But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested by...

    October 18, 2012 at 3:59 am

    #1550370

  • RE: STR

    Hugo Kornelis (10/18/2012)

    I knew about the STR function, but was not entirely sure what the optional arguments meant, so I decided to check Books Online before answering.

    I must say that...

    October 18, 2012 at 3:38 am

    #1550356

Viewing 15 posts - 121 through 135 (of 644 total)