Viewing 15 posts - 10,306 through 10,320 (of 22,219 total)
Artoo22 (10/24/2012)
"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
October 24, 2012 at 8:36 am
Scott D. Jacobson (10/24/2012)
"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
October 24, 2012 at 7:36 am
The database size is allocated size, not data size. SQL Server, by design, maintains empty space within the data and log files in order to allow for growth of your...
"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
October 24, 2012 at 6:31 am
Seriously, how many people on the planet have DTS experience with databases greater than 100tb? I mean, how many DBAs have experience at greater than 100tb, period, full stop? They...
"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
October 24, 2012 at 5:51 am
<insert curse words here>
Do I also have to sweep the floors, clean the toilet and maintain the stock portfolio?
That's a rather insane list of requirements. They better be paying well...
"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
October 24, 2012 at 5:48 am
Not sure. I'd need to see the query and XML execution plan.
"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
October 24, 2012 at 4:26 am
A materialized view in SQL Server is a clustered index. This means that the data that defines the view will be stored within the view at the leaf level 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
October 23, 2012 at 5:37 am
There is a setting called 'Optimize for Ad Hoc Workload' that could help you out. Instead of storing a plan each time a query is run, the first time it's...
"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
October 23, 2012 at 5:35 am
It's just like buying any other piece of hardware, the more money you spend, the better off you are. My current laptop is a MacBook Pro with 16gb of memory....
"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
October 23, 2012 at 5:12 am
PiMané (10/22/2012)
Grant Fritchey (10/22/2012)
But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/url].
Thanks Grant... Still reading your book on query...
"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
October 22, 2012 at 7:08 pm
harri.reddy (10/22/2012)
they gave me some tables(approx 9) tables and field that they want to fecth only those field.
they all r master table.so do i need to make table that connect...
"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
October 22, 2012 at 7:06 pm
sql-lover (10/22/2012)
Grant Fritchey (10/22/2012)
sql-lover (10/22/2012)
I thought deadlocks (most of them) were due poor or bad code; 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
October 22, 2012 at 6:45 pm
sql-lover (10/22/2012)
I thought deadlocks (most of them) were due poor or bad code; a process pinning other...
"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
October 22, 2012 at 11:12 am
I used to use CodeSmith. But that was when they were hosted on CodePlex. It's moved to GoogleCode [/url]and I'm not sure it's the same. Still, might be worth checking...
"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
October 22, 2012 at 11:08 am
But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/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
October 22, 2012 at 11:05 am
Viewing 15 posts - 10,306 through 10,320 (of 22,219 total)