IGNORE THIS ENTRY SEE CORRECTION BY SQLkiwi Posted Today @ 4:23 AM

Here we go again

Try it as:

DBCC INDEXDEFRAG (Master,"dbo.spt_values",ix2_spt_values_nu_nc)

DBCC INDEXDEFRAG (AdventureWorks_regular,"cdc.ddl_history",ddl_history_clustered_idx)-- a system table in the AdventureWorks_regular DB

Your reference...

Dhruvesh Shah (8/1/2011)

---

My server got hang. but from memory i have setup my instance as US. Can some one pls advise how can i find out what's my default country...

You may want to read these blog posts by Jason Strate (A great deal of T-SQL is included to assist you).

[http://www.sqlservercentral.com/blogs/stratesql/archive/2010/10/13/return-of-index-analysis-part-3.aspx/url]

Then select the most used indexes, and from those the...

Try this site:

http://sqlserversamples.codeplex.com/#e2e

Provides a great deal of sample code for what I think you might be looking for.

ronmoses

Have you reported this anomaly to Microsoft Connect?

http://connect.microsoft.com/

Even stranger, used NVARCHAR(max) and the behavior is completely different.

Whopeee first one to select the correct answer. (not a guess).

If you need to know which characters have been found / or if found removed from the input string try this:

DECLARE @Temp VARCHAR(30)

DECLARE @Found VARCHAR(30)

SET @Found =''

SET @Temp =...

Is a title that would attract myself, as far as the I6 reference, would skip over the thought...

Is this what you desire to do?

CREATE TABLE #T(Id INT,SomeText VARCHAR(300))

INSERT INTO #T

SELECT 9,'This is 1Tab' UNION ALL

SELECT 13, 'This is a

line feed' UNION ALL

SELECT 1000,'This has a taband a...

pharmboy4u

Have I mentioned I'm not a DBA or even in IS/IT but just a humble little pharmacist? I just try to do this stuff for my hospital to help the...

To help those who want to help you, please post table definition, sample data and any T-SQL that you have tried to use. For instructions on how to provide...

Now this is not the complete answer, but a bit of T-SQL to illustrate how to "extract" the minutes component from a DATETIME value.

declare @start as datetime declare @end as...

Good Question - seems my memory did not fail me.

Steve is this what you are thinking of? (From Paul Randal's blog)

http://www.sqlskills.com/blogs/paul/post/SQL-Server-2008-New-(undocumented)-physical-row-locator-function.aspx