Viewing 15 posts - 1 through 15 (of 114 total)
Also, large databases can be migrated with minimal downtime if you do it in two steps:
Before taking down any applications, make a full database backup of your source...
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...)
September 10, 2018 at 6:48 am
The query shows that the "index name" here is actually retrieved from the "name" column in sys.indexes, which all documentation says, yes, this should be the name of the index. But...
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...)
August 29, 2018 at 10:16 pm
Yup, but also two different index id's and therefore two different indexes - they also have different page counts.
Hmmmm...
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...)
August 29, 2018 at 1:27 pm
How is it possible to get the SAME index name for the SAME table but the Index ID is different?
Well, in theory, that's an easy 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...)
August 29, 2018 at 11:57 am
Just for the record, I agree 100% with Jeff on the basic point that the age of your existing statistics has precisely nothing to do with whether you need to...
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...)
August 29, 2018 at 1:34 am
You generally DON'T want more than one backup job for the same logs - that will just mess with your log chain and make restores a whole lot harder.
So,...
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...)
August 27, 2018 at 2:31 am
System DBs simply aren't synchronized in AlwaysOn - each participating node has it's own SQL Server instance with it's own system DBs and any changes made therein will affect only...
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...)
August 27, 2018 at 2:16 am
It's usually recommended to leave this on, yes.
While it is generally not a very good thing to have your SQL Server immerse itself in an update statistics job right...
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...)
August 27, 2018 at 1:56 am
10s of GB of DB set to autogrow in 1 MB increments...?
Yup, that's definitely an epic fail on any sanity check, but of course, this will only actually make...
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...)
August 23, 2018 at 4:56 am
Typically, the MSDB can grow large over time if there are no maintenance jobs in place to clean up old job history and backup history records. And yes, if these...
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...)
August 23, 2018 at 4:25 am
Well, as has already been stated, the SMK is used to secure all other keys on the server.
Which means that if you have ANY encryption ANYWHERE in 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...)
August 22, 2018 at 4:18 am
Actually, if you're not doing log backups, then you MUST not be using Full or Bull-logged.
SQL Server will let you do it, but in this setup, your transaction logs...
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...)
August 20, 2018 at 11:12 pm
Yup. Log backups are not supported in SIMPLE recovery mode because that involves simply overwriting the log entries as soon as you’re done handling transactions and writing the data back...
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...)
August 17, 2018 at 2:42 pm
Yes, it appears you do have some sort of third party tool making full backups you have not been aware of, so your number 1 priority should be to get...
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...)
August 16, 2018 at 11:12 pm
You'll need to talk to SQL Server, not just look at the files.
Basically, there is no way to give you any straight answers based on the information posted above...
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...)
August 16, 2018 at 6:37 am
Viewing 15 posts - 1 through 15 (of 114 total)