Viewing 15 posts - 9,601 through 9,615 (of 22,219 total)
DaveDB (9/4/2013)
So, would you say that it makes more sense to have a clustered index on a column besides an ID column? Seems like that would 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
September 4, 2013 at 4:08 pm
Sean Lange (9/4/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
September 4, 2013 at 3:51 pm
PiMané (9/4/2013)
Temp tables created with SELECT .. INTO #temp FROM ... and then create clustered index ......
"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, 2013 at 3:50 pm
Loading & querying XML is expensive, especially with regards to memory. But, if you're already loading it, then it's not that much more expensive to use it twice. However, 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
September 4, 2013 at 9:20 am
#temp tables have statistics. It's table variables that do not have statistics.
Here's a question. Will more than one user be running this query? If so, using a permanent table will...
"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, 2013 at 9:02 am
I don't really know of any. Data Architect is a pretty loose term for someone with a lot of experience and knowledge who can help you build, architect, your systems...
"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, 2013 at 3:57 am
There is no way to go back in time to retrieve an execution plan. So, if you have a need to monitor particular plans, you need to set up, ahead...
"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, 2013 at 3:54 am
I just wrote and submitted a 400 word editorial for Simple-Talk on MCM.
"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, 2013 at 9:13 am
Brandie Tarvin (9/3/2013)
Grant Fritchey (9/3/2013)
Brandie Tarvin (9/3/2013)
Grant Fritchey (9/3/2013)
Presumably they all use the internet.
One can hope. I know several older people who barely know what email is let alone...
"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, 2013 at 7:58 am
Brandie Tarvin (9/3/2013)
Grant Fritchey (9/3/2013)
Presumably they all use the internet.
One can hope. I know several older people who barely know what email is let alone what websites are out...
"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, 2013 at 7:29 am
Presumably they all use the internet. Reference known web sites and talk about how they might work. You can use Amazon, Wikipedia, the Internet Movie Database (nicely named) or any...
"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, 2013 at 3:50 am
You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or a COPY_ONLY...
"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, 2013 at 3:47 am
Jeff Moden (8/31/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
September 1, 2013 at 4:38 am
SQLRNNR (8/31/2013)
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
Can...
"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 1, 2013 at 4:37 am
GilaMonster (8/31/2013)
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on 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
August 31, 2013 at 3:53 am
Viewing 15 posts - 9,601 through 9,615 (of 22,219 total)