Viewing 15 posts - 16 through 30 (of 71 total)
Oh sorry. My SQL as following,
select distinct nme from myTbl1 where addr1 like '%a%'
Correction,
My execution plan have
1. Hash Match
2. Clustered Index Scan (Clustured)
My question is 'How to replace this Index...
January 18, 2012 at 6:04 am
ok Mam.
I'll fix the
1. Query
2. Put an appropriate index
January 15, 2012 at 8:04 am
If 1 table contains 70 million rows, what should I do? As a result, I can query very fast
January 15, 2012 at 7:22 am
GilaMonster (1/15/2012)
Before you spend lots of time doing this... What is the goal for partitioning? What is it you're trying to achieve? What problem are you trying to alleviate?
1. What...
January 15, 2012 at 4:00 am
RESOURCE_SEMAPHORE_QUERY_COMPILE waits is high. My understanding, this nothing to do with my ASP.NET code technique
Let's, my same Stored Procedure is execute 500 a day. Did we have special technique to...
January 11, 2012 at 9:38 am
yes sir. it's composite primary key
I'll do it
December 29, 2011 at 6:23 pm
I like this one, 'If in doubt - add a second column to the PK, a column that would ensure uniqueness'
But I dont understand how to add a second column
December 29, 2011 at 7:20 am
It's possible to make crtdte as primary key?
http://weblogs.asp.net/bkcarroll/archive/2004/05/13/131329.aspx
December 29, 2011 at 7:06 am
tq sir
November 15, 2011 at 1:27 am
My requirement is
1. Monitor server health
2. Alerts
3. Performance troubleshoot
At this level, may be I need
1. SQL Monitor
2. SQL Sentry's Performance Advisor
3. Confio's Ignite
Tq for the info. Really appreciate
November 10, 2011 at 9:27 pm
Looks good. Let me try on Intel Itanium Machine first
November 10, 2011 at 8:18 am
Marco Terzolo (1/31/2011)
DECLARE @strsql NVARCHAR(255)set @strsql='namefile.xls'
EXEC sp_makewebtask
@outputfile =@strsql,
@query = 'Select * from View1',
@colheaders =1,
@FixedFont=0,@lastupdated=0,@resultstitle='objecttitle:'
I hope you can explain line by line. I'm too junior about this...
January 31, 2011 at 7:45 am
Viewing 15 posts - 16 through 30 (of 71 total)