bitbucket-25253 (3/28/2011)

---

Hugo Kornelis (3/28/2011)

---

It is...

Tom.Thomson (3/26/2011)

---

rmechaber (3/22/2011)

---

A fascinating and scary exploration of how SQL Server doesn't always follow ANSI syntax for dates:

http://www.karaszi.com/SQLServer/info_datetime.asp.

A salient quote:

Warnings and common misconceptions

Let me say this again: you don't want...

I haven't worked through this bookmarked site, but it looks tempting: http://msdn.microsoft.com/en-us/library/ff793463.aspx

Rich

Sean Lange (3/24/2011)

---

rmechaber (3/24/2011)

---

As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason:...

As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that...

"Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only the first one is used. "

From: http://technet.microsoft.com/en-us/library/ms159260%28SQL.90%29.aspx

As pointed out...

dave.farmer (3/22/2011)

---

Thanks for that - excellent article.

When trying some of the examples in there,...

A fascinating and scary exploration of how SQL Server doesn't always follow ANSI syntax for dates:

http://www.karaszi.com/SQLServer/info_datetime.asp.

A salient quote:

Warnings and common misconceptions

Let me say this again: you don't want to use...

I use OPENDATASOURCE, too. In addition to the gotchas mentioned above (64-bit, file must reside on server), you might also want to know:

- The filename must...

annasql (3/18/2011)

---

Thanks.

This is very helpful for me to undertand.

One point not sure is : when you say:"But if you've lost the Sunday full backup, those daily differential backups are...

To expand a bit on this: to perform a point-in-time recovery, you MUST have a full backup and all log backups performed between that full backup and the point in...

THANKS FOR CALLING ME STUPID. YOUR ARROGANCE OR SHOULD I SAY EGOTISM IS APPALING.

As aside, you really should spell check your work before posting or is "stupic" the...

Actually, it is handy to run the occasional SSIS package with a batch file. I have one in particular that is called daily with a SQL Agent, but I...

You may have other, less-obvious considerations. I work at a law school, and sometimes I have to be careful not give out lists of sanitized students and their courses...

Minor amendment: Copy-only backups http://msdn.microsoft.com/en-us/library/ms191495%28v=SQL.90%29.aspx

were implemented in...