Viewing 15 posts - 46 through 60 (of 208 total)
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...
November 9, 2006 at 8:35 am
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...
November 9, 2006 at 7:36 am
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...
November 3, 2006 at 5:17 am
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...
November 2, 2006 at 7:31 am
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...
November 2, 2006 at 6:02 am
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...
November 2, 2006 at 5:53 am
Well, I think my first suggestion should work, shouldn't it? Doesn't involve touching system catalogs.
November 1, 2006 at 10:24 am
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...
October 30, 2006 at 6:45 am
Yes, that should work - I was trying to offer a solution that didn't involve messing around with system catalogs!
October 30, 2006 at 5:30 am
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...
October 30, 2006 at 5:28 am
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...
October 30, 2006 at 5:17 am
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...
October 27, 2006 at 4:27 am
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...
October 26, 2006 at 5:08 am
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,...
October 26, 2006 at 4:26 am
Viewing 15 posts - 46 through 60 (of 208 total)