Viewing 15 posts - 121 through 135 (of 2,462 total)
Robin35 (10/16/2013)
but i'm not sure where to start and how to decide where the issue lies.
see http://blogs.msdn.com/b/karthick_pk/archive/2012/06/15/troubleshooting-sql-server-memory.aspx
October 17, 2013 at 2:50 am
bcampbell-1136357 (10/16/2013)
then leads to the question of what is the best method for copying out the data to another table without impacting the performance of the logging table?
Batch...
October 17, 2013 at 2:47 am
Robert klimes (10/16/2013)
The estimated cpu cost of both queries is 0.0000005. Shouldn't the first query have a higher cost due to the extra conversion?
With such a small amount of...
October 16, 2013 at 8:49 am
NO i think you have to restore the data into non partitioned table then move the data to other server.
October 16, 2013 at 8:37 am
Robin35 (10/16/2013)
I believe this is from OS processes, when i look at the task manager i see so many processes but no single process is using high amount of memory.
...
October 16, 2013 at 8:34 am
L' Eomot Inversé (10/16/2013)
ROLLBACK always (unless you specify an invalid transaction name) sets @@trancount to 0 and rolls back the transaction (unless @@trancount is already 0, in which case...
October 16, 2013 at 8:27 am
Is the log drive being used by other things too like tempdb or data files ?
And what was the initiall size of this log file ? and have you set...
October 16, 2013 at 7:08 am
bcampbell-1136357 (10/15/2013)
I'm running select queries against a large and poorly indexed table.
And Why are you living with poor indexes ? that you need to work at first.
October 16, 2013 at 6:56 am
YOu can think about data partitioning here. in your scenario it will help
plus
you can also take advantage of Sliding window data archival approach to remove the unwanted historical...
October 16, 2013 at 6:53 am
i live in INDIA which is known as World's IT hub (atleast we indian think that though there could be another reasons too why US outsource their IT work...
October 16, 2013 at 6:37 am
But I made the wrong selection . beacuse i was thinking (and this was my understanding ..earlier) that once the commit has been fired, the following rollback doesnt work for...
October 16, 2013 at 2:28 am
This would be BLIND shot... but see who logged in just before the replication started getting failed.but SEE ... there are 100 % chances that the login who deleted the...
October 15, 2013 at 10:27 am
Check if email address is right or not ? and another thing profile has been configured correctly ?
October 15, 2013 at 9:56 am
First thing first.please provide us the error message logged in the setup log files which are located in %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\.
another thing .. try to install on other disk/drive...
October 13, 2013 at 6:31 am
Snargables (10/11/2013)
Up to last saturday at 8am this process ran in 20-30 mins. Now it's taking 3 hours.
obviuosly kevin ans sean will give here better idea
something from...
October 13, 2013 at 6:18 am
Viewing 15 posts - 121 through 135 (of 2,462 total)