Viewing 15 posts - 12,136 through 12,150 (of 22,219 total)
GilaMonster (8/6/2011)
Grant Fritchey (8/6/2011)
In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.DateTimeOffset, not DateTime2.
Doesn't handle daylight saving though.
Oh crud. Of...
"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 6, 2011 at 5:02 am
In SQL Server 2005, you should handle this on the client side. In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.
"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 6, 2011 at 4:54 am
You're doing the JOIN incorrectly. See, each of those columns is to be joined to the Time dimension individually. If you look at the data, it will make more sense:
ProductKey...
"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 6, 2011 at 4:51 am
GilaMonster (8/6/2011)
Ninja's_RGR'us (8/6/2011)
Was it you Gail that said you don't even make 1$ / hour on your articles (this site pays 25$ / article)?
Wasn't me, but it's very true. What...
"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 6, 2011 at 4:36 am
Shabba (8/5/2011)
There I was just reviewing your Performance Tuning Video from SQL in the City!By the way thanks for the informative presentation.
Thank you! I hope it's useful.
"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 5, 2011 at 8:35 am
It really depends on what you need. For straight forward monitoring and alerting, I suggest my companies software, Red Gate SQL Monitor[/url].
If you want to get into specific query tuning,...
"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 5, 2011 at 8:23 am
Microsoft provides a runtime that can be deployed. Search on MSDN. It's there.
"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 5, 2011 at 6:00 am
I'm with Gail on this one. Fixed values are much better. You always know exactly how much will be added and you can anticipate the additional load that will place...
"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 5, 2011 at 4:57 am
Nope. Especially not a unique index. If it's unique, it's unique. If someone types Heme, Hem or Ham, they're all going into the database.
"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 4, 2011 at 3:14 pm
I have to ask, why no backups?
"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 4, 2011 at 3:13 pm
After you read the manuals, and that really should be where you start, you might swing by this article[/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
August 4, 2011 at 3:13 pm
Rebuilding every six weeks or so might be OK. The real question is, how often are your statistics maintained? Those age much quicker than indexes fragment.
"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 4, 2011 at 11:50 am
Chris Kitchen (8/4/2011)
Thanks for all your replies, at the moment there is nothing set in stone, we are just reviewing the different options available:
1. Set "Identity" to "Yes" for...
"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 4, 2011 at 6:43 am
danymorales17 (8/4/2011)
Let me ask you all this, what about Developer/QA servers. What 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
August 4, 2011 at 5:52 am
I'd start with a search in the web site that you're on. We've got years of articles, published 5 a week. I'll be there are a ton of SSIS on...
"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 4, 2011 at 5:47 am
Viewing 15 posts - 12,136 through 12,150 (of 22,219 total)