Viewing 15 posts - 39,901 through 39,915 (of 49,552 total)
rodney.williams (4/7/2009)
I did receive the 1 row(s) was affected message.
That wouldn't have been from the trigger. Because NOCOUNT is on, it won't return the n rows affected message.
1)...
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
April 7, 2009 at 12:15 pm
Michael Valentine Jones (4/7/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
April 7, 2009 at 11:58 am
Well, multiple redundant indexes give you no additional read benefit over having just one index, however when the data is changed all of those indexes have to be updated.
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
April 7, 2009 at 11:38 am
http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/
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
April 7, 2009 at 11:35 am
Sometime between 7am and 8am there's a job running that either switches the DB to simple recovery and back to full or executes a BACKUP LOG ... WITH TRUNCATE ONLY.
My...
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
April 7, 2009 at 11:22 am
Jeff Moden (4/7/2009)
I sometimes have a similar problem with age... most young folks look at my white beard and chuckle about what Santa Clause might know about databases.
Similar...
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
April 7, 2009 at 11:19 am
It's multiple choice, but some of the questions are so long that they're almost case studies by themselves.
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
April 7, 2009 at 9:34 am
You do need to be familiar with the new 2008 features. Whether Transcender's good enough, I can't say. Never seen their test exam.
Check the requirements list on the MS website...
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
April 7, 2009 at 9:23 am
Here you go. This will work no matter whether you update one row or one thousand rows.
I don't know how well unpivot works on larger row sets, but it...
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
April 7, 2009 at 9:14 am
It has to be done by an admin. Use the Report button and request that the thread be moved.
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
April 7, 2009 at 8:55 am
So you do need a join between users and usersubscriptions, which you did not have in your initial query and which my rewritten one did.
Still, you know the data, you...
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
April 7, 2009 at 8:27 am
There was no need to repost the question in this case. I have requested that the other one be moved to the 2000 forums.
No replies to this thread please, direct...
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
April 7, 2009 at 8:24 am
Because of the way page allocations are done for very small indexes, they will almost always be fragmented. It's nothing to worry about, fragmentation is only a concern when you'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
April 7, 2009 at 8:19 am
Sure. Look at the join conditions and look for cases where two (or more) tables aren't related to each other in any way. Take this as an example
SELECT * FROM
...
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
April 7, 2009 at 8:08 am
What's the primary key of the Employee table?
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
April 7, 2009 at 8:06 am
Viewing 15 posts - 39,901 through 39,915 (of 49,552 total)