There are several ways of handling these kinds of problems, and it's hard to provide specifics without more information on your table structures and so forth. However, here's a quick...

Excellent! Glad you've got it resolved.

The error means pretty much what it says; you've got multiple instances there where you're trying to SUM an expression that contains a SUM. SQL Server won't let you do...

You can right-click on the maintenance plan and select "View History" to verify if it has been running (and if so, if it failed). Do the same with the SQL...

Out of the 200,000,000 rows in the table, how many match your search predicate? Also, can you please generate and post the actual execution plan? (To get the actual plan,...

Definitely start by reading the article Gail linked.

It's pretty important to have a basic understanding of how the SQL Server transaction log works, how the different recovery models work,...

I've been using SSMS 2008 exclusively in an environment that includes a mix of 2005 and 2008 servers (and one lonely 2000 server that refuses to go away...) for some...

It's technically possible, you can create a UDF that executes a query against a different table, and then call that UDF in your CHECK constraint. This MSDN page on CHECK...

okbangas (10/28/2011)

---

JonFox (10/27/2011)

---

Index fragmentation shouldn't have an impact on whether the query optimizer chooses a scan over a seek; the optimizer tries to minimize reads when choosing a query plan,...

Index fragmentation shouldn't have an impact on whether the query optimizer chooses a scan over a seek; the optimizer tries to minimize reads when choosing a query plan, but index...

Oh absolutely, it was an excellent thing to point out. Thanks!

@Bitbucket I guess it depends on what Walton is actually trying to do. I was assuming that for his purposes 13 and 13.0 were equivalent; that very well...

You could compare the passed value with the FLOOR() of the passed value and see if they are different. For example:

IF @Param1 = FLOOR(@Param1)

PRINT...

I think you're looking for something like this:

SELECT A.First_Name, A.Last_Name, A.Post_Code, A.Address_Line_1, B.NumAtThisAddress

FROM Pers_Static_Personnel_History AS A INNER JOIN

(

SELECT Post_Code,

Address_Line_1,

COUNT(Post_Code) AS NumAtThisAddress

FROM Pers_Static_Personnel_History

GROUP BY...

Ok, after scanning the whitepaper that okbangas linked earlier, at least part of my theory appears to be wrong; dropping the index should have caused a full recompile of the...