Viewing 15 posts - 16,651 through 16,665 (of 22,229 total)
I'd suggest picking up a book like Itzik Ben-Gan's "Inside SQL Server T-SQL Querying" or Joe Sack's "Transact -SQL Recipes." You'll get a lot more concentrated information than from any...
"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:24 am
Just to pile on a bit, a well designed system may have 30 or 40 people calling a single stored procedure at the same time with very few issues. Relax...
"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:20 am
Assuming correct data in the parameters you're passing, this should update the data in the table. So, the problem has to exist elsewhere. What kind of trigger do you have...
"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:18 am
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
Viewing 15 posts - 16,651 through 16,665 (of 22,229 total)