pjjaad (4/14/2011)

---

Backups, perfomance tuning , indexation et all are all going to be done without a human being having to have a single technical skill that current DBA's utilise. Automation...

Grant Fritchey (4/14/2011)

---

Thanks, but if you like the first one, the rewrite will blow your socks off. It really is going to be better (although, worth noting having made that...

Duncan Pryde (4/13/2011)

---

Try this:

SET DATEFORMAT ydm

GO

SELECT CAST('2011-04-28' AS DATETIME)

or this:

SET LANGUAGE...

Grant Fritchey (4/14/2011)

---

GilaMonster (4/14/2011)

---

Grant Fritchey (4/14/2011)

---

I'm looking at multiple books and articles and blog posts over the last eight years or so and I don't doubt for one second I've...

Steve Jones - SSC Editor (4/12/2011)

---

Everyone will get points back and I have corrected the question. Apologies for not fixing this earlier.

You do not have to post to get points...

Datalength doesn't take into account...

Me either... I was pretty sure 2011-04-28 was a dateformat neutral date... 🙁

Just a...

Grant Fritchey (4/6/2011)

---

My favorite software for doing this is Embarcadero ERStudio. It meets all your requirements and quite a few more. If you're going to work on your databases through...

I got this right, but the answer should be reworded that the LAST INSERT will fail. The first one works fine.

If the question had been about

2147483646

That would have been

1111111111111111111111111111110 in binary with a 0 in the least significant position (as all even number are) and while it would have...

I took a different look at it.

Assumed a 2147483647 in binary is

1111111111111111111111111111111

Then stuck it into a bit which is only 1 binary digit wide.

Figured the rest would flow over...

Always Learning (3/24/2011)

---

I have a stored procedure as such

DECLARE @Flagged bit

SELECT a.[ColumnA]

, a.[ColumnB]

FROM [dbo].[TableA] a

IF @Flagged = 0 THEN

LEFT OUTER JOIN [dbo].[FlaggedRecords] fr

ON uf.[UserID] =...

ashokdasari (3/28/2011)

---

I have a strange issue.

I have a procedure with two parameters. If I execute that procedure by giving some values to the parameters it took around 1 min.

But if...

Somewhere other than the log shipping you have a scheduled job...

djguana (3/24/2011)

---

I got the same issue.

I have setup a full backup (part of a maintenance plan) on a daily basis at midnight + running a transaction log shipping every 15...