Almost missed the fact that firstname wasn't part of the view. It's a good thing I double checked.

sqlenthu 89358 (8/4/2016)

---

Mainly I see the substring condition in the where clause and the aggregate function in select condition using case statement. The query takes little more time than what...

For accurate replies, post DDL and sample data. For performance problems, follow this article to know what we need: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

This has small changes that might not be relevant, but I...

Do you understand how it works? The article should explain it clearly, but you can post any questions after reading it.

robert.sterbal 56890 (8/4/2016)

---

yes. Their commitment and direction is contrary to an open source product. Some of the people coming to the forums of the most value will eventually leave when...

This should be handled in the front end, the query should only return the values aggregated in the smallest unit fo measure (hours in this case, apparently).

Is that a problem? The site I posted seems to to be active.

If the database is not going to grow back, you could certainly shrink it. Remember to leave enough space for future growth.

The backups don't include free space, so you shouldn't...

You could do it with the following method: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

DECLARE @sql NVARCHAR(MAX);

SELECT @sql = ( Select 'ALTER TABLE ' + TABLE_SCHEMA + '.' + table_name

...

One last thing. Try to stay away from scalar functions, they'll only slow you down. I'm not talking about coding time, but real processing time once the system is live.

skippyV (8/4/2016)

---

Luis Cazares (8/4/2016)

---

With 1.2 and 427 million rows, you really should add an index to those tables. You should start by defining the clustered index and add non-clustered indexes...

Assign it to a variable and then use sp_executesql

Here's another link: https://technet.microsoft.com/en-us/library/ms175170(v=sql.105).aspx

I've never needed them, but you could always go to http://forums.mysql.com/ or http://stackoverflow.com/

Here's an example:

CREATE TABLE CheckTest(

CharDate varchar(25)

)

GO

ALTER TABLE CheckTest ADD CONSTRAINT CK_CharDate CHECK( CharDate = CONVERT( varchar(10), CONVERT( datetime, CharDate, 101), 101));

GO ...

skippyV (8/4/2016)

---

I can't post the actual code. But I can describe the tables.

There are no indexes and no primary or foreign keys.

...

Size wise:

tbA has 1.2 million records

...