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...

    October 1, 2012 at 11:24 am

    #1544069

  • 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...

    September 18, 2012 at 12:11 pm

    #1539216

  • 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...

    September 18, 2012 at 11:17 am

    #1539203

  • 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????

    August 16, 2012 at 8:52 am

    #1526644

  • 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 ...

    August 6, 2012 at 12:40 pm

    #1522237

  • 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...

    August 6, 2012 at 12:01 pm

    #1522215

  • 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...

    August 3, 2012 at 1:39 pm

    #1521617

  • 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...

    August 3, 2012 at 1:35 pm

    #1521614

  • 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...

    August 3, 2012 at 1:33 pm

    #1521609

  • 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...

    August 3, 2012 at 1:31 pm

    #1521607

  • 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...

    August 3, 2012 at 1:28 pm

    #1521603

  • 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...

    August 3, 2012 at 1:25 pm

    #1521601

  • 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...

    August 3, 2012 at 10:18 am

    #1521509

  • 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...

    August 3, 2012 at 9:15 am

    #1521463

  • 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...

    August 2, 2012 at 6:28 pm

    #1521195

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