Viewing 15 posts - 6,586 through 6,600 (of 22,219 total)
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
I seem to be the harbinger of doom.
Terry Pratchett has died.[/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 12, 2015 at 9:14 am
Proving it will be fine is easy. Show that the app works before and after the change. But, you want to prove a benefit. To do that, I'd show 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
March 12, 2015 at 4:32 am
Backup adds load to the server, but it doesn't lock things and cause blocking. The added load could be causing the timeouts, but it's hard to say without more information....
"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 4:31 am
Well, let me know if you want drill down on this. Happy to try to help.
"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 4:03 am
I like Jason's description. It's for undoing a situation.
So, it sounds like you see a lot of code of the variety like this:
BEGIN TRAN
UPDATE TableA
SET ColA = 42
WHERE ColB =...
"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 4:02 am
jasona.work (3/11/2015)
Katerine459 (3/11/2015)
If a stairway ever does get created, I just wanted to give...
"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 11, 2015 at 3:44 pm
Generally speaking, SQL Server didn't do well in kindergarten. It doesn't play at all well with others.
If you already have an isolated production server and you're considering consolidating this other...
"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 11, 2015 at 3:41 pm
Viewing 15 posts - 6,586 through 6,600 (of 22,219 total)