Stefan_G (3/22/2010)

---

Paul White NZ (3/21/2010)

---

In addition, only one of the methods presented so far is SARGable - meaning that an index seek might be used. The other methods all...

Here is another option:

declare @JDate int;

set @JDate = 2010032;

select dateadd(dd, ((@JDate % 1000) - 1), DATEADD(yy, ((@JDate / 1000) - 1900), CAST('1900-01-01' as datetime)))

amandix (3/22/2010)

---

I have increased code for doing so many thinks... but it's not the point.

The question is: is it possible to do it in SQL 2008, like it was in...

To use xp_cmdshell in SQL Server 2005 you have to enable it using the Surface Area Configuration program as it is disabled by default.

Check Books Online for additional information.

First, you should not use the SET ROWCOUNT to limit the number of rows processed in SQL Server 2005/2008. This has been marked for depreciation in future versions of...

There will be one small issue you may need to verify, any logins whose default database is MyDB (the one you are moving via detach/attach) will probably need fixing after...

wbeaton-664441 (3/18/2010)

---

3 of the 4 options are correct. But, this statment can't be true:

"Reducing the physical size of a log file requires shrinking the file."

You can truncate a transaction...

Natalie C (3/20/2010)

---

Lynn Pettis (3/20/2010)

---

Paul White NZ (3/19/2010)

---

Lynn Pettis (3/19/2010)

---

Partitions are great, but you have to running the Enterprise Edition to use them. So, with that, are you running...

Paul White NZ (3/20/2010)

---

Lynn Pettis (3/20/2010)

---

Okay, I must be brain dead (I am trying to do my taxes, very mind numbing) plus I already trashed my test suite, care to...

Paul White NZ (3/20/2010)

---

Lynn Pettis (3/20/2010)

---

Thinking about it, it may have been done inside a WHERE clause, not the ON portion of JOIN clause. Just not enough time to...

Interesting idea. I think it would be good idea and perhaps implemented by extending the RESTORE statement, perhaps RETAIN_OLDDB with maybe a couple of options to it.

Curious what others...

To accomplish what you are attempting, you will actually need to use dynamic sql. The code as written is failing when it is being parsed, not when it is...

Thinking about it, it may have been done inside a WHERE clause, not the ON portion of JOIN clause. Just not enough time to go searching through the forum...

Lynn Pettis (3/20/2010)

---

Paul White NZ (3/20/2010)

---

You might want to check that over Lynn 😉

The boolean logic expression is correct, but the code isn't...!

Usually we use this trick to transform ORs...

Paul White NZ (3/20/2010)

---

You might want to check that over Lynn 😉

The boolean logic expression is correct, but the code isn't...!

Usually we use this trick to transform ORs into ANDs,...