Viewing 15 posts - 10,771 through 10,785 (of 15,381 total)
bslchennai (9/11/2012)
I am facing one problem with re-index, while doing the re-index on 40gb database one table is taking 40mins, but thing is every day the same table is not...
September 11, 2012 at 8:49 am
snadsul (9/11/2012)
i wan to fetch newly added record in table .how to write query for that .
This is entirely too vague to provide an answer. There are a number of...
September 11, 2012 at 8:39 am
Artoo22 (9/11/2012)
0: The FETCH statement was successful.
-1: The FETCH statement failed or the row was beyond the result set.
-2: The row fetched...
September 11, 2012 at 8:27 am
I would start by looking closely at your split function. I am going to take a guess that is either a loop or xml based. Take a look at the...
September 11, 2012 at 8:17 am
CELKO (9/11/2012)
I have a two articles on this topic at Simple Talk. There is no need to throw away performance, maintainabilty and portability to do this.http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists/
http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists---part-ii/
If portability to another...
September 11, 2012 at 8:08 am
christina.honnert (9/11/2012)
September 11, 2012 at 7:52 am
raghuldrag (9/11/2012)
hey friendi am executing dis qury on sql server 2000 only...its not server 2008
But we still don't know what the question is. It has...
September 11, 2012 at 7:21 am
Luis Cazares (9/10/2012)
Maybe this modification to Sean's code will work better:
select *,
LEFT(full_name, charindex('_', full_name)) + RIGHT(full_name, charindex('_', reverse(full_name),2) - 1)
from test_name
Thanks Luis. I was a brain meltdown for some...
September 10, 2012 at 2:01 pm
weston_086 (9/10/2012)
September 10, 2012 at 1:46 pm
Nice job posting ddl and sample data. Unfortunately it is totally unclear what you are trying to do. Can you provide a clear explanation of your requirements. Additionally if you...
September 10, 2012 at 1:16 pm
A third option which you did not mention is to use FILESTREAM. http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx
This is a valid option in many situations.
With either of the previous methods there are some pitfalls....
September 10, 2012 at 8:56 am
raghuldrag (9/10/2012)
(
@stuid nvarchar(22),
@startyear nvarchar(22),
@endyear nvarchar(22),
)
as
begin
select name,class,noofsubject,rank,test from @tab1
union
select name,class,subject,rank,test from @tab2
where rank is not null
and studentname=@stuid...
September 10, 2012 at 8:50 am
gpm.alwyn (9/10/2012)
September 10, 2012 at 8:38 am
As Lynn said we need more details to answer your specific issue. I do see some serious performance issues with your query. You have a lot of conditions that cause...
September 10, 2012 at 8:34 am
hehe I hadn't looked at today's question of the day. Seems to be in conjunction with this post. Same issue exactly. We should all three get this one correct with...
September 10, 2012 at 8:08 am
Viewing 15 posts - 10,771 through 10,785 (of 15,381 total)