Viewing 15 posts - 136 through 150 (of 155 total)
why you want to move the index back from the log drive if the performance is better?
February 6, 2008 at 9:58 pm
Yes Gail before asking for a new post, I wanted to know whether something has been already written. Thanks for your help!
February 6, 2008 at 4:53 am
I was wondering if someone in the community knows the implementation details.
February 6, 2008 at 3:20 am
I am looking for details on how the histograms are stored inside and how they are managed byy sql server, on a very low level.
February 6, 2008 at 2:10 am
Thanks, but I meant the storage and architecture of stats.
February 4, 2008 at 10:03 pm
Thanks Steve; I got the "Recent Posts" link and there I can get all the threads even if I miss to login for a couple of days. Thanks!
January 30, 2008 at 10:54 pm
try EXEC sp_changeobjectowner 'existing_owner .authors', 'Corporate\GeorgeW';
GO
January 30, 2008 at 12:11 am
Also, is there a way to sort the threads order by date desc, rather than the the main topics like "Administration", "Development" etc?
January 29, 2008 at 10:55 pm
GO is a transaction seperator, but it is a query window (and osql/sqlcmd) specific code.
January 27, 2008 at 10:57 pm
quoted_identifiers settings are for using reserverd keywords as object names etc. Its not for string values.
January 27, 2008 at 10:50 pm
dont think of shrinking the files unless you are sure the database will never grow again. The free space within the database is not a bad thing. So just think...
January 16, 2008 at 4:05 am
why do you need the transactional log backup of it is just a reporting server? You can just take a full backup just after you complete the data feed. Change...
January 16, 2008 at 3:30 am
I would say backup/restore if there is a huge amount of free space in the database. If the datafiles dont have much free space, go for detach/attach.You need to ensure...
January 16, 2008 at 3:24 am
dts packages will be in the msdb database.
January 16, 2008 at 3:14 am
Viewing 15 posts - 136 through 150 (of 155 total)