Forum Replies Created

Viewing 15 posts - 91 through 105 (of 162 total)

  • RE: Memory Utilization

    Checkout the sys.dm_os_memory_xx dmv's - there should be something in there you're after.

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    April 7, 2012 at 9:57 am

    #1470402

  • RE: Get the course which has maximum no.of students enrolled

    could use something like this...?

    SELECT TOP 1 c.cid

    ,c.cname

    ,COUNT(*) AS [Number_Of_Students]

    FROM course c

    INNER JOIN enroll e

    ON c.cid = e.cid

    GROUP BY c.cid, c.cname

    ORDER BY Number_Of_Students DESC

    the problem with this...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    April 2, 2012 at 3:15 am

    #1467525

  • RE: SQL2000 to SQL2008R2 Migration

    I believe there is a deprecated feature check. I can't remember if it is on the installation disk or not but one does exist - run that and it...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    April 2, 2012 at 1:41 am

    #1467500

  • RE: Using WAITFOR Time

    Gabe T. (3/12/2012)

    Hi All,

    For some QA of a project, I've been asked to generate some CSV files for a single day (i.e. not on a regular basis) that they would...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    March 13, 2012 at 4:18 am

    #1458374

  • RE: Triggers to be avoided? ....

    Eugene Elutin (3/1/2012)

    Loundy (3/1/2012)

    I've yet to find a use for triggers if i'm honest (there will be some use for them in the future im sure)

    If i'm not mistaken (someone...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    March 1, 2012 at 4:04 am

    #1453533

  • RE: Triggers to be avoided? ....

    I've yet to find a use for triggers if i'm honest (there will be some use for them in the future im sure)

    If i'm not mistaken (someone will correct me...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    March 1, 2012 at 3:53 am

    #1453526

  • RE: Central Management Server with Policy Based Management

    Ok - so i tried the following and still nothing showing in CMS....

    Imported a policy from within the cms which deployed fine to all registered servers

    Thought it might be to...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 28, 2012 at 10:24 am

    #1452721

  • RE: Central Management Server with Policy Based Management

    This is a duplicate post - i've reposted this in the general forum - please do not reply to this thread.

    Sorry 🙂

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 28, 2012 at 6:37 am

    #1452552

  • RE: AFTER INSERT Trigger not firing

    lucchesediego (2/27/2012)

    I have a Table named DATAFEED in my DB that receives info every minute through a JAVA app and I need that info inserted to another table, so I...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 27, 2012 at 3:33 am

    #1451957

  • RE: Multi Search

    Full text Indexing perhaps?

    http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 27, 2012 at 1:45 am

    #1451921

  • RE: Intellisense Not working..

    Grant Fritchey (2/24/2012)

    Loundy (2/24/2012)

    sqlzealot-81 (2/23/2012)

    Try re-registering TextMgrP.dll.

    This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"

    Also, If you have a 3rd party IntelliSense...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 24, 2012 at 5:39 am

    #1451335

  • RE: wait type PREEMPTIVE_OS_REVERTTOSELF

    sqlzealot-81 (2/24/2012)

    Hi Experts,

    Any one has any idea about "PREEMPTIVE_OS_REVERTTOSELF" wait type. Appreciate any heads up..

    wait types:

    http://sqlblogcasts.com/blogs/christian/archive/2008/06/06/new-sql-server-2008-wait-types-preemptive-and-ft.aspx

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 24, 2012 at 5:38 am

    #1451334

  • RE: Insert the deleted record in another Tables

    Gianluca Sartori (2/24/2012)

    If I understand correctly, this should do:

    -- CREATE A TABLE FOR TESTING

    CREATE TABLE testTab (

    cd varchar(max),

    someColumn varchar(max)

    )

    GO

    -- INSERT SOME TEST...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 24, 2012 at 4:51 am

    #1451314

  • RE: Intellisense Not working..

    sqlzealot-81 (2/23/2012)

    Try re-registering TextMgrP.dll.

    This has helped me in the past: Full command line - regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\TextMgrP.dll"

    Also, If you have a 3rd party IntelliSense installed (such as...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 24, 2012 at 2:25 am

    #1451243

  • RE: script

    anthony.green (2/24/2012)

    sp_msforeachdb 'USE [?];

    select

    DatabaseName = DB_NAME() ,

    CollectionDate = CONVERT(DATE,GETDATE()),

    a.FILEID,

    [FILE_SIZE_MB] =

    convert(decimal(12,2),round(a.size/128.000,2)),

    [SPACE_USED_MB] =

    convert(decimal(12,2),round(fileproperty(a.name,''SpaceUsed'')/128.000,2)),

    [FREE_SPACE_MB] =

    convert(decimal(12,2),round((a.size-fileproperty(a.name,''SpaceUsed''))/128.000,2)) ,

    a.NAME,

    a.FILENAME

    from

    dbo.sysfiles a'

    This is a nice script bud - cheers for this 🙂

    [font="Times New Roman"]There's no kill switch on awesome![/font]

    February 24, 2012 at 2:12 am

    #1451234

Viewing 15 posts - 91 through 105 (of 162 total)