190 reputation
4
bio website
location
age
visits member for 2 years, 1 month
seen 12 hours ago

Oct
25
comment Post replication powershell script - on subscriber
Yes. Snapshot replication will execute and then stop, whereas transactional replication will not stop executing (as it will continue to apply transactions on the remote server). Or are you just refering to the you needing to run processes before and after the snapshot (or if the replication job fails)?
Oct
24
awarded  Commentator
Oct
24
comment How to display differential backup date in SSMS Object Explorer Details
There is no way to do this that I am aware of. I use PowerShell to get this information.
Oct
24
comment Post replication powershell script - on subscriber
This is snapshot replication I take it? If that's the case then why not schedule a step after replication that uses SQLCMD or Invoke-SQLCmd to run exec sp_start_job on the remote server?
Oct
24
comment tempdb thrashing and mirroring permissions (SQL Server)
There should not be any relationship between the two, but it's worth eliminating that error anyway. Is mirroring meant to be setup between two servers? If not, disable the mirroring attempt on the remote server. If so then grant connection on that tcp endpoint to the login.
Oct
16
answered TSQL query for viewing start/end of all SQL Agent jobs yesterday
Oct
15
answered SQL Server 2008 R2 Remote Connection issue
Oct
15
comment Multi-Table Join to Single Destination
Just out of curiosity, did you appropriately index the columns on the destination and source tables for the second version that you are attempting to run? That could easily make up the huge time difference.
Sep
21
awarded  Supporter
Sep
21
comment When restoring a SQL Server DB from dump files on a remote NAS share, copy before restore or restore directly?
Network stability and speed truly are the differentiators here. I backup all of my databases across the network, but those are all on 10Gb pipes. You might consider copying the file across if you are using a slower network as there are copy optimizations done with threading in Robocpoy. As always your mileage may vary, so I would recommend testing with various sizes of databases.
Sep
21
comment Does a change in a query executed with sp_executesql cause recompilations?
I believe it is because of the variation in your queries. Every time a query changes (even just the whitespace) then it needs to be recompiled. I would recommend reading Conor Cunningham's post blogs.msdn.com/b/conor_cunningham_msft/archive/2009/05/18/…
Sep
20
comment Does a change in a query executed with sp_executesql cause recompilations?
Any possible changes in the underlying table schema at all? Would it be possible to post the code for the proc (anonamyzing object names)?
Sep
20
comment Does a change in a query executed with sp_executesql cause recompilations?
Your EventSubClass column indicates that there was a schema change and that caused the recompile. This leads me to think you might be using # temp tables. Can you confirm this?
Sep
20
comment Does a change in a query executed with sp_executesql cause recompilations?
Here's a basic look into items in the cache SELECT TOP 100 ISNULL(DB_NAME(dbid), 'ResourceDB') , objectid , usecounts , cacheobjtype , objtype , TEXT AS SQL FROM sys.dm_exec_cached_plans decp CROSS APPLY sys.dm_exec_sql_text(plan_handle) dest ORDER BY usecounts DESC;
Sep
20
comment Does a change in a query executed with sp_executesql cause recompilations?
Do you know if the plan stays in cache between executions?
Sep
20
answered Does a change in a query executed with sp_executesql cause recompilations?
Sep
19
comment Not able to install any piece of SQL server 2012 dev edition on my windows 7
Can you verify that PowerShell is correctly installed on Windows and that you have also installed the .Net 3.5 framework?
Sep
18
comment MDF and LDF contents in SQL Server
Even in simple recovery you could have in flight transactions that would impact things (or as I mentioned replication/CDC etc)
Sep
17
answered MDF and LDF contents in SQL Server
Sep
14
awarded  Teacher