Viewing 15 posts - 1,801 through 1,815 (of 3,221 total)
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...
August 17, 2010 at 8:18 am
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...
August 17, 2010 at 6:39 am
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...
August 15, 2010 at 8:41 am
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....
August 14, 2010 at 1:32 pm
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...
August 13, 2010 at 11:04 am
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...
August 13, 2010 at 8:10 am
Boy oh boy did that make the old brain cells churn. Who would of thought this bit of ancient history would rise once again
August 12, 2010 at 9:01 pm
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...
August 11, 2010 at 11:28 am
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...
August 9, 2010 at 12:50 pm
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...
August 8, 2010 at 7:51 am
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...
August 7, 2010 at 7:33 am
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...
August 6, 2010 at 9:38 am
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...
August 3, 2010 at 9:50 am
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...
August 3, 2010 at 7:50 am
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
Paul Randal
http://www.sqlskills.com/BLOGS/PAUL/post/Script-open-transactions-with-text-and-plans.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
August 2, 2010 at 7:41 pm
Viewing 15 posts - 1,801 through 1,815 (of 3,221 total)