Viewing 15 posts - 16 through 30 (of 114 total)
True.
You do need to be at a supported level, ie. if not at the level of the current SQL Server version, then one of the two previous versions before...
June 7, 2013 at 4:42 am
Sure, no problem.
"Under the hood", your database is already upgraded - that happens automatically the first time you bring it online. Leaving it in a compatibility level lower than your...
June 6, 2013 at 11:41 pm
Well, I strongly suggest you reconsider this "standard" practice.
In many cases, having plans that involve weekly shrinks is inferior to not having DB maintenance plans at all.
June 3, 2013 at 9:57 am
No database will ever automatically release free space back to the file system, but all data in your tempdb is temporary in nature and should be dropped as soon as...
June 3, 2013 at 4:46 am
Chrissy321 (6/2/2013)
Also the first occurrence of the 'Backup, file manipulation operations..' error was when the blasted maintenance plan attempted its weekly shrink.
Yikes! Running weekly shrink as part of a maintenance...
June 3, 2013 at 4:06 am
Are you dumping log backups on the same disk that contains the actual log files?
If not, then why would you cancel the log backup? Allowing it to run might actually...
June 3, 2013 at 4:01 am
New service packs (SP) should be installed as soon as possible and no later than 1 year after their release in order to stay supported. Security updates should be installed...
April 26, 2013 at 7:10 am
Deleting data will only free up space within the database, not actually deallocate any pages, hence your data files will remain exctly the same size after a delete (your log...
April 26, 2013 at 7:00 am
Nice. Gee, it's getting hard to remember how we found anything in the days before Google. 😛 😉
April 26, 2013 at 2:35 am
Stored procedures sp_who or sp_who2 will both include username and hostname for all active connections. See if you can't find what you need in there. 🙂
EDIT: Sorry, on re-reading your...
April 26, 2013 at 2:28 am
Basically, the BUILTIN\Administrators group includes all local (Windows) admins and the BUILTIN\Users group includes all local users.
So, what this means is that any account in the Windows local admin group...
April 26, 2013 at 2:17 am
Well, first of all, best practice is to use Windows authentication, preferably in combination with AD groups, so that everyone logs in with their own personal account but you don't...
April 26, 2013 at 2:01 am
I just tested it and I see the same thing on 2008 R2 SP2 (10.50.4000.0):
When using basic CREATE DATABASE in TSQL with no parameters, your new database gets a primary...
April 24, 2013 at 5:14 am
I'm thinking your fill factor isn't being used because your entire table fits on a single page.
April 8, 2013 at 1:43 am
Well, to be blunt: You're doing it wrong!
If you want to be able to rebuild your server from scratch, you need a backup of this server's master database, not one...
March 18, 2013 at 3:15 am
Viewing 15 posts - 16 through 30 (of 114 total)