Viewing 15 posts - 3,436 through 3,450 (of 9,244 total)
Yes really, memory and cpu can be over committed usually without too much problem. If you follow the best practice and avoid over committing then cpu and memory will never...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 22, 2014 at 12:36 am
the biggest problem with VMs is storage performance which for your DW you'll probably need. Virtual disks are generally good for standard sequential I\O but suck for random I\O. There...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2014 at 6:06 pm
shahgols (3/21/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2014 at 5:56 pm
As a dual skilled DBA, i say forget what you know about Oracle. Get the SQL server internals book and give it a good going over multiple times.
I hear...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2014 at 5:52 pm
k.arkenau (3/21/2014)
Ok, there are two intances running on my system, one standard instance (MSSQL) and one named instance (SAPSQL). What to do then?
Under the servername parameter put the full instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 21, 2014 at 2:09 am
pheonix623 (3/20/2014)
Select pm.class_desc,
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2014 at 8:54 am
ramyours2003 (3/19/2014)
i need to transfer only the sql logins from one server to another server with the passwords as well, how can we do it ?
Which version sql are you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2014 at 6:24 am
What are you using to ascertain that the login has a grant on the endpoint?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 20, 2014 at 5:39 am
you know now 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:21 am
do you have a firewall enabled?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:17 am
glugingboulder (3/17/2014)
10 node windows cluster
Availability group 1 spans nodes 1 -5.
Availability group 2 spans nodes 5-10.
Essentially you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:15 am
zedtec (3/19/2014)
Hi Perry,No confusion.....Failover is performed at the principal server isn't it?
No, not when the principal is dead as you quoted in your scenario above. In this case you would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 5:12 am
k.arkenau (3/19/2014)
Ok, I changed that and added the User to the DCOM User group.Nevertheless, the user still cannot logon to the information services.
Any idea?
If you used distributed com users...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2014 at 1:49 am
zedtec (3/18/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 18, 2014 at 10:32 am
to add to George, the old principal will become the mirror but the session will be suspended. You will need to manually resume mirroring using
alter database [yourdb] set partner resume
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2014 at 3:49 pm
Viewing 15 posts - 3,436 through 3,450 (of 9,244 total)