Viewing 15 posts - 6,586 through 6,600 (of 22,226 total)
Don't get stuck on either/or approaches with EF and procedures. It's both. You can, and depending on the code in question, should, be able to code using straight EF queries...
"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
March 13, 2015 at 6:04 am
You could use event tracking I think to capture connection and start up times. I'd have to look that up to be sure. Better to use extended events than trace...
"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
March 13, 2015 at 6:00 am
I'd suggest you also check out Minion Reindex by the Midnight DBA team. It's a great tool. I wrote a review of it here[/url].
"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
March 13, 2015 at 5:49 am
I'd say there are two things at work here. First, and most importantly, table variables and temporary tables do have radically different behaviors within SQL Server due to the fact...
"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
March 13, 2015 at 5:47 am
I'm reading the last new Sam Vimes book I'll ever read and I'm not happy about 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
March 12, 2015 at 3:51 pm
The example here shows how to use a parameterized query. There are others out there. It's a fairly standard approach. And here's a way to use procedures. Other examples...
"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
March 12, 2015 at 3:33 pm
ScottPletcher (3/12/2015)
"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
March 12, 2015 at 3:13 pm
The Dixie Flatline (3/12/2015)
Miskatonic alumni often are.
Go Pods!
"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
March 12, 2015 at 3:10 pm
No, entity framework, nhibernate and the other ORM tools are fine. But, they don't negate the need for security in any way. In fact, it makes it more important. Those...
"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
March 12, 2015 at 3:09 pm
This is not possible in a view. A view can't enforce data constraints. It's nothing but a query against the table. You should look to CHECK CONSTRAINTS on the 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
March 12, 2015 at 1:05 pm
The best place to go for this type of information is Denny Cherry. Here's his book. He also as lessons on Pluralsight. The new version of the book is due...
"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
March 12, 2015 at 1:03 pm
You can get most of that from sys.databases. It doesn't show when databases went offline. That can be in the error log, assuming it hasn't rolled over. I'm not sure...
"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
March 12, 2015 at 12:59 pm
Dan121 (3/12/2015)
if I have a table with these columns:ID (uniqueidentifier)
Create_date (Nvarchar 100)
Created (nvarchar (max))
how much space does a row takes? ----this is just a sample.
It depends. The UNIQUEIDENTIFIER 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
March 12, 2015 at 12:55 pm
ZZartin (3/12/2015)
Sean Lange (3/12/2015)
"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
March 12, 2015 at 10:53 am
How unique is the data in your WeekEnding column? If it's not very selective, the statistics might be poor and you may not be seeing good use within the execution...
"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
March 12, 2015 at 10:48 am
Viewing 15 posts - 6,586 through 6,600 (of 22,226 total)