Viewing 15 posts - 1,891 through 1,905 (of 7,502 total)
SQLkiwi (7/8/2011)
--- never mind ---
Is that a new "Knock, Knock" ?
July 9, 2011 at 2:19 pm
just to add to the previous replies...
for such kind of maintenance, I always advise to disable the services ( or take the cluster resources offline ) so they don't auto...
July 9, 2011 at 5:14 am
did you take your db offline _before_ the file copies / lun copies?
July 8, 2011 at 10:06 am
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
Viewing 15 posts - 1,891 through 1,905 (of 7,502 total)