Viewing 15 posts - 301 through 315 (of 1,068 total)
My recommendation is, test the different approaches in a test servers. Finally select one of them which suits your environment.
March 8, 2012 at 10:04 am
iamsam.sandeep (3/7/2012)
.... i ran the Re index on the database how ever the high fragmentation is still there. .
How big is this table? If the table is too small, defrag...
March 8, 2012 at 12:57 am
charipg (3/6/2012)
...Can we allocate resources to particular dB’s, if not what is the best part to take care of imp dB’s .
No, it is not possible to reserve memory...
March 7, 2012 at 10:43 pm
sqldba_newbie (3/6/2012)
...My question is i populated all this data into a table, .... How do i do the same with the second option?
sys.dm_exec_query_plan DMV gives cached plans in XML format....
March 7, 2012 at 9:34 pm
I believe your database is in FULL recovery model.
Until you take log backup, transactions remain in the log and file keeps growing.
Short term solution:
1) Take t-log backup
2) Shrink the log...
March 7, 2012 at 9:07 pm
DBCC INPUTBUFFER(118)
is the quick and easy way to see the query run by SPID 118
After that you can run the following for more details:
SELECT er.session_id ,
host_name , program_name , original_login_name...
March 6, 2012 at 9:47 pm
Try this:
SQLCMD -S CONTOSOWXP01\SQLEXPRESS -Q "CREATE LOGIN [NewUser] WITH PASSWORD = 'password', DEFAULT_DATABASE=[Mydatabase], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF"
March 5, 2012 at 2:22 am
Is your ALTER TABLE command running from SPID 97?
It is blocked by SPID 118
Check what SPID 118 is doing.
March 2, 2012 at 8:46 am
Run this while schema change is going on:
select session_id, start_time, status, blocking_session_id, wait_type, wait_resource, wait_time
from sys.dm_exec_requests
where session_id = <spid>
March 1, 2012 at 11:49 pm
Are you doing schema changes using UI (user interface)?
If yes, I suggest, do the changes using SQL commands. It is much faster because, UI internally drops and recreates the table.
March 1, 2012 at 10:16 pm
1) Run the following (with your database and publication name):
USE <Database>
GO
EXEC sp_changepublication
@publication = 'MainPub',
@property = N'allow_anonymous',
@value = 'false'
GO
EXEC sp_changepublication
@publication = 'MainPub',
@property = N'immediate_sync',
@value = 'false'
GO
2) Add new article to the...
March 1, 2012 at 9:44 pm
arr.nagaraj (2/28/2012)
March 1, 2012 at 4:52 am
sqldba_newbie (2/27/2012)
...Apart from getting new articles, would it also capture schema changes for an existing article?
I believe it creates "snapshot" of only the new articles.
I believe it does NOT consider...
February 29, 2012 at 8:47 am
Peter D-251663 (2/5/2012)
What are my options other than grant dbo and admin roles?
db_ddladmin database role.
Peter D-251663 (2/5/2012)
Can a custom role be made for both requirements?
Yes
February 5, 2012 at 10:36 pm
Run PerfMon and monitor your server. If the Buffer Catche Hit Ratio is higher, your application is getting the data from memory.
If it is lower, you have to take steps...
February 5, 2012 at 9:45 pm
Viewing 15 posts - 301 through 315 (of 1,068 total)