Viewing 15 posts - 12,511 through 12,525 (of 22,219 total)
GilaMonster (5/23/2011)
Now this is funny...http://blog.jitbit.com/2011/05/what-if-drivers-were-hired-like.html
Way too accurate.
"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
May 23, 2011 at 3:59 am
jasonshaw (5/23/2011)
GUID is a new concept to me and I am not sure that I works in this case as it is not good for indexing...
"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
May 23, 2011 at 3:54 am
Q: Ever heard of nHibernate?
A: Yes
Q: Next candidate!
Those are decent questions, but they lean a bit heavily towards database development and little away from straight-up development. You might want...
"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
May 20, 2011 at 11:57 am
Thanks. Glad to hear that stuff is useful. That's the goal.
"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
May 20, 2011 at 11:45 am
I've seen designs like this in the past and they lead to serious bottlenecks. I'm with Gus. If you have to do this a GUID is your best bet.
But, 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
May 20, 2011 at 8:17 am
odanwada (5/19/2011)
I think my manager wants 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
May 20, 2011 at 6:45 am
Must be that the procedure was created with a different schema as owner.
"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
May 20, 2011 at 6:42 am
Take a look at the RML Utilities from Microsoft. You can set up a work load and automate the replay of that workload or use a trace file and automate...
"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
May 20, 2011 at 6:39 am
Another option is to skip the trace entirely and pull the data from cache using dynamic management objects. Selecting from sys.dm_exec_query_stats will show you aggregate information about a query and...
"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
May 20, 2011 at 6:37 am
You can set this up pretty easily by using SQL Agent. You can query for the processes that are in place using sys.dm_exec_requests. With that you can get the session...
"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
May 20, 2011 at 6:33 am
But, the first time you move a database onto a new server, there's nothing of that database in cache. At best you're looking at memory pressure that is exposed when...
"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
May 20, 2011 at 6:28 am
Craig Farrell (5/19/2011)
Steve Jones - SSC Editor (5/19/2011)
Any chance someone can go a better job than me in explaining this is a bad idea: http://www.sqlservercentral.com/Forums/Topic1111536-392-1.aspx?Update=1Tried my humble best.
No, that was...
"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
May 19, 2011 at 1:38 pm
I didn't even know Hyperbac could be set to compress trace files. Cool!
By the way, rollover is supposed to give you a series of files, so that was working as...
"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
May 19, 2011 at 6:49 am
Robert Pepin (5/18/2011)
"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
May 19, 2011 at 6:47 am
I would not lay out the database by the transactions defined. Instead I would to set up standard database normalization, taking it out to 3rd normal form. It's a 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
May 19, 2011 at 5:37 am
Viewing 15 posts - 12,511 through 12,525 (of 22,219 total)