Viewing 15 posts - 7,306 through 7,320 (of 22,219 total)
You need to identify the blocking chain, which process is causing it to stop. Or, you need to identify the resource that it's waiting on in order to understand which...
"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
October 28, 2014 at 7:37 am
On most databases, most of the time, if you have automatic statistics maintenance enabled and you have auto-create statistics enabled, you're getting the statistics you need and probably don't have...
"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
October 28, 2014 at 7:31 am
That's really best done on the client, but the LEFT string function will work.
"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
October 27, 2014 at 11:30 am
Agree with Gail.
Look to the default ANSI settings on both servers, max degree of parallelism and the cost threshold for parallelism. Deviations in these settings can lead to differences in...
"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
October 27, 2014 at 7:07 am
vincyf1 (10/23/2014)
jamessdba (10/22/2014)
Hi please clarify .Please explain
what is the difference between database refresh (when we go for refresh)& Restore
Please clarify
Database Restore - When a DB Backup 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
October 23, 2014 at 7:00 am
yeah, it doesn't do regular expressions. Wild cards, AND/OR and NOT are supported though.
"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
October 23, 2014 at 5:41 am
You could try SQL Search[/url] from Red Gate. It's a free tool that should find those references pretty easily.
Mandatory disclaimer (although I'm not sure why for a free tool): 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
October 23, 2014 at 4:12 am
Glad you solved it and thanks or posting the follow up. It's always good to know what the problem really was and the solution.
"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
October 23, 2014 at 1:18 am
Edited it. Not sure where my brain was.
"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
October 22, 2014 at 10:35 am
patrickmcginnis59 10839 (10/22/2014)
Those are the fundamental building blocks of relational databases. A primary key uniquely identifies a row within the database an individual table....
"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
October 22, 2014 at 10:35 am
Where it says "relational databases" is a link. There is another at "primary key" and "foreign key" in the second paragraph.
"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
October 22, 2014 at 10:28 am
You're hard coding the value as 4. Within a script as you've outlined, you'd have to change the value to 5, 6 or 7 to get those values. If you...
"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
October 22, 2014 at 9:56 am
I also agree with Spaghetti on this one. Your approach will work. It's just not very clear. A lack of clarity can absolutely lead to error. For example, with only...
"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
October 22, 2014 at 9:47 am
Those are the fundamental building blocks of relational databases. A primary key uniquely identifies a row within a table. A foreign key is used to relate one table to another,...
"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
October 22, 2014 at 9:44 am
There is no specific to SQL Server function called a "refresh." Most of the time I've seen it used it's referring to a process (created by a business) wherein an...
"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
October 22, 2014 at 9:25 am
Viewing 15 posts - 7,306 through 7,320 (of 22,219 total)