Speaking of the individual, he...

sing4you (3/18/2010)

---

Don't send it my way. I'm happy to live in Texas where it is now 50 but is supposed to get up to low 70s (but I don't...

Would prefer that the weather people be wrong. Really don't want to officiate soccer in the snow. Just...

Thinking about this a bit.

Snapshot at 5:00 PM.

Developer fat fingers code dropping a table at 5:05 PM.

No restore, but recreate the table in original database using the data in the...

It would look something like this:

CREATE FUNCTION [dbo].[fnConvertIP] (

@ISALogIPAddress bigint

)

RETURNS table AS

RETURN (

select CAST(@ISALogIPAddress / 256 / 256 / 256 % 256...

Not sure. One thing I'd do is rewrite the function as an in-line TVF and use it in a CROSS APPLY in the FROM clause. Before doing that,...

First, it would help to see the code for the scalar function. Second, it may be worthwhile to seeif the scalar function can be converted to an inline TVF...

john.arnott (3/17/2010)

---

gamcall (3/17/2010)

---

"So if the insert transaction completes after the full backup is complete, how many rows where inserted till the backup gets completed will be included in the backup."

Shocking...

Like clustered indexes are better than nonclustered indexes?

Agreed. Nice now, supposed to snow Friday.

Vega$, iirc.

Read the last article I have referenced below in my signature block.

You really need to schedule periodic transaction log backups through out the day. This will help you control the...

Not sure why you want to modify the behaviour of a system stored proc, but looking at it, this code snippet seems to indicate if there are no wild cards...

[font="Comic Sans MS"]Looks like the TitD (Tent in the Desert) will be hosting another party fairly soon!![/font]

Jeff only needs 83 more posts to break the 20,000 posts mark!

Well, like I said earlier, facing a 11 - 16 Million dollar cut in our budget for next fiscal year, and the follwoing year we may see more cuts. ...