network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 9 months |
| seen | Apr 17 at 15:10 | |
| stats | profile views | 10 |
|
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 |
|
Sep 14 |
answered | Necessary to use a checksum on a backup and not solely the 'verify backup' option? |
