Forum Replies Created
Viewing 15 posts - 5,206 through 5,220 (of 22,219 total)
-
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 -
RE: sql server maintenace plan for backup's behaviour
You need to be able to grant access to an account to the drive locations where the backup is going to go. That's why it should be a network account....
"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
I hope the move between servers is meant to be permanent, or that you took a backup, using the BACKUP DATABASE command before you did the move, because what 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: OPENQUERY
Yikes.
OK, well, the way to solve this would be using a recursive CTE and the OVER...ORDER BY clause... but thousands? No. It basically won't work. I'm think 3-5 or even...
"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: OPENQUERY
Is it always three values or is it any number of values?
"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: SQL Server 2014 installation freezes
This is not a problem I've run into, but it seems that killing the process ngen.exe has helped a number of people solve this problem.
"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,219 total)