Forum Replies Created
Viewing 15 posts - 5,206 through 5,220 (of 22,224 total)
-
RE: Downgrading from SQL Server 2014 to SQL Server 2012
craig-962225 (1/21/2016)
As this has been a problem since the beginning of time, one would have hoped MS would have come up with a solution to create a backup into a..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Lynn Pettis (1/20/2016)
Grant Fritchey (1/20/2016)
Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It evidently looks...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Point in time restores via the GUI
COPY_ONLY will only affect differential backups, not log backups. Log backups can be associated with any full backup, even ones that have been taken using COPY_ONLY. It's only when you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Recommended SQL Backup Software?
I am prejudiced, but Redgate SQL Backup is a great piece of software (I work for them).
You might also want to look at Minion Backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Deploying Database Scripts
this is a complex topic and there are lots of ways to get it done. I have long been an advocate for using source control for the databases so that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Jeff Moden (1/19/2016)
jasona.work (1/19/2016)
Paintball is getting more and more complicated...I wonder if it'll work with Express or if it needs Enterprise?
I've been outlawed from paint ball forever... I threatened to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: How to check what is current LSN of DB?
I sure don't know if this will work, but one idea might be to put the database into STANDBY. You can at least query it then to determine the LSN.
If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Koen Verbeeck (1/19/2016)
Grant Fritchey (1/19/2016)
BL0B_EATER (1/19/2016)
Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
BL0B_EATER (1/19/2016)
Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my mentoring / training relationship..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Any way to find which procedures are causing serializable lock mode?
GilaMonster (1/19/2016)
Grant Fritchey (1/19/2016)
I'd probably go with the extended events session.Thirded. I'm starting to love XEs (late to the party, I know).
But very welcome all the same!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Can't find downoad of AdentureEWorksDW.mdf
If you can't find the version and type you need from here[/url], it doesn't exist.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Any way to find which procedures are causing serializable lock mode?
I'd probably go with the extended events session. I'm at least sure you can capture the information there as opposed to the DMVs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Best approach for Insert/Update/Delete audits
ExEvents outside of enterprise really is the most flexible and powerful mechanism for auditing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Copy Database from MSSQL2005 to MSSQL2012 Express
No, the security has to be done after you successfully move the database to 2012.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 5,206 through 5,220 (of 22,224 total)