Viewing 15 posts - 4,441 through 4,455 (of 22,224 total)
It was a good event. I especially enjoyed how Mark took advantage of the space and created little mini-cons for people in small rooms that wouldn't otherwise get used. I...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 12, 2016 at 3:33 am
Today is SQLSaturday Cambridge. Gianluca is here if anyone wants to say hello. Not sure which other Threadizens. Assuming we all don't get eaten by a Grue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 9, 2016 at 9:30 pm
GilaMonster (9/9/2016)
Grant Fritchey (9/9/2016)
BrainDonor (9/9/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 9, 2016 at 3:59 am
BrainDonor (9/9/2016)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 9, 2016 at 3:11 am
SQLRNNR (9/8/2016)
Grant Fritchey (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 10:41 am
Yeah, actually, you can add a WHERE clause to the filter so that you add that value for the comparison. The version I checked this on is 11.6.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 10:40 am
I don't know a free tool that does this.
Redgate SQL Data Compare[/url] will do exactly what you need.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 10:01 am
If this is SQL Server 2012 or better (that's the forum you're posting in), why are you using sys.processes and DBCC INPUT BUFFER instead of the Dynamic Management Views (DMV)...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 9:59 am
GilaMonster (9/8/2016)
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 7:53 am
djj (9/8/2016)
rodjkidd (9/8/2016)
SQLRNNR (9/7/2016)
rodjkidd (9/7/2016)
Simple things etc as they say...Just used Drop Table If Exists for the first time... I had a little smile to myself.... 🙂
Rodders...
It really is a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 5:26 am
To get the best help, making it so we don't have to guess at stuff sure would help. And no, since there are multiple matching columns between the tables, the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 2:46 am
Celko or not, just adding an identity column to a table doesn't address the business logic. Do you have multiple rows with the same employee? There must be a logically...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 2:43 am
Probably a difference in the login identifiers between the databases caused the login and the database user to become disconnected. Take a look at this article for how to resolve...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 2:40 am
Any database with the recovery model set to Full will require log backups. If the log isn't backed up and autogrowth is enabled, you'll see auto grow occurring. Normal operations.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 8, 2016 at 2:37 am
sjimmo (9/7/2016)
If you just move the tables, but not the data, what's the point. You could simply script the database. If you move the tables, but not the foreign keys,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2016 at 8:27 am
Viewing 15 posts - 4,441 through 4,455 (of 22,224 total)