I'm sorry but I don't see what it has to do with lookups. Notice that I had 2 queries. Both of them had the same criteria. ...

GSquared (12/17/2012)

---

Something that many don't know about SARGability is that some functions, regardless of side of equation in a Where clause, are SARGable.

Try this:

SET NOCOUNT ON;

USE ProofOfConcept;

GO

CREATE TABLE dbo.SARGTest (

DT...

Andre Ranieri (12/17/2012)

---

if the left side of the equal sign is a calculation, then the WHERE clause is "non sargeable", meaning that the optimizer can't use simple search arguments and...

I'm assuming that you want the user to be able to run a specific job and not all jobs. If I'm correct, then you can do it using the...

You have an extra from after the key word where. If you'll delete it, then there is a good chance that it will work. I would also specify...

You can modify the SQL Statement so it will get 2 parameters each time, but won't always use both of them. Here is a small example that is based...

Rebuilding the clustered index rebuilds the whole table. If the table is a heap you can rebuild the table with alter table statement (but most chances are that creating...

I apologize, I don't know how I didn't notice that I didn't paste the URL into the message. Glad that...

After a short time (don't remember if he said how long), they ran out of business.

Adi

To add a bit about the second question. At Pass summit 2011 Paul Randle had a presentation that he told about a bank that had one old full backup...

Using sp_configure to modify the default language will work on new logins that will be created without specifying the logins' default language. It will not modify an existing login....

Check the fallowing URL. I know that it is for SQLNCLI and not SQLNCLI10, but I've seen few references to this page by people that had this problem when...

You need to remove the alter table statement from the procedure. With it, the procedure can work only the first time that it runs. After the column was...

Allocation in files belonging to tempdb is done using proportional fill. It means that when the files have the same size the allocation will be distributed across all files....

There is no need to copy screen shot into the message. Instead, it is better to have a small SQL Scripts that simulates your problem. The script...