Viewing 15 posts - 8,086 through 8,100 (of 9,715 total)
Do not mistake "want" for "need". There is no need. Technically, you could run a 1 TB size database on one file and one filegroup.
The idea of splitting your database...
March 29, 2010 at 11:33 am
The one thing to note about killing connections this way is that it does NOT prevent those connections from reconnecting after they've been disconnected. The best way to do that...
March 29, 2010 at 11:28 am
I agree with Grant. If you can do it, go for it. I don't see any Cons to the situation and only Pros.
Just don't make the mistake of setting Max...
March 29, 2010 at 10:58 am
What exactly is your definition of a "Blocked Index"?
I've never heard that term before and I find myself wondering what it has to do with allow_page_locks being on or...
March 29, 2010 at 10:55 am
Not sure what MOSS is, but here goes.
gmamata7 (3/29/2010)
2. What are the exact steps I need to follow to create secondary data file?
Open up Books Online and lookup ALTER DATABASE...
March 29, 2010 at 10:44 am
river1 (3/29/2010)
Msg 217, Level 16, State 1, Procedure RemoveLigacoes, Line 48
Maximum stored procedure, function, trigger, or view nesting level...
March 29, 2010 at 10:38 am
Full backup is not the same thing as Full Recovery Mode.
Right click the database, go to Properties. Check the Options page in the popup window. Does the second line (Recovery...
March 29, 2010 at 10:32 am
Satish-219904 (3/29/2010)
How can i assign the 'lock pages in memory' right to the service account running SQL?
You have to assign that right through the Active Directory GPO. If the the...
March 29, 2010 at 10:29 am
And apparently we never caught the "all connections on the server" part of the OP.
DOH!
March 29, 2010 at 8:49 am
shanila_minnu (3/29/2010)
wat is the difference between date_modified and run_time.when i executed like belowSELECTb.run_time,b.run_date,a.date_modified,*
FROM
MSDB.dbo.sysjobs a inner join MSDB.dbo.sysjobhistory b
on a.job_id=b.job_id
where a.date_modified > '2006-08-17 12:22:14.440'
it is showing both run_date,date_modified almost simillar
The date_modified...
March 29, 2010 at 8:08 am
One potential problem I see right off the bat. You're dropping the job off it's modified date instead of it's last run date, which is what you originally wanted. If...
March 29, 2010 at 7:28 am
Why not just do a restore-from-backup to the reporting instance and create the indexed views as part of the job that auto-restores for you?
EDIT: Then add specific perms for the...
March 29, 2010 at 6:10 am
No, I don't have a query. I've never needed to write one.
It's not that hard, though. Look up the code in Books Online. It's the best way for you to...
March 29, 2010 at 6:07 am
If this has happened to you recently and you're running Windows 2003 SP 2, you need to check out the following links:
March 29, 2010 at 6:03 am
Viewing 15 posts - 8,086 through 8,100 (of 9,715 total)