>> Buffer Cache page life expectancy is 66 seconds

That is very low and there can be multiple reasons for this.

1) Low memory available on the server.

2) Queries returning large sets...

Gaby,

>>(we're talking 10 minutes plus, last time I ran it it was heading to 15).

sys.dm_db_index_physical_stats will tell you the fragmentation of the tables. And in limited mode also, it will...

WayneS (2/27/2009)

---

Interesting.

I modified the supplied code to get the # of tempdb objects, and all tempdb table names:

use AdventureWorks

go

select count(*) from tempdb.sys.objects

select name from tempdb.sys.tables --where name like '%tableA%'

declare @tableA...

This is written as a trivia question and to raise awareness that certain questionable features will not be supported in future versions of SQL Server. Follow the link to learn...

Jeff, Thanks for your timely good spanking for using the TVF. I wouldn't use/propose this next time and you will see me use the numbers table here next time.

Just to complement what was already said, you should read the below articles to understand why its happenning and how can you avoid this.

http://support.microsoft.com/kb/317375

http://msdn.microsoft.com/en-us/library/ms345382.aspx

>>how to create secondary data files in sql server 2005?

-- Create a new file group

ALTER DATABASE test_filegroup

ADD FILEGROUP NonClustIndexes

go

-- Add a file to the file group,...

>>I want to populate a column that have the values null of an table that contains data with data from one column to another table. who I do this? with...

Plz take a look at PIVOT in BOL.

CREATE TABLE #Test

(Id_solution INT, Parameter_nm VARCHAR(100), Parameter_value VARCHAR(50))

INSERT INTO #Test

...

Andy is right that you can't create view on the snapshot db unless the views are created in the source database.

Where are these views located? Can you share more details...

>>My system always using High RAM 25 GB out of 32 GB

As explained earlier, this is normal behavior for SQL Server. SQL grabs as much memory as needed and will...

DTA is very good tool but you have to present substantial query load (representative of complete load) for it to give a good set of options. I wouldn't simply create...

Do you need to account for data integrity also if any of the SP's fail? Then look at SET XACT_ABORT (Transact-SQL) This will ensure that if any SP fails...

Dynamic sql is the only way, although you don't necessarily use cursors.

CREATE TABLE #Test

(OrderNo INT, SeqNo INT, Type CHAR(2))

INSERT INTO #Test

...

When using bcp, you have to specify the data types in some format. For faster responses, try -n.

-n: Native

-c: character

-N: native (database) data types of the data for noncharacter data,...