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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 15, 2013 at 10:27 am
Check if email address is right or not ? and another thing profile has been configured correctly ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 13, 2013 at 6:18 am
Viewing 15 posts - 121 through 135 (of 2,462 total)