If I'm reading this correctly, you have:

Select leagueplayer, ltID, approved From leagueplayers ltID= xID

What I would expect to see in a SQL Server query is something like this (cleaned up...

I've seen the optimizer choose to do index scans rather than table scans, even when the difference shouldn't matter. In this case, it sounds like it's a better index than...

Yeah, always more than one way to skin a cat.

If I understand the question, you could add an extended property to identify the current version of the procedure.

You'll have to walk through the databases on the server. Try something like this. It'll work, but it's not perfect.

sp_msforeachdb 'select DB_NAME() AS ''DBName''

FROM INFORMATION_SCHEMA.TABLES t

WHERE t.TABLE_NAME = ''Customer'''

I agree with what most everyone has posted here. We have ten questions we ask everyone. They're really easy questions, insulting even, if you know SQL Server to even a...

Make sure you do the initial read to get the next 100 unflagged records with UPDLOCK (update lock) so that those records are no longer available for the next user...

Sorry, I'm just not that acquainted with the details of implementation any more. I wrote a whole app against direct calls to ODBC about 13 years ago, but... It's all...

Sorry, missed 3) I agree. Cursors are a killer. It doesn't much matter if it's client or server side. However, if you're talking disconnected, then client side is the least...

I don't know, I've seen your posts, Jack. You look pretty knowledgeable. I know I could learn from you.

BTW, we are hiring over here in the Island of Rhode (aka...

diallonina (2/29/2008)

Let me know your views and your experiences concerning this:

1-A SQL consultant told me that SQL performance was better when it connects/deconnects to every request by...

Not a problem.

You want one more, take a look at the execution plan and be sure that it's using a good index to select the record. You might be doing...

Nice article Kathi. Good job.

This article[/url] covers the basics on backups in 2005.

When you say database integrity, do you mean, data integrity as defined by primary keys, foreign keys, constraints, etc. or are you looking at database consistency and running the database...