Viewing 15 posts - 43,021 through 43,035 (of 49,552 total)
If you don't already have some form of auditing in place, there's no way you're going to identify historical events. If you're setting up auditing, then you can use 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 22, 2008 at 12:34 am
Jonathan Kehayias (11/21/2008)
how to write badly performing code which I have always wondered how to do. 😀
😛
Congrats on the award. I intend to take the app for 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
November 22, 2008 at 12:27 am
Lynn Pettis (11/22/2008)
Ahh geez, Gail, you're taking the fun out of it! :P;)
Oh, I'm sorry. I'll play dumb next thread... 😉
11pm Seattle time and I'm checking the forums. still...
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 22, 2008 at 12:25 am
venkat (11/21/2008)
Hi,Do you know I'm a Sr. DBA. Some times I am full bizzi thats why I'm sending forum response for finding easiest and fastest way.
A senior DBA who...
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 22, 2008 at 12:15 am
The transaction log is not there for auditing purposes. If you're wanting to audit data changes, look at triggers. DML triggers to capture data changes, DDL triggers to capture schema...
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 22, 2008 at 12:03 am
I don't have time right now to try and rewrite your entirequery, especially not without table schemas or sample data. Look at the sample update statement I posted above and...
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 21, 2008 at 11:57 pm
Jeff Moden (11/21/2008)
Another favorite are those that ask things like "which would be faster" and they post the code for both... talk about "lazy". :hehe:
Yeah, but at least those are...
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 21, 2008 at 11:56 pm
does that login have a mapped user in that database/
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 21, 2008 at 3:09 pm
The different settings may cause problems. Make the settings in management studio the same as in the app and see what behaviour you get.
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 21, 2008 at 3:09 pm
Don't have time to rewrite it now.
Can you try moving the subquery with the sum into the from clause and treating it as a derived table? I know it's 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 21, 2008 at 3:08 pm
There are articles on my blog on parameter sniffing.
Were all the parameter values the same? All the options (ansi_nulls, etc) the same?
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 21, 2008 at 1:58 pm
Don't shrink. Even with the notruncate, you will badly fragment your indexes. There's little gain in moving the free space to the end of the file.
There will be no change...
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 21, 2008 at 1:38 pm
Parameter sniffing?
Did you run the proc from management studio, or did you run the contents?
Can you post the proc?
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 21, 2008 at 1:27 pm
Anything in the event log? Anything in the error log?
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 21, 2008 at 1:24 pm
Right. Now we can talk about this.
Consider moving the subqueries into the from clause of the update. I can't rewrite the entire things now, I'm in a presentation.
So, the general...
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 21, 2008 at 11:33 am
Viewing 15 posts - 43,021 through 43,035 (of 49,552 total)