Actually, no I just misread it.

Make sure that statistics exist on the columns...

now it seems to select all of them.

Except the linked article doesn't mention anything about uniqueness constraints.

valeryk2000 (2/16/2012)

---

It handles perfectly the other way - when I insert into SQL table and set the parameter

cmd.CreateParameter("@CaseSummary", adLongVarWChar, adParamInput, -1, IIf(IsNull(txtCaseSummary.Value), Null, txtCaseSummary.Value))

So Access 2003 handles something at...

I still use it manually with no trouble, but I came up with this for when we restore production to a test environment.

EXEC sp_msforeachdb '

USE [?];

DECLARE @cmd NVARCHAR(MAX)

SELECT

@cmd =...

I don't believe Access 2003 will handle nvarchar(max)

The SQL Backend is fine with it, the Access front end is not. So in this case I'd make the client do...

Better would be to calculate the date back and use the date for the comparison.

Using non-deterministic functions on date columns in where clauses is generally a no-no... if there are...

YSLGuru (2/10/2012)

---

Do any of you who have to create or modify document/letter style reports and who have worked with Crystal and SSRS, do you find it easier, harder or the...

Daniel Bowlin (2/10/2012)

---

So I read the article and ran the query for missing indexes ordered by performance impact.

The first 4 missing indexes were for the same table. Take...

5) Check for any table or Index scans. Using the execution plan, it's easy to identify if the SQL statement is performing any table or index scans. In the majority...

Doesn't work with Clustered instances. Or with default instances

SET @instanceName = CONVERT (VARCHAR,SERVERPROPERTY ('ComputerNamePhysicalNetBIOS')) + '\' + CONVERT(VARCHAR,SERVERPROPERTY('InstanceName'))

Will return Null for a default instance and NULL out @instanceName

It will...

Grant Fritchey (2/7/2012)

---

mtassin (2/7/2012)

I don't see different query plans with 4136 on or off, I see vastly different performance with respect to response times. So much so that I...

GilaMonster (2/7/2012)

---

What 'new variant of parameter...

GilaMonster (2/7/2012)

---

mtassin (2/7/2012)

---

Personally dealing with parameter sniffing I prefer Traceflag 4136. ...

Actually it was the commented section in the query that says "this errors out and isn't what I was expecting"

I originally just changed the path to the file and ran...

Personally dealing with parameter sniffing I prefer Traceflag 4136. 🙂