Viewing 15 posts - 721 through 735 (of 2,463 total)
mah_j (12/10/2012)
also i think the page split would be decreased in the partition that i want to select from it.
NO , partitoning is not related with page spliting and...
December 10, 2012 at 3:06 am
rama.mathanmohan (12/10/2012)
Basically, for performance troubleshooting reasons we need to capture certain TSQL command from the Dynamics NAV2013 application, which sends the end user information as comments to the SQL server.
...
December 10, 2012 at 3:03 am
fluffydeadangel (12/5/2012)
December 7, 2012 at 1:02 am
Chris Becker (12/6/2012)
December 7, 2012 at 12:57 am
RVO (12/6/2012)
So how exactly ATTACH works?
see this http://msdn.microsoft.com/en-us/library/ms190794(v=sql.90).aspx
RVO (12/6/2012)
It creates a new database from MDF,LDF files?
NO
RVO (12/6/2012)
With stored porcedures, Users, Roles - everything?
Yes , but it will...
December 7, 2012 at 12:55 am
Clark Bones (12/3/2012)
How can I completely disable database mail?
see
USE msdb ;
GO
EXECUTE dbo.sysmail_stop_sp ;
GO
December 6, 2012 at 1:23 am
December 6, 2012 at 12:49 am
Also UAT doesnt need archived or purged data (some historical table too) .. we can obsolete those tables too (+ their indexes too )
December 5, 2012 at 5:12 am
Lowell (12/4/2012)
HEAP tables never release the space taken by deleted rows.
this is new to me ..can you give me any article reference here ?
December 5, 2012 at 5:11 am
Chris Harshman (12/4/2012)
Is there a reason you're not using IDENTITY for that id column?
then there is no guarantee that destination table will have same ID for...
December 5, 2012 at 5:07 am
Luk (12/3/2012)
the fill factor is 0 and yet the fragmentation is over 95% after recent rebuilt.
the index rebuild works on the basis of the fill factor and...
December 5, 2012 at 3:39 am
the below script can help you to see and anlalyze that which tables and indexes which are taking huge space so that you can easily check where the actual...
December 5, 2012 at 3:29 am
sqlfriends (12/4/2012)
If a database is setup to readonly.Will the log file grow or not?
thanks
NO
sqlfriends (12/4/2012)
Will the log file grow...
December 5, 2012 at 3:21 am
Viewing 15 posts - 721 through 735 (of 2,463 total)