Viewing 15 posts - 10,096 through 10,110 (of 22,226 total)
Great catch Lynn. Good point. But, once again, back to clarity.
"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
January 31, 2013 at 6:50 am
Get a copy of SQL Server 2008 Internals by Kalen Delaney. Then read it 100 times. You'll still be confused (as I am) but less so.
"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
January 31, 2013 at 6:44 am
The second example you're passing a string to an integer value. You can't do that. 2 does not equal 'rsv'.
On a side note, naming variables @1, @2 or @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
January 31, 2013 at 6:35 am
george sibbald (1/31/2013)
Grant Fritchey (1/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
January 31, 2013 at 6:31 am
SQLSACT (1/31/2013)
Basically correct. Although, it really only matters to the internals engine. For your purposes, both are dealt with the same way. According the to the Internals book, 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
January 31, 2013 at 6:30 am
Ah, well then, you need to have the business requirements that the database is supposed to meet in order to evaluate if it's going to meet them. Then you need...
"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
January 31, 2013 at 6:27 am
I don't know any training institutes in Bangalore, but what about just signing up to Azure and start doing it. You can get a sample account for free. As long...
"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
January 31, 2013 at 6:23 am
If you really don't know the structure, then you need to hope that all the tables have foreign keys. You can look at the dependencies of one of the tables,...
"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
January 31, 2013 at 6:20 am
I also like Michele Ufford's scripts[/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
January 31, 2013 at 6:18 am
If you mean how much it's using at the OS level, fair warning, that graph is likely to be very flat. SQL Server grabs as much memory as it 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
January 31, 2013 at 6:10 am
By and large it's about IOPS and contention. How many operations per second can your disk do and how much is it doing. When you think about the operating system...
"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
January 31, 2013 at 6:09 am
Basically correct. Although, it really only matters to the internals engine. For your purposes, both are dealt with the same way. According the to the Internals book, a hash 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
January 31, 2013 at 6:04 am
You can use the command line utility with SQL Data Compare to programmatically have it do that type of work for you. Here's the documentation on how that works. 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
January 31, 2013 at 5:57 am
I don't have an answer for you, but I contacted someone at Confio to see if they can help you 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
January 31, 2013 at 5:54 am
Do you mean validate the data structure of a SQL Server database?
Or do you mean validate the layout of a SQL Server installation?
Or do you mean evaluate SQL Server 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
January 31, 2013 at 5:46 am
Viewing 15 posts - 10,096 through 10,110 (of 22,226 total)