Viewing 15 posts - 4,111 through 4,125 (of 14,953 total)
mtillman-921105 (6/6/2011)
Richard Warr (6/6/2011)
toddasd (6/6/2011)
June 6, 2011 at 10:59 am
Richard Warr (6/6/2011)
toddasd (6/6/2011)
June 6, 2011 at 10:44 am
mtillman-921105 (6/6/2011)
June 6, 2011 at 10:39 am
Have you tried adding the XSINIL tag to the For XML statement?
June 6, 2011 at 10:30 am
The Merge command is, in some ways, better than Update From, in SQL 2008. Check out Merge when it comes to synchronizing data like this.
June 6, 2011 at 9:02 am
Since the fix involved either applying a CU (probably not applicable to R2), or restarting change tracking, I'd either contact Microsoft support and ask about the CU, or restart change...
June 6, 2011 at 9:01 am
There's probably a query in the tables or views that uses an older-style join. You mentioned you checked the views, but did you check for things like calculated columns...
June 6, 2011 at 6:43 am
The other thing to be aware of with global temp tables is not just that they can go away, but also that you can end up with errors if you...
June 6, 2011 at 6:39 am
I would expect an SQL Server DBA to know enough about Active Directory to leverage it for security and control. That would include knowledge about things like double-hop security...
June 6, 2011 at 6:36 am
Because there are 32-bit and 64-bit drivers. Unless you can be certain only one or the other will ever be used, you're probably better off leaving both running.
June 6, 2011 at 6:24 am
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
June 5, 2011 at 9:24 am
Jeff Moden (6/4/2011)
GSquared (6/3/2011)
I'd change that "LIKE" statement to something a little more REGEX-ish.
CREATE TABLE #T (DT CHAR(10))
INSERT INTO #T (DT)
VALUES ('1/1/11'),('01/01/2011'),('1.1.11'),('1-1-11'),('Bob');
SELECT *
FROM #T
WHERE DT LIKE '%[/.[-]]%[/.[-]]%';
Wouldn't that allow for...
June 4, 2011 at 10:45 am
Yeah, that makes sense (on the snapshots bit).
On the block/lock issue, I tend to suspect there's either a missing NoLock hint, or something similar. I've seen lots of queries...
June 3, 2011 at 2:08 pm
Scan vs seek has nothing to do with it being a covering index. Covering indexes prevent bookmark lookups.
The plan probably changes because of the stats on the join. ...
June 3, 2011 at 1:56 pm
jcrawf02 (6/3/2011)
GSquared (6/3/2011)
No. I was thinking of a more ... metaphorical ... manure.I know salespeople who shovel manure all day on the phone. But it's not really multitasking.
Ah,...
June 3, 2011 at 1:53 pm
Viewing 15 posts - 4,111 through 4,125 (of 14,953 total)