Forum Replies Created

Viewing 15 posts - 46 through 60 (of 208 total)

  • RE: Help needed on Log Shipping scenario

    Hi Michelle,

    Well - you do sound like you're going to be in for an interesting ride!

    Can you log-ship from 3 separate servers...

  • RE: Actual file size

    Guus,

    I use the following SP which I found on a forum some time ago. It relies on the data in the msdb..backupfile table, which is updated each time a...

  • RE: running SQL commands from .bat file

    Yes, use the OSQL command

    e.g.

    osql -S servername -E -i sql_script.sql -o outputfile.txt

    -S = servername

    -E = Windows authentication (trusted)

    [-U = SQLServer username]

    [-P = SQLServer password]

    -i = SQL commands input...

  • RE: Performance - too many indexes

    Couldn't agree more. On Colin's recommendation a while ago, I went to one of Kimberley's seminars in Reading. Brilliant, absolutely brilliant! I've always prided myself on understanding...

  • RE: DBCC INDEXDEFRAG

    Just to reinforce the importance of the ORDER BY clause ...

    Even with the same query plan, there is NO guarantee that results will come out in the same order every...

  • RE: I/O Separation

    If you're using local disks, then I agree that object placement can offer real benefits.

    I start to doubt the effectiveness of file placement once you start working with striped disks...

  • RE: Can we bring a Sybase Database offline?

    Well, I think my first suggestion should work, shouldn't it? Doesn't involve touching system catalogs.

  • RE: Limit TempDB tables "by user"

    Don't forget, also, that tempdb is used by the optimizer for creating intermediate join tables, sort tables, hash tables etc whilst a query is executing, even if that query does...

  • RE: Can we bring a Sybase Database offline?

    Yes, that should work - I was trying to offer a solution that didn't involve messing around with system catalogs!

  • RE: find databse size tsql

    Depends on exactly what size information you want ...

    sp_helpfile will give you the individual sizes of each file that makes up the database.

    sp_helpdb will display the TOTAL size of all...

  • RE: Question on sysindexes

    Warwick,

    The ID column is the object_id of the table itself, not the indexes. The INDID column holds the unique value for the index.

    Since all your indexes are created on...

  • RE: Finding # of Physical Processors

    Not that I've ever found. Hyperthreading is a real pain when it comes to licensing - even the Windows information makes it look like you've got twice as many...

  • RE: sp_detach_db works, re-attaching it doesn''''t!

    Yeah, you're right - I'm thinking in SQL2K5 mode!

    I've just tried the detach/re-attach method, and it works for me (just as it does in your test environment).

    You can't delete the...

  • RE: Log Shipping Transaction log copy and load fails.

    If you can't physically copy the tranlog files to the 2ary machine, then there could be any number of problems. You should not require additional ports to be opened,...

Viewing 15 posts - 46 through 60 (of 208 total)