Viewing 15 posts - 11,311 through 11,325 (of 19,560 total)
Daniel Bowlin (12/22/2010)
bcsims 90437 (12/21/2010)
Kit G (12/21/2010)
(in the wee hours of the morning)
Been about 460 years or so (round to an even 500 for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2010 at 8:31 am
How do I create an index - could you spoon feed me?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2010 at 8:31 am
456789psw (12/22/2010)
I was not able to find link as well..
I did not post the link directly to Michelle because there was material in the posts leading up to her post...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2010 at 8:29 am
sqlchanakya (12/21/2010)
Jason, am not really getting the link by Michelle Ufford.Could you please post the link related the topic.
I did not post the link directly to Michelle because there was...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2010 at 8:28 am
Rebuild your clustered index and retry the deletes.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 3:06 pm
Roger Sabin (12/21/2010)
Is this what you are looking for? If not, how do I get it?Index Name/avg_fragmentation_in_percent
IX_tblDocument_Box 18.7529747739172
IX_tblDocument_Category_Number 8.07453416149068
IX_tblDocument_Category_State 34.336917562724
IX_tblDocument_CreatedDate_DocumentID 26.4388489208633
IX_tblDocument_DocumentID 7.15277777777778
IX_tblDocument_DocumentName 41.025641025641
IX_tblDocument_PurgedDate 26.8115942028986
IX_tblDocument_RetainFlag 14.6437346437346
PK_tblDocument 60.941960038059
It looks like you have...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 2:20 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 1:44 pm
jcrawf02 (12/21/2010)
CirquedeSQLeil (12/21/2010)
jcrawf02 (12/21/2010)
New fun toy - Google NGrams Viewerlooking for info on which technology to study next? Find out what's trending:
also:
Fixed urls
Um, thanks, what the heck did you do...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 1:34 pm
How is the index fragmentation for that table?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 1:32 pm
--Does not work
delete tblDocument
from tblDocument as d
left outer join cdm_data as cdm
on cdm.ApplicationOrg = left(d.Number, 3)
and cdm.ApplicationType = substring(d.Number, 4, 3)
and cdm.ApplicationNumber = right(d.Number, 13)
where d.Category = 'APPLICATION'
and d.CreatedDate <...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 1:02 pm
I think seeing the code for both methods would be essential to answering this question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 12:34 pm
To make sure various combinations are replaced, I have used something like this:
REPLACE(REPLACE(REPLACE(REPLACE(dbo.yourcolumn, CHAR(13) + CHAR(10), ' ... '),
CHAR(10) + CHAR(13), ' ... '), CHAR(13), ' '), CHAR(10), '...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 12:21 pm
pkposani (12/21/2010)
SELECT SUM(DATALENGTH(colname)) As Bytes FROM db.table...will this work for ntext datatype?
What version of SQL Server are you running?
NText was Deprecated in SQL 2005
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 11:57 am
456789psw (12/21/2010)
I am not so sure there is something out there that will do exactly what you are looking for
If you read the link I provided and follow the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 10:42 am
jcrawf02 (12/21/2010)
New fun toy - Google NGrams Viewerlooking for info on which technology to study next? Find out what's trending:
also:
Fixed urls
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 21, 2010 at 10:20 am
Viewing 15 posts - 11,311 through 11,325 (of 19,560 total)