If you need any more proof that Paul is brilliant check out this answer on StackOverflow, http://stackoverflow.com/questions/5998217/why-does-the-execution-plan-include-a-user-defined-function-call-for-a-computed-c

Thanks to everyone who attended SQLRally. I had a great time at the event. It was great to meet all the threadizens that were there. Jim, Wayne,...

GSquared (5/9/2011)

---

I just registered for the PASS Rally in Orlando. Wasn't sure I'd be able to get the time/money for it, but it worked out. See you there...

Grant Fritchey (5/7/2011)

---

Steve Jones - SSC Editor (5/6/2011)

---

Interesting blog post from Roy. Anyone ever tried this?

http://www.sqlservercentral.com/blogs/dba_rumblings/archive/2011/05/06/why-you-should-ask-your-cto-to-attend-the-user-group-meetings.aspx

I used to go to a networking conference with my boss. A bit of a...

That means that they are all on mixed extents so you aren't like to get the fragmentation reduced because SQL Server isn't going to use uniform extents until the indexes...

Is your staging table flushed and reloaded every time with only changed and new rows?

Here's a very simple example.

CREATE PROCEDURE update_customername

(

@customer_id int,

@customer_name varchar(25)

)

AS

BEGIN

SET NOCOUNT ON;

UPDATE customers

SET customer_name = @customer_name

WHERE

customer_id = @customer_id

END

What do you want to do for midnight? Do you want a single 0 for the hour? If you want a 0 for midnight then this would work:

SELECT...

For small indexes you may not be able to remove fragmentation because they might be allocated on mixed extents. How many pages in each of the indexes that are...

You can also use the UPDATE function in the trigger. Just be aware that if you include the column in an update statement this function will consider that column...

I don't think that there is an automated refresh of cached EF objects. EF is running client side and knows when an object has been changed by the application,...

There are a couple of things that might help:

1. You are using functions on columns in the where clause which means they are not SARGable so you are getting...

I'd load all the data into staging tables and then do a an outer join to load new rows.

SELECT DISTINCT

A.firstname,

A.middlename

FROM

...

Craig Farrell (5/5/2011)

---

I agree they're worthy, but they need to fit into my schedule, not me into theirs, right, wrong, or indifferent. I know others have different...

[Jim].[dba].[Murphy] (5/4/2011)

---

I registered for your class some time ago. Hopefully, there will be room and I'll make it...