Viewing 15 posts - 721 through 735 (of 2,462 total)
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.
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 10, 2012 at 3:03 am
fluffydeadangel (12/5/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 7, 2012 at 1:02 am
Chris Becker (12/6/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 7, 2012 at 12:55 am
posted below
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2012 at 11:46 pm
good question
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2012 at 3:56 am
Clark Bones (12/3/2012)
How can I completely disable database mail?
see
USE msdb ;
GO
EXECUTE dbo.sysmail_stop_sp ;
GO
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 6, 2012 at 1:23 am
see this http://sqlserverplanet.com/dba/using-sp_who2
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 )
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 3:21 am
Aadhar Joshi (12/5/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 3:05 am
Viewing 15 posts - 721 through 735 (of 2,462 total)