Viewing 15 posts - 9,661 through 9,675 (of 22,219 total)
Yeah, my company is using it for several projects right now. It's working for what we need. If your needs are very traditional, then WASD isn't for you. I 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
August 15, 2013 at 4:50 am
jasona.work (8/14/2013)
Grant Fritchey (8/14/2013)
jasona.work (8/14/2013)
You don't scare me!:hehe:Say the people quaking in their boots.
Ha! I hope you can make it to the Summit.
I'd bet your just a big softy 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
August 14, 2013 at 7:38 am
Koen Verbeeck (8/14/2013)
Now that I'm one of the big boyz and Grant...
"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 14, 2013 at 7:36 am
jasona.work (8/14/2013)
You don't scare me!:hehe:
Say the people quaking in their boots.
Ha! I hope you can make it to the Summit.
"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 14, 2013 at 5:12 am
Rearranging partitions is a completely different question than sharing a partitioning function. And yeah, changing the partition will cause all sorts of interesting blocking and locking, but that's to be...
"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 14, 2013 at 5:07 am
Is the process being blocked by other processes? What is that process waiting 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 14, 2013 at 5:03 am
If you've issued a kill command, you now have to wait for the rollback to complete. That can take as long, and sometimes longer, than the original transaction. So, if...
"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 14, 2013 at 5:02 am
Usually you'll be looking at one of two scenarios. You're going to be accessing the WASD database from a web page, also residing in Azure. There you don't have to...
"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 14, 2013 at 4:55 am
Both are "safe" approaches in that a given partition scheme can be applied to different tables. You just create a function (from the Books Online):
CREATE PARTITION FUNCTION myRangePF1 (int)
AS RANGE...
"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 14, 2013 at 4:50 am
Order of preference:
Tune the query
Adjust the indexing
Materialized view
Staging table
Analysis services
But the order of preference mostly also reflects how often these are used and how well each works (although SSAS works...
"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 14, 2013 at 4:44 am
It's mostly been in the October/November time frame. More often in October.
Too much sarcasm in the article or not enough?
"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 14, 2013 at 4:39 am
HowardW (7/17/2013)
Grant Fritchey (7/17/2013)
GilaMonster (7/15/2013)
About bloody time too...Third!
Is there confirmation somewhere that they've actually dropped it, or is it just that they haven't bothered with the CTP?
I've heard nothing one...
"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 7, 2013 at 4:10 am
BrainDonor (8/7/2013)
GilaMonster (8/6/2013)
Chad Crawford (8/6/2013)
They did a movie too[/url] - wasn't too good, but I thought it was worth watching because I loved the series so much.
The movie's good...
"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 7, 2013 at 4:05 am
From a purely technical point of view, short names don't hurt. They don't help either. A shorter DB name won't make backups run faster, queries run faster or decrease 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
August 2, 2013 at 8:59 am
RonKyle (8/1/2013)
"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 1, 2013 at 11:51 am
Viewing 15 posts - 9,661 through 9,675 (of 22,219 total)