Viewing 15 posts - 1,606 through 1,620 (of 7,498 total)
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
just start it from the commandline adding the -m parameter and you should be fine.
I haven't tried to add a fourth registry parameter with the -m .
(each entry can only...
October 27, 2011 at 6:37 am
I would think of a blocking situation causing many waits for your jobstep to proceed.
If you don't have a blocking sampler or monitoring app, this is hard to prove 100%.
October 26, 2011 at 9:12 am
change you db so it uses "auto_close"
( alter database xyz set auto_close ON )
This way your applications - if any - should be able to work, if their timeout survives...
October 24, 2011 at 10:02 am
Viewing 15 posts - 1,606 through 1,620 (of 7,498 total)