SanDroid (4/25/2011)

---

Seems this only happens If you order the output of a radom set by a row of newid values being created during the same transaction to delete values...

Jason,

It's crucial to test those backups. Without that, there's no way to know whether or not they're actually good. We've been battling some drive issues where I work...

I'm pretty sure I'm doing better but I'm in week two of a new job so I may be wrong. I did get a significant increase coming here as...

Sad indeed but I have to say I would be very tempted to...

From what I've seen, big part of the quality control is in the people that answer the question....

I think this is probably along the lines of what you're looking for. You don't need to reseed to 0, it can be any value you want:

SET ANSI_NULLS ON

GO

SET...

Amen to that.

Time (yes, it's a time savings to do it right but no time...

lancebeacroft (3/28/2011)

---

My problem with the solution here is that the DBA is changing the code without the advantage of Alter or drop/create procedure. Would SQL server then regenerate the query...

paul.knibbs (3/25/2011)

---

I disagree here. Licensing per core is all well and good, but you might well end up paying to license a feature you don't want and never use! I'd...

Unless there's a character other than the three big ones I know that could...

Since the example doesn't do any concatenation I wouldn't assume that it's referring to the situation that the article is discussing.

USE AdventureWorks2008R2;

GO

DECLARE @EmpIDVariable int;

SELECT @EmpIDVariable = BusinessEntityID

FROM HumanResources.Employee

ORDER BY BusinessEntityID...

One of the things the shop I work in has missed is staying ahead of clients in testing different load levels. We made an architectural decision with a recent...

One of the threads where a method like this was discussed someone from MS came on and said that it relied on an undocumented feature in the query optimizer that...

I work on an Electric Health Record so HIPPA has a huge affect on how we do things. Not just in coding the application but in supporting it as...