Reputation
403
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 4 13
Newest
 Yearling
Impact
~41k people reached

  • 0 posts edited
  • 3 helpful flags
  • 18 votes cast
Apr
14
revised Grant Windows logins to read a secondary database of log shipping?
added 65 characters in body
Apr
14
awarded  Yearling
Apr
14
asked Grant Windows logins to read a secondary database of log shipping?
Mar
24
accepted Delayed transactional replication setup?
Mar
24
asked Delayed transactional replication setup?
Mar
3
accepted Database which was set up for logshipping is dropped
Mar
3
comment Database which was set up for logshipping is dropped
There are two jobs: LSAlert_ServerName and LSBackup_DBName. Is it safe manually remove both if there is no logshipping set on the server? Or LSAlert_Server should be kept if there are other logshipping on the server?
Mar
3
comment Database which was set up for logshipping is dropped
Thanks. It seems a couple of jobs were created in the SQL Agent. Should these jobs be removed manually? Or anything else need to be done for removing these jobs?
Mar
2
asked Database which was set up for logshipping is dropped
Feb
24
awarded  Curious
Feb
23
revised Is it good to save tempdb and log files in one drive?
deleted 1 character in body
Feb
23
asked Is it good to save tempdb and log files in one drive?
Feb
2
comment Why the simple insert into query allocated a lot of tempdb?
Actually it used hash join. I guess the tempdb allocation was required by previous SQL in the session. (There were multiple SQL statements in the query window)
Feb
1
comment Why the simple insert into query allocated a lot of tempdb?
@SeanGallardy Yes, it uses merge join. However, considering the small size of the table, why it uses so many tempdb? What's the unit of tempdb_allocations btw?
Feb
1
asked Why the simple insert into query allocated a lot of tempdb?
Jan
29
awarded  Popular Question
Jan
23
accepted Database cannot be opened. It is in the middle of a restore?
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
Thanks. I was trying to check if there is any perfect solution which doesn't have the problem of log shipping killing running query when restoring and can be over FTP.
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
ftp, PowerShell, C#, etc., still need to work with something that tracks the changes in SQL server?
Jan
23
comment Database cannot be opened. It is in the middle of a restore?
Curiously, what's other options (inside or outside of SQL server)? Can merge replication do this?