Viewing 15 posts - 1,066 through 1,080 (of 3,221 total)
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...
August 1, 2011 at 9:30 pm
Dhruvesh Shah (8/1/2011)
August 1, 2011 at 6:34 am
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...
July 31, 2011 at 3:46 pm
Try this site:
http://sqlserversamples.codeplex.com/#e2e
Provides a great deal of sample code for what I think you might be looking for.
July 31, 2011 at 9:30 am
ronmoses
Have you reported this anomaly to Microsoft Connect?
July 31, 2011 at 9:02 am
Even stranger, used NVARCHAR(max) and the behavior is completely different.
July 31, 2011 at 6:46 am
Whopeee first one to select the correct answer. (not a guess).
July 30, 2011 at 9:16 pm
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 =...
July 30, 2011 at 8:37 am
What makes an index tick and why do they make your queries faster.
Is a title that would attract myself, as far as the I6 reference, would skip over the thought...
July 29, 2011 at 11:13 am
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...
July 29, 2011 at 11:05 am
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...
July 29, 2011 at 8:39 am
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...
July 28, 2011 at 2:17 pm
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...
July 28, 2011 at 7:17 am
Steve is this what you are thinking of? (From Paul Randal's blog)
July 27, 2011 at 8:26 am
Viewing 15 posts - 1,066 through 1,080 (of 3,221 total)