Viewing 15 posts - 1,606 through 1,620 (of 7,504 total)
Order of processing is important with AWE.
First set your max server memory and only then enable AWE !
In your case (8GB total allocated VM ram) You would need /3GB /PAE...
November 1, 2011 at 1:35 pm
Just a way to import your default trace and query it... see attachment
( this one reports auto grow events ,should be peace of cake to have it filter detach or...
November 1, 2011 at 1:31 pm
Did you notice your first query has a "distinct" keyword ?
Guess what that does.
November 1, 2011 at 1:24 pm
Win 2008R2 ... Do you have the needed windows authority to rename files ?
(one of the security changes with win2008R2 en SQL008(r2))
November 1, 2011 at 1:20 pm
tommey152 (10/31/2011)
What i xactly need is to remove all the fields after...
November 1, 2011 at 2:59 am
not a good practice having more than a single LDF file for tempdb.
With your number 4. are you seeing 2mdf and 2ldf files at file system level ?
You could...
October 31, 2011 at 6:34 am
how much disk capacity can you add to your server ?
October 31, 2011 at 6:29 am
I would start looking for
select ... from sourcetable where yourcol > 99999.999999
October 31, 2011 at 6:28 am
for starters: Database Mirroring Overview
soup: How to: Configure a Database Mirroring Session (SQL Server Management Studio)
main course:SQL Server Replication: Providing High Availability using Database Mirroring
October 29, 2011 at 8:04 am
Well documented overview , Yusuf.
Always nice to have a cheat sheet at hand.
October 28, 2011 at 11:55 am
SQLDCH (10/27/2011)
October 28, 2011 at 2:05 am
FYI http://www.connectionstrings.com/sql-server-2008 also holds some examples on how to define connection strings for mirrored databases.
When specifying a failover partner, your apps will automatically connect to the primary db.
Keep in mind...
October 27, 2011 at 1:07 pm
IMO the question should be : "where/who do you want to take care of security and performance".
If you think that is the sole responsibility of your devs, go for parameterised...
October 27, 2011 at 12:57 pm
You could create a sql user and make the it job owner and:-) assign a proxy account for the job step. If they log on using that account, they...
October 27, 2011 at 8:50 am
Viewing 15 posts - 1,606 through 1,620 (of 7,504 total)