Forum Replies Created

Viewing 15 posts - 406 through 420 (of 1,129 total)

  • RE: Performance Issue !!!!

    mahesh.dasoni (10/1/2012)


    I have a 64 bit windows server 2003 OS and SQL Server 2005 Standard Edition 32 bit.

    Is it possible to enable AWE on the SQL Server as we are...

  • RE: How to speed up backup process.

    One thing i have heard from one of the well know MVP's is that if you re-org your indices and then take a backup it might save some time and...

  • RE: Update Stats with full scan on all tables in all databases

    My two cents. If you are looking for something to run in parallel across all databases, you could either use Red Gate multiscript tool ( worth every penny for this...

  • RE: good way to identify when was sql server installed?

    Joy Smith San (8/16/2012)


    Is create data for Master DB is older than the Server date ?

    Yes Masterdb create date is Older than server date..why????

  • RE: SQL Server Login/Logout Audit

    Lowell (8/6/2012)


    my fault; in 2008 this line raises an error:

    I updated the script to correct the issue.

    exec sp_trace_setfilter @traceidout,12,0,4, 50 ...

  • RE: SQL Server Login/Logout Audit

    Lowell (8/3/2012)


    Id say that a server side trace has an incedibly small footprint because its not capturing much; plus you get better tracing than watxhing a dmv and infering a...

  • RE: Password Manager

    Sean Lange (8/3/2012)


    Well I don't know how the other work but KeePass is a client application. It can open a data file from anywhere. So you would install the client...

  • RE: view different msdb data from GUI

    Sean Lange (8/3/2012)


    sqldba_newbie (8/3/2012)


    Sean Lange (8/3/2012)


    You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of...

  • RE: Password Manager

    Sean Lange (8/3/2012)


    sqldba_newbie (8/3/2012)


    Sean Lange (8/3/2012)


    sqldba_newbie (8/3/2012)


    Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on...

  • RE: objects never being used -?

    durai nagarajan (8/3/2012)


    DMV and data are different.

    Data will be definitely the same , hope the dmv data will differ based on server and db.

    I didn't quite understand your response. I...

  • RE: view different msdb data from GUI

    Sean Lange (8/3/2012)


    You should be able to view just about anything in there. I would assume you named it something different than msdb? Is this more of a "is it...

  • RE: Password Manager

    Sean Lange (8/3/2012)


    sqldba_newbie (8/3/2012)


    Just wanted to know what do other DBA's use to manage passwords of SVC account. I should be able to install this tool on a windows server.

    I...

  • RE: SQL Server Login/Logout Audit

    Lowell (8/3/2012)


    the advantage of the procedure is if i decide i want one running all the time, i can set the procedure to execute on server startup, so the trace...

  • RE: SQL Server Login/Logout Audit

    anthony.green (8/3/2012)


    Profiler or a trace for the audit logout event.

    Or build a custom script which checks sys.dm_exec_sessions for a spid and username and run it every so oftern, when it...

  • RE: objects never being used -?

    Lowell (8/2/2012)


    Reverse the order of the tables isnmy recommendation.

    Select from sys.tables where not exists in then dmv isnthe way ive done it.

    Does the dmv depend on metadata local to server...

Viewing 15 posts - 406 through 420 (of 1,129 total)