Hugo Kornelis

Copied and tested your code and got your answers. Unfortunately I did not save my test code and now can not duplicate my results, and I tested that...

For a completly different answer - execute the code with the setting for

ARITHABORT ON and note the difference. An important fact to be aware of.

Added after reading Hugo Kornelis...

Is this what you require?

CREATE TABLE #T(C1 INT, C2 INT, C3 INT, C4 INT, C5 INT)

INSERT INTO #T

SELECT 1,1,1,1,0 UNION ALL

SELECT 1,1,1,0,1 UNION ALL

SELECT 1,1,0,1,1 UNION ALL

SELECT 1,0,1,1,1 UNION ALL

SELECT...

Rajiv Kumar

You are much more likely to receive a tested response if you would post the table definition, some sample data as per the first link in my signature block....

Have you quired sys.dm_db_index_physical_stats ?

For example (Reorts on all DBs:

select * from sys.dm_db_index_physical_stats(0,0,-1,0,null)

For a specific database:

select Object_name(object_id)AS 'Table',index_id,ROUND(avg_fragmentation_in_percent,2) AS

'Percent Fragmentation'

from sys.dm_db_index_physical_stats(0,0,-1,0,'DETAILED')

WHERE database_id = db_id('your db name')

Further refinement for...

Don't think I have seen this in the Thread, but today is Friday the 13 and we all know what that means.

If memory serves me correctly it is the only...

Boy oh boy did that make the old brain cells churn. Who would of thought this bit of ancient history would rise once again

This would be one method to eliminate from the count those drivers who had INTERSTATE and INTRASTATE routes

CREATE TABLE #T(Did CHAR(1),T VARCHAR(10))

INSERT INTO #T

SELECT '7','INTRASTATE' UNION ALL

SELECT '7','INTERSTATE' UNION ALL

SELECT...

Celko is at it again

http://www.sqlservercentral.com/Forums/Topic965546-1292-1.aspx#bm966047

For a community which attempts to help, even the most inept, and helps so many this guy Celko is a real detriment ....

Is there any...

sergio.huertac

To repeat what I and WayneS requested. This is an example of the Create Table and sample data as it should be posted to a forum.

CREATE TABLE #StatusFilter(

StatusID...

sergio.huertac

You are more likely to receive a tested answer if you include in your posting the Table definition(s), sample data and required results as described in the article whose link...

I am having difficulty understanding your question. But if you desire to know if a database is being backed up (not how it was performed) try the following code.

SELECT...

Lines can be comented by using -- (for a single line of text) or /* */

The @Script holds the text you retrieved from the syscomments entry and is used...

rohit.kumar.barik

May I suggest that you read this article, which contains a wealth of sample code ... It has code to name Excel spread sheets, add work sheets, write to a...

May I suggest you read the following articles, which might assist you.

gail Shaws article:

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/65877/

Jason Brimhall,

http://www.sqlservercentral.com/articles/Log+growth/69476/

Hugo Shebbeare in

http://www.sqlservercentral.com/blogs/hugo/archive/2009/1/17/it-s-minus-twenty-five-outside-and-i-m-writing-about-transaction-log-files.aspx

http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/3/10/how-to-schedule-perfmon-log-for-to-analyze-sql-counter.aspx

Paul Randal

http://www.sqlskills.com/BLOGS/PAUL/post/Script-open-transactions-with-text-and-plans.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-More-on-the-circular-nature-of-the-log.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx