Viewing 15 posts - 38,101 through 38,115 (of 49,552 total)
Mike, I just did some tests myself and, while I do see a small increase in reads, it's not overwhelming.
Use Adventureworks
GO
Create function LineItemTotal(@ProductID int)
returns money
as
begin
declare @Total money
select @Total = sum(LineTotal)...
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
June 28, 2009 at 7:09 am
Grant Fritchey (6/28/2009)
GilaMonster (6/28/2009)
Plus it's one plan per execution of the UDF. Also, you cannot trust statistics IO when you have a udf that does any form of data access.
I'm...
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
June 28, 2009 at 6:44 am
mike_walsh (6/28/2009)
GilaMonster (6/28/2009)
Plus it's one plan per execution of the UDF. Also, you cannot trust statistics IO when you have a udf that does any form of data access.
Hey Gail...
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
June 28, 2009 at 6:43 am
BillDenver (6/28/2009)
You're up early.
Not particularly early. I'd just finished lunch when I wrote that.
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
June 28, 2009 at 6:03 am
I'll do some tests during the week and write up a blog post if I can come to any conclusions.
Actually, I'll blog even if I can't come to a...
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
June 28, 2009 at 6:02 am
Plus it's one plan per execution of the UDF. Also, you cannot trust statistics IO when you have a udf that does any form of data access.
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
June 28, 2009 at 5:44 am
aniket (6/27/2009)
and while saving if the new date is not assigned to the BDate, then 1/1/1900 12:00:00 AM is stored in the database.
So how are you doing the save 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
June 28, 2009 at 5:40 am
BillDenver (6/28/2009)
Tried to reinstall but cannot get past the error. Any ideas?
Not offhand. Does google turn up any suggestions?
Why do you need management studio on the 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
June 28, 2009 at 5:39 am
Call Microsoft's Customer support. You've got stack dumps there, I don't have the tools to interrogate those and I don't have SQL source code. Customer support has both.
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
June 28, 2009 at 5:39 am
Phil Jackson (6/27/2009)
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
June 28, 2009 at 3:23 am
Dropping an index that's used for enforcing of a pk constraint isn't allowed. To drop the index that's enforcing a pk, the pk itself must be dropped/
CREATE TABLE Test1 (
...
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
June 28, 2009 at 3:22 am
Lynn Pettis (6/27/2009)
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
June 28, 2009 at 2:51 am
You're only restoring the full backup there hence only the full backup will be restored. To get to 9AM, you have to explicitly restore the 8AM diff and 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
June 28, 2009 at 2:50 am
Try restarting the service again, not single user, just normally. If things still don't come right, I would suggest that you contact Microsoft's CSS people. They will charge, but they're...
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
June 28, 2009 at 2:48 am
Lynn Pettis (6/27/2009)
3NF -- The Key, The Whole Key, and nothing but The Key.
Didn't realise anyone else knew that mnemonic. I learnt it at university as an easy way 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
June 27, 2009 at 3:34 pm
Viewing 15 posts - 38,101 through 38,115 (of 49,552 total)