Viewing 15 posts - 16,651 through 16,665 (of 22,226 total)
It depends on your system, the business requirements, the types of transactions... There's no one right answer. I manage systems that if I saw blocks going past 10 seconds I'd...
"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
August 31, 2009 at 6:14 am
That's a huge topic and one that you're unlikely to get a complete answer in a post like this. First question, slow as compared to what? From what you're saying,...
"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
August 31, 2009 at 6:12 am
I'm not logged in from home, putting in extra time, working on extra projects and especially I'm not cruising the boards at SSC... CRAP!
"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
August 29, 2009 at 2:46 pm
You guys are all getting about 20 people per meeting. We're getting ready to start our fourth year and still only have about 10 per. It's tough.
"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
August 29, 2009 at 2:31 pm
Roy Ernest (8/28/2009)
"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
August 28, 2009 at 3:45 pm
Lynn Pettis (8/28/2009)
Anybody else get an email via SSC from pboyall969@xxxxxxxxxx requesting help to purge all the tables in a database?
Not yet. They must know who the nice people are.
"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
August 28, 2009 at 8:32 am
Steve S (8/28/2009)
I was thinking about an 'Active\Active' clustering...
"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
August 28, 2009 at 7:57 am
I'm sure the article will kick up more mud. Interestly enough, most of the Agile projects at my company have failed. The constant redesigns and refactoring was leading to little...
"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
August 28, 2009 at 7:01 am
davidandrews13 (8/28/2009)
select * from table1 where SomeDate between '2009-01-01 00:00:00' and '2009-08-28 23:59:59'is something like this what your looking for?
Try this instead:
SELECT *
FROM table1
WHERE SomeDate BETWEEN CAST('2009-01-01 00:00:00' 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
August 28, 2009 at 6:32 am
Lowell (8/27/2009)
"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
August 28, 2009 at 6:27 am
I'd recommend the Inside SQL Server series. You'll be hard pressed to find better information. Specifically I'd suggest getting "T-SQL Querying" by Itzik Ben-Gan, "The Storage Engine" by Kalen Delaney...
"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
August 28, 2009 at 6:25 am
We've been doing an A/B switch with a database rename. Downtime is measured in seconds, but it's absolutely there. I'm not aware of a way to do this without impact...
"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
August 28, 2009 at 5:45 am
j.bradshaw (8/27/2009)
"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
August 27, 2009 at 7:06 pm
I would suggest using the dynamic management view sys.dm_tran_locks. That will show what is locking, the type of locks, the session holding the lock... You get the idea.
"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
August 27, 2009 at 12:19 pm
Oops. I forgot to add a link to the blog.
"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
August 27, 2009 at 11:18 am
Viewing 15 posts - 16,651 through 16,665 (of 22,226 total)