Viewing 15 posts - 1,891 through 1,905 (of 7,498 total)
FYI:
/*
DMV Database File Size on Disk.sql
*/
Select IVFS.database_id
, DB_NAME(IVFS.database_id) as DBName
, IVFS.file_id
,...
July 8, 2011 at 10:02 am
Elizabeth.Block (7/7/2011)
This is a restore we've done through SSMS gui every month for years. ....
Why aren't you using a sqlagent job with a job proxy account that can read from...
July 8, 2011 at 10:00 am
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Keep in mind to...
July 8, 2011 at 9:52 am
shanila_minnu (7/8/2011)
its 64 bit
ALZDBA (7/8/2011)
...3) if this is a 64-bit instance, don't enable AWE and set max server memory !
Solution,
exec sp_configure 'max server memory (MB)', yournumberofMBforRAM ;RECONFIGURE
go
checkpoint
go
July 8, 2011 at 5:15 am
First question: is your instance a 32-bit instance ??
2) The first thing you need to do before enabling AWE is to set "max server memory" for your instance or it...
July 8, 2011 at 5:07 am
are you shrinking the .log file or one of the .mdf/.ndf files ?
July 8, 2011 at 5:03 am
John Mitchell-245523 (7/8/2011)
... You should be table to build ...
professional dyslexic :hehe:
Happens to me all the time :blush:
July 8, 2011 at 5:00 am
I would check out the applications connection string.
If it states the "failover partner=serverb" it will just be redirected without a problem.
If it lacks the "failover partner" keywords, something is wrong...
July 8, 2011 at 4:07 am
Please elaborate on what you are actually trying to do !
Triggers can perform queries, but keep the transaction scope and locking in mind !
Special objects _in_ triggers are the "inserted"...
July 8, 2011 at 12:56 am
- create primary keys for your tables and foreign keys to support your data integrity !
( very nice ref on how SQLServer takes advantage of this: Do...
July 8, 2011 at 12:42 am
check "create trigger" in books online.
http://msdn.microsoft.com/en-us/library/ms189799%28v=SQL.90%29.aspx
Golden rule for triggers: keep it short, as it is performed "in transaction", so if the trigger fails, the transaction fails !
July 8, 2011 at 12:34 am
David Burrows (7/7/2011)
GSquared (7/7/2011)
July 7, 2011 at 6:57 am
Jeff Moden (7/7/2011)
ALZDBA (7/3/2011)
It's great to see many of SSC addicts have been granted MVP once more.Congratulations to you all.
Dang... I missed this one on the first pass. Thank...
July 7, 2011 at 6:16 am
GilaMonster (7/6/2011)
Kit G (7/6/2011)
GilaMonster (7/6/2011)
Kit G (7/6/2011)
Fal (7/6/2011)
anyone with a minor dose of manners and a sense of humor is invited.
Please,...
July 6, 2011 at 7:21 am
Gianluca Sartori (7/6/2011)
ALZDBA (7/6/2011)
Another justification I used was:...
You must be working for a GREAT company, Johan.
I tried to figure out how that conversation would have been here at my...
July 6, 2011 at 7:14 am
Viewing 15 posts - 1,891 through 1,905 (of 7,498 total)