I'm...

if it works quickly for a while, and then becomes slow, it sounds like out of date statistics might be the first thing to look at.

stale statistics can easily slow...

I've got teh same answer ad Ed Wagner does, i just processed your post through a macro so i had some consumable data.

if you want solid help like that int...

procs and views referencing your tables are only part of the puzzle;

applications can have dependencies on those tables, and applications can reference tables that are never used.

there's a handy chartabout...

info-531323 (12/26/2013)

---

In a stored procedure I dynamically create a temp table by selecting the name of Applications from a regular table. Then I add a date column and add the...

INSERT INTO NewTable(name,mobile)

SELECT name,mobile from a UNION ALL

SELECT name,mobile from b UNION ALL

SELECT name,mobile from c UNION ALL

SELECT name,mobile from d

here's the data you posted, but cleaned up and in a ready to use format:

the column names in your query did not match the data, and there was no easy...

MohamedDBA (12/25/2013)

---

But the compatibility level of the database is - SQL Server 2008 (100) , and this database was created on SQL Server 2008 before I attach It to SQL...

the more updated views under the sys schema, instead of the old dbo.sys* views are recommended instead.

the view below has both a create_date and modify_date that can help in your...

does joining the table against it self help you visualize the issue?

this lets us see how some of the items are related to each other:

--join the table against itself looking...

you have to update statistics on all tables with full scan after a version upgrade, or restore of a database from a lower version to a higher;

the statistics are treated...

whoops after reading your post AFTER i posted, i see you really want to chop up the string based on a fixed length(ie 4 chars)

well, i know an example of...

check out this thread that has both a scalar and an inline table value function that resolves the same issue: splitting a string on a delimiter into new columns:

http://www.sqlservercentral.com/Forums/Topic1524275-3077-1.aspx#bm1524325

i thinka decent rule of thumb for most SQL installations reserving 1/8th of the memory for the OSand apps, and 7/8ths for SQL server, plus or minus any special needs;...

you want to take advantage of the OUTPUT clause, which gives you access to the INSERTED and DELETED triggers that are normally seen inside a trigger;

here's an example, where i...