Viewing 15 posts - 4,456 through 4,470 (of 22,227 total)
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
If you used extended events, you don't have to track down columns. The event package will include everything. It does make things easier. However, on 2008, you'll have to consume...
"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:06 am
GilaMonster (8/31/2016)
"Becoming a successful SQL Developer"
Never done a professional development session before. Not sure how to...
"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
August 31, 2016 at 9:44 pm
Eirikur Eiriksson (8/31/2016)
Grant Fritchey (8/25/2016)
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?😎
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
August 31, 2016 at 9:42 pm
Sergiy (8/31/2016)
Grant Fritchey (8/31/2016)
Sergiy (8/30/2016)
JALLYKAMOZE (8/29/2016)
What is the best and permanent way to take care of parameter sniffing?
A clustered or covering index having the column used for the range selection...
"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
August 31, 2016 at 9:35 pm
Sergiy (8/30/2016)
JALLYKAMOZE (8/29/2016)
What is the best and permanent way to take care of parameter sniffing?
A clustered or covering index having the column used for the range selection as a first...
"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
August 31, 2016 at 1:53 am
Take a look at the Microsoft documentation.
"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
August 31, 2016 at 1:30 am
Best thing to do here would be to set up an extended event session to capture the security changes.
"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
August 31, 2016 at 1:30 am
Viewing 15 posts - 4,456 through 4,470 (of 22,227 total)