Viewing 15 posts - 15,331 through 15,345 (of 22,219 total)
Brandie Tarvin (4/27/2010)
"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
April 27, 2010 at 8:33 am
Brandie Tarvin (4/27/2010)
"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
April 27, 2010 at 8:23 am
Brandie Tarvin (4/27/2010)
Grant Fritchey (4/27/2010)
Brandie Tarvin (4/27/2010)
"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
April 27, 2010 at 8:15 am
Brandie Tarvin (4/27/2010)
"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
April 27, 2010 at 6:52 am
If you're keeping your database code in source control (which, if you're not, you should), you either need to use the drop/create or you have to maintain two sets 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
April 27, 2010 at 6:51 am
And when you're unsure of what the optimizer will do with a query, take a look at the execution plan. That'll give you the information 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
April 27, 2010 at 6:47 am
Paul White NZ (4/27/2010)
Grant Fritchey (4/27/2010)
"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
April 27, 2010 at 6:40 am
Everyone does it differently, so there's no hard and fast rule. Plus, it's really dependent on your business needs.
These are some general guidelines, but you'll need to customize them.
Run DBCC...
"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
April 27, 2010 at 6:22 am
Let's put it this way. Your disaster recovery is only as good as the last backup. You're capturing the logs once an hour. That means, in a really serious failure,...
"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
April 27, 2010 at 5:50 am
2cams (4/27/2010)
I ran this query
SELECT SUM(unallocated_extent_page_count) AS [free pages],
(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]
FROM sys.dm_db_file_space_usage;
Free Space...
"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
April 27, 2010 at 5:47 am
yatish.patil (4/27/2010)
we need this to be done on last day of every month.
It's only 60,000 rows. That's not a trivial data set, but it's not that large. You should 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
April 27, 2010 at 5:40 am
First off, setting your transaction to read uncommitted and setting nolocks on the reads is redudant & wasteful. Second, just becaue you put nolock everywhere doesn't mean you can eliminate...
"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
April 27, 2010 at 5:28 am
Paul White NZ (4/27/2010)
Is there an award for writing the world's worst procedure?If so, this is a real contender:
http://www.sqlservercentral.com/Forums/Topic910833-392-1.aspx
I just don't know where to start with a reply.
That's not even...
"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
April 27, 2010 at 5:22 am
Paul White NZ (4/27/2010)
http://www.microsoft.com/sqlserver/2008/en/us/why-upgrade.aspx
No doubt there are very good reasons to upgrade, but two years into the cycle and only, in theory, 18 months from the next version... waiting 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
April 27, 2010 at 5:18 am
The problem you're experiencing is very straight forward. Look at the documentation from BOL that I provided:
The columns that are being modified in the view must reference the underlying data...
"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
April 26, 2010 at 7:34 pm
Viewing 15 posts - 15,331 through 15,345 (of 22,219 total)