Viewing 15 posts - 13,051 through 13,065 (of 22,219 total)
The message is pretty clear. Something is holding a lock on that file.
I used to get that at my old job when the process that copied our backups off to...
"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
March 13, 2011 at 11:32 am
On the performance end, follow Jeff's advice. I usually do. On the coding side, you can tell just looking at it that the parameter sizes are based on the values,...
"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
March 13, 2011 at 5:41 am
I'm misunderstanding what you're asking for here. Do you want a script that performs backups or do you want a script that reports on what backups have been completed?
"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
March 12, 2011 at 4:54 am
Indianrock (3/11/2011)
Yes the developers use an ORM to generate most of the sql. C# .net
so you need to attack this from two fronts. Yes, you need to work...
"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
March 12, 2011 at 4:30 am
GilaMonster (3/12/2011)
Anyone got any suggestions for here: http://www.sqlservercentral.com/Forums/Topic1077027-392-1.aspx
took a stab at it.
"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
March 12, 2011 at 4:21 am
Is that column a char or a varchar?
"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
March 12, 2011 at 4:21 am
Indianrock (3/11/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
March 11, 2011 at 2:53 pm
Stefan Krzywicki (3/11/2011)
Grant Fritchey (3/11/2011)
Stefan Krzywicki (3/11/2011)
Grant Fritchey (3/11/2011)
GSquared (3/11/2011)
GilaMonster (3/11/2011)
I signed off two official design documents back at the bank as "Database Overlord". No one commented.
I, for one, welcome...
"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
March 11, 2011 at 11:43 am
Stefan Krzywicki (3/11/2011)
Grant Fritchey (3/11/2011)
GSquared (3/11/2011)
GilaMonster (3/11/2011)
I signed off two official design documents back at the bank as "Database Overlord". No one commented.
I, for one, welcome our new reptilian overlords...
"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
March 11, 2011 at 11:34 am
That's where natural keys come into play. It sounds like you've got an IDENTITY field or a GUID that's handling uniqueness for a given row, but, that doesn't define logical...
"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
March 11, 2011 at 11:26 am
GSquared (3/11/2011)
GilaMonster (3/11/2011)
I signed off two official design documents back at the bank as "Database Overlord". No one commented.
I, for one, welcome our new reptilian overlords ....
(Now I can't remember...
"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
March 11, 2011 at 11:23 am
You might want to start to look at tools like Visual Studio Team System or Red Gate SQL Source Control as a mechanism for implementing deployment processes that allow 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
March 11, 2011 at 9:29 am
Koen Verbeeck (3/11/2011)
I see what you did there 😛 :hehe:
You set 'em up, I'll knock 'em...
"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
March 11, 2011 at 8:07 am
I would look at breaking down the process and doing a chunk of it each night. Considering the size of your system, you should probably be updating the stats 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
March 11, 2011 at 7:57 am
In general... I'd say that running FreeProcCache is almost never a good solution. If you rebooted the machine, the procedure cache was flushed. That is not maintained from one startup...
"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
March 11, 2011 at 7:51 am
Viewing 15 posts - 13,051 through 13,065 (of 22,219 total)