Viewing 15 posts - 33,136 through 33,150 (of 49,552 total)
The equivalent with IN would be
SELECT Members.FirstName, Members.LastName
FROM Members
WHERE Members.MemberID NOT IN (SELECT MembersQuizzes.MemberId
FROM MembersQuizzes
WHERE MembersQuizzes.QuizId =...
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 29, 2010 at 4:38 am
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
Does this work? (Untested as I didn't feel like converting the raw data you posted into insert statements)
SELECT Members.FirstName, Members.LastName
FROM Members
WHERE NOT EXISTS (SELECT 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 29, 2010 at 4:34 am
@@Error will show you the error code of the previous statement. If the previous statement failed, it will be non-zero.
You can also use the TRY .. CATCH syntax (available 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 29, 2010 at 4:13 am
Try DBForums[/url]. They have a MySQL section.
This site is for Microsoft SQL Server, not MySQL. Different database platforms, there are differences in the SQL language that they use
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 29, 2010 at 4:05 am
gilproject (4/29/2010)
No, it's not curiosity, i looking for store procedure about this problem. do you know a procedure about it??
What problem? There's no documented way to read the transaction 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
April 29, 2010 at 4:03 am
Recovery models: http://msdn.microsoft.com/en-us/library/ms189275.aspx
Recovery and norecovery: http://msdn.microsoft.com/en-us/library/ms186858.aspx (about half way down)
If you still have questions after reading that, please ask.
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 29, 2010 at 2:03 am
Don't forget to set up log backups for all of the databases if you switch them to full recovery.
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 28, 2010 at 12:36 pm
sysname is an 'alias' for nvarchar of a particular length. so you can declare a variable of type sysname (handy when working with the system tables) and it's actually an...
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 28, 2010 at 7:52 am
Grant Fritchey (4/28/2010)
Will do. I was being lazy with the link and got caught. Sorry :crying:
No worries. I have it in shortcut menu. I don't go searching for it every...
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 28, 2010 at 7:51 am
Couple other articles that may be of interest: http://www.sqlservercentral.com/articles/Indexing/68439/ (3 parts)
Plus this may be of some use: http://sqlinthewild.co.za/index.php/category/sql-server/execution-plans/ and http://sqlinthewild.co.za/index.php/category/sql-server/indexes/
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 28, 2010 at 7:45 am
Coincidence. Just browsing a bit while making phone calls. I'm still staying mostly away from the forums for various reasons.
Please do post links to my stuff all over the place....
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 28, 2010 at 6:56 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic911504-1633-1.aspx
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 28, 2010 at 6:47 am
The ldf is the transaction log, a record of changes made to the database.
Why do you want to read it? It's not intended to be human-readable, it's for...
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 28, 2010 at 6:42 am
p.s. In SQL 2005, you cannot force an index seek. You can force an index to be used but you have no control over how it will be...
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 28, 2010 at 6:39 am
Pleasure.
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 27, 2010 at 1:41 pm
Viewing 15 posts - 33,136 through 33,150 (of 49,552 total)