Viewing 15 posts - 16 through 30 (of 115 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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
April 26, 2013 at 7:00 am
Nice. Gee, it's getting hard to remember how we found anything in the days before Google. 😛 😉
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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.
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
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...
Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
March 18, 2013 at 3:15 am
Viewing 15 posts - 16 through 30 (of 115 total)