Viewing 15 posts - 1,606 through 1,620 (of 7,502 total)
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
I don't advise to tweak msdb sprocs. Ssms uses these to start kinderen.
October 27, 2011 at 7:39 am
write a stored procedure for which you grant them exec auth.
With that sproc use the "execute as" for an account that has the auth to start the wanted job.
October 27, 2011 at 6:40 am
Viewing 15 posts - 1,606 through 1,620 (of 7,502 total)