Viewing 15 posts - 7,621 through 7,635 (of 49,571 total)
Stamey (10/3/2014)
Here are three images. Is this what you need?
No, or I'd have asked for pictures of the deadlock graph 😉
https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
October 3, 2014 at 5:33 am
Re-do the secondary from a fresh backup
October 3, 2014 at 3:06 am
Stamey (10/2/2014)
What do you expect here?
The deadlock graph, the entire thing. Without being able to see exactly what objects, indexes, locks, statements, etc were involved in the deadlock, it's...
October 3, 2014 at 3:03 am
john.petrey (10/2/2014)
I am using sys.dm_exec_query_stats summing the Physical and Logical Reads. Is this a viable option for gathering this metric?
No. That DMV shows the total logical reads...
October 3, 2014 at 2:56 am
Yes... By doing nothing.
Go have a look at the sysdiagrams table. Are there any columns in there that have a collation defined at all?
Hence why I'm wondering why someone has...
October 3, 2014 at 2:51 am
farzad.jalali (10/2/2014)
GilaMonster (10/2/2014)
Why do you need to?it's a task's requirement which is assigned to me .
Ok, why reason did the person assigning to have?
October 2, 2014 at 7:37 am
If you're already having capacity problems, then consolidation is probably not a good idea. Consolidation is great for when you have multiple databases on different servers and those servers are...
October 2, 2014 at 6:41 am
Why do you need to?
October 2, 2014 at 5:29 am
doug.davidson (10/1/2014)
step 3: Truncate Transaction LogDBCC SHRINKFILE (N'X_log' , 0, TRUNCATEONLY)
Firstly, the comment is wrong. That doesn't truncate the log. The TruncateOnly option is only valid for data files, it's...
October 2, 2014 at 2:42 am
That's a .Net error. What were you doing when you got it?
October 1, 2014 at 7:56 am
enriquemallon (10/1/2014)
Today I was trying to attach a database in SQL server 2008 R2.
Databases cannot be downgraded, you need to attach it to SQL Server 2012 or SQL Server 2014
October 1, 2014 at 5:46 am
What do you mean 'one table takes time to execute'?
October 1, 2014 at 3:07 am
Viewing 15 posts - 7,621 through 7,635 (of 49,571 total)