Viewing 15 posts - 4,441 through 4,455 (of 22,219 total)
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
Nice work Luis.
"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:02 am
The question is, what are your primary keys and your foreign keys. From the layout it could be either order number or order number and location or just location. Your...
"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 2:59 am
Why?
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, constraints...
"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 2:41 am
They did say thanks. That's more than we get sometimes.
"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 6, 2016 at 4:11 am
If the function starts with the definition of a table like this:
...RETURNS @somename TABLE
(...
Then it's a multi-statement table valued function. You can read more about the three kinds of functions...
"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 6, 2016 at 4:10 am
Viewing 15 posts - 4,441 through 4,455 (of 22,219 total)