Viewing 15 posts - 12,961 through 12,975 (of 22,219 total)
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
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 miss film making. 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 22, 2011 at 1:38 pm
GilaMonster (3/22/2011)
Brandie Tarvin (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 1:20 pm
Pei Zhu-415513 (3/22/2011)
Thanks. In other words, if it ran successfully, the production is clear off the corruption as of the time backup took place. But if it failed, you wouldn't...
"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 11:28 am
chandan_jha18 (3/22/2011)
Grant Fritchey (3/22/2011)
You're getting a scan on one table, overall, the system...
"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 6:21 am
It's hard to do more than suggest general approaches based on the information provided.
The one concern I would have with the existing structure: what do the cluster indexes look like?...
"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 5:19 am
Viewing 15 posts - 12,961 through 12,975 (of 22,219 total)