Viewing 15 posts - 6,676 through 6,690 (of 9,241 total)
OK, firstly why is the disk dynamic. Personally i think they should be outlawed 🙂
They're only really useful if you have no hardware RAID system and wish to create a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 9:05 am
praveen.singh (8/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 7:54 am
This I think is your problem
SET DatabaseName = db_name(db_id())
You're setting every single row in your temp table to database name of master (or whatever conext you run the query under)....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 3:41 am
gmamata7 (9/1/2011)
we have the best practice for Optimum performance to have data files asnumber of database data files should equal the number of cores per CPU socket
you shouldnt blindly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 3:02 am
gmamata7 (9/1/2011)
Method1:Have only one root Drive and have all Mounts Points under that drive
sort of, but i think you are confused with how mount points work. The whole point of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 2, 2011 at 2:33 am
BigSam (9/1/2011)
In Services & Applications, right-click SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 8:56 am
Failover is not just associated to the heartbeat. The Public connection is also taken into account. If the public NIC is not responding communications with Live applications will be unavailable...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 5:26 am
if the agents don't exist they must have been removed. I personally would attempt to clean them up using the stored procedure.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 5:15 am
SQL Server creates a clustered index by default on the PK, but its not necessarily the best it depends on the design of your tables. Each scenario is different
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 5:13 am
Jeffrey Williams-493691 (8/31/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:50 am
have you tried clearing them anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:48 am
harita (8/31/2011)
perry,but there are some scripts i guess i saw some people doing it
If you want to concoct your own scripted LS process that would be viable, either way the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:13 am
Adrian Smith-294236 (9/1/2011)
I have a maintenance plan that deletes backup histories
That wont cleanup the LS agent histories. The following stored procedure is used to cleanup agent history based on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 3:03 am
what steps are you taking to prune history?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 2:56 am
BigSam (8/31/2011)
I followed the information in Microsft's guide
http://msdn.microsoft.com/en-us/library/ms191295.aspx
I've upgraded the passive node to R2, but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 1, 2011 at 2:53 am
Viewing 15 posts - 6,676 through 6,690 (of 9,241 total)