Viewing 15 posts - 346 through 360 (of 1,179 total)
Check the following article:
Also ask system admin to check if any issue with VMWare and check physical memory allocated to the server in VMWare correctly.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 6:06 am
This is thumb rule or nature of law if in IT DBA'S paid more people will attact to that job and salary will nutralize. This is purle game of Demand...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 5:56 am
No, SSMS open won't create any locking/blocking but I guess as you have mention that you opened SSMS and executed a few queries and if it ran for longer duration...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 5:44 am
No body can do any operation on database which is in norecovery mode i.e. restoring. While when database is in standby mode it is available to people to read the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 4:36 am
It you are talking abou the job you can schedule it to run daily every 10 second between 23:00 to 3:00 hrs. However it won't be possible to set it...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 4:26 am
Do you mean this:
INSERT INTO Table2 (Col1, Col2, Col3)
SELECT Col1, Col2, Col3 FROM Table1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 4:09 am
Visit following link:
http://www.slideshare.net/PhilYoung4/hadoop-demo-ppt-17211338
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 4:02 am
Are you able to access from other server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 3:49 am
What is the growth of the Database? 15 GB is not huge data and you are purging only 1 GB and that too Database will occupy when insert will happen....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 3:25 am
Check following link:
http://msdn.microsoft.com/en-us/library/vstudio/8xx3tyca(v=vs.100).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 1:19 am
While configuring Data Collection it will create one database in which it will store the data collection. So definitely it will create some disk i/o however it depends on what...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 1:10 am
What if you stop and re-run your query again?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 11:10 pm
It is very difficult to find out as same query on the prod take different time to execute as it depends on lot of factors like:
1. Any other application is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 5:34 am
I doubt.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 2:53 am
What is MAXDOP setting on the server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 31, 2014 at 1:27 am
Viewing 15 posts - 346 through 360 (of 1,179 total)