Viewing 15 posts - 12,961 through 12,975 (of 22,224 total)
I still think something occurred during the restore. It looks like litespeed was functioning and the server had access, but something happened. Get to the full error log and I...
"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 23, 2011 at 8:35 am
Yeah, I'd say it sounds fairly reasonable. As long as the Posh script isn't adding to the overhead on your systems. You can just use perfmon to spit out the...
"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 23, 2011 at 8:10 am
That doesn't look like a complete error message. Since the error is from LiteSpeed, I'd check the log there and see what 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
March 23, 2011 at 8:07 am
Jeff Moden (3/23/2011)
Grant Fritchey (3/23/2011)
...duck tour should be a blast.Heh... not sure duck hunting season is open right now. 😛
The last time I spelled it properly, DUKW, people were confused.
"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 23, 2011 at 7:35 am
SQLkiwi (3/23/2011)
Grant Fritchey (3/23/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 23, 2011 at 7:13 am
And if you toss in something like multi-statement table valued functions the cost can be shown as zero when it is in fact extremely high.
Costs are indicators, but they 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
March 23, 2011 at 5:55 am
Well, you can try plan forcing. that allows you to take a valid plan and make the engine use it when you run the query. It's not executing the 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
March 23, 2011 at 5:53 am
As someone who had to look at tons and tons of resumes for hiring DBAs, I look for experience, not certification or formal education. I care about what you know...
"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 23, 2011 at 5:48 am
There's always the old-fashioned way. Create the database uncompressed and compressed side-by-side and compare. That's what I did when I was first checking it out. But you know, the storage...
"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 23, 2011 at 5:45 am
SQLkiwi (3/22/2011)
David Benoit (3/22/2011)
Um - but now the event is full.
Just checked with the organizers and SQLSat71 is not full per se - at least the registration cap hasn't been...
"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 23, 2011 at 5:41 am
laddu4700 (3/22/2011)
how many ways can we create reports in SQL Server 2005, what is the easy and comfortable way to provide report to user
How many ways can 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 23, 2011 at 5:30 am
I don't have a 2005 SSMS to check this, but in 2008, you can right-click on Jobs and open the Manage Schedules window. It shows all the existing schedules for...
"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 23, 2011 at 5:26 am
sppdba (3/22/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 22, 2011 at 3:41 pm
Stefan Krzywicki (3/22/2011)
Grant Fritchey (3/22/2011)
Brandie Tarvin (3/22/2011)
Oh, hey, completely non-SQL related link:If you like superheroes, you will like "Grayson" (They created this trailer with an 18,000 dollar budget).
Makes me...
"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 22, 2011 at 1:46 pm
It depends on the DMV. Many of the most interesting ones about query performance are completely dependent on the cache. Others work off the last time SQL Server was restarted...
"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 22, 2011 at 1:42 pm
Viewing 15 posts - 12,961 through 12,975 (of 22,224 total)