Viewing 15 posts - 7,501 through 7,515 (of 22,219 total)
Next time, instead of expanding the stuff out, open a query window and look at sys.dm_exec_requests to see what is blocked, blocking, etc., what the wait stats are, that sort...
"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 4, 2014 at 12:48 pm
SimonHolzman (9/4/2014)
Grant Fritchey (9/4/2014)
"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 4, 2014 at 12:43 pm
Pretty much what Gail says.
Because the optimizer is going to assume you're only returning 1 row ( the lack of statistics), it's going to create an execution plan for returning...
"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 4, 2014 at 12:39 pm
I wrote a short article on backup verification[/url], and, you're right, the only way to be sure your backup is good is to restore 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 4, 2014 at 12:36 pm
Is this SQL Server Express? It could be the instance isn't starting without the connection. Guessing. I've never seen a problem that SSMS, as SSMS, fixes.
"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 4, 2014 at 12:27 pm
Start time, you need to schedule it to run somehow. Generally, I'd use SQL Agent, but you can put anything to work on it that can fire off at 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 4, 2014 at 12:26 pm
polkadot (9/4/2014)
By extensible I mean, current practices that will allow maximum future flexibility to rearranging server and network infrastructure. For example, in the near future we may acquire...
"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 4, 2014 at 12:17 pm
SimonHolzman (9/4/2014)
Grant Fritchey (2/11/2014)
My personal favorite, and not just because I work for them, Red Gate SQL Prompt[/url]. It supports 2012 (and Azure and 2014).
Sadly, at $350 per user, 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 4, 2014 at 12:11 pm
Can you further define what you mean by "extensibility of environments"? Are you talking about a scale out scenario? Scale out means that in order to support an increasing load...
"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 4, 2014 at 7:03 am
a2zwd (9/4/2014)
I have worked on different DB projects. All the companies I worked will design DB/tables directly in sql server management studio. Means they do...
"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 4, 2014 at 7:00 am
Here's the issue:
dbo.NEW_ORDER WITH (serializable updlock)
You need to change it to:
dbo.NEW_ORDER WITH (serializable, updlock)
"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 4, 2014 at 6:54 am
BWFC (9/4/2014)
Grant Fritchey (9/4/2014)
"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 4, 2014 at 6:47 am
The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry level data professional positions. It's...
"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 4, 2014 at 6:09 am
mario17 (9/3/2014)
Hey all !!!we have Grant Fritchey here !!!!
Thanks much for your help !!!!
M
Ha!
I wasn't aware that was an event, especially with all these people.
"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 3, 2014 at 10:51 am
SQLRNNR (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
"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 3, 2014 at 9:04 am
Viewing 15 posts - 7,501 through 7,515 (of 22,219 total)