Viewing 15 posts - 29,116 through 29,130 (of 49,552 total)
If there's an index on c1 and/or c2 then SQL may decide to seek on one (or both) and evaluate the udf only on the rows returned from them. Or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2010 at 4:41 am
It depends on the execution plan that the optimiser picks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2010 at 3:16 am
Wow.
I for one am not helping out any further. I won't be a part to what looks unethical and maybe even illegal. Honestly, if I were in your shoes I'd...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2010 at 1:23 am
Jeff Moden (11/29/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 10:55 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 10:35 pm
Do not even consider touching the system tables. They are not there for you to edit. There's a reason that 'allow updates' was disabled on SQL 2005+.
if i cant...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 10:35 pm
Honestly, my suggestion would be to leave it on and then have jobs (daily, hourly, etc) that do an update stats with full scan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 10:33 pm
Err, please read what I asked for.
I said I want to see the results of that query with the page count included and that record_count, ghost_record_count and fragment_count are not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 10:17 pm
Index rebuilds can easily cause corruption (normal corrupt pages) to disappear as the process of rebuilding deallocates the damaged page. I'm going to consult an expert on corruption as to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 2:26 pm
WayneS (11/29/2010)
It was meant in a good way... I knew you had just finished up your masters...
More like 'finishing' 🙂
I started working after doing my Hons degree (B.Sc Honours,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 1:27 pm
RamSteve (11/29/2010)
Hi Can some one shade light on pros and cons of DR solutions
There have been entire books written on that topic.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 12:56 pm
SQL can support a hell of a lot more than a medium-sized forum.
MySpace runs on SQL Server
NASDAC (stock exchange) runs on SQL Server
Pacific telco (iirc) runs on SQL Server
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 12:48 pm
WayneS (11/29/2010)
But either way...Jeez, that means you're older than I thought you were. 🙁
Not quite sure how to take that. I'm 34 in a week and a day's time. 1994...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 12:47 pm
How else is the optimiser going to get cardinality estimate for remote tables so that it can generate a good execution plan?
It's not something that people see often, and that's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 12:42 pm
I didn't say it was trying to update statistics. I said it was trying to get statistics. As in read the existing statistics that are there. As in asking the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 29, 2010 at 12:20 pm
Viewing 15 posts - 29,116 through 29,130 (of 49,552 total)