Viewing 15 posts - 10,306 through 10,320 (of 22,224 total)
L' Eomot Inversé (10/29/2012)
WayneS (10/29/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 30, 2012 at 1:24 pm
SQLSACT (10/25/2012)
Grant Fritchey (10/23/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 26, 2012 at 8:17 am
Yeah, I've seen that approach before too. It's supposed to make the code self-documenting or something. Any column can only ever be from one table. What a pain.
"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 25, 2012 at 12:33 pm
The basic design is quite simple. You have to create an interim table that has the primary key from patient and the primary key from pharmacy. That creates the many...
"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 25, 2012 at 8:39 am
If you're truncating the entire database, how about setting it to restricted user prior to running the process? If you need to you can even rollback outstanding connections immediately (with...
"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 25, 2012 at 8:25 am
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
Viewing 15 posts - 10,306 through 10,320 (of 22,224 total)