Viewing 15 posts - 811 through 825 (of 859 total)
you can most likely use the coalesce function. For a more detailed and tested solution please see the link in my signature on the most helpful way to ask...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 19, 2012 at 1:23 pm
shanish (3/19/2012)
declare @minmarks intselect @minmarks=minmarks from table2
select (case when sum(convert(int,marks)) >= @minmarks then 'Pass' else 'Fail' end) as Result
from table1
GROUP BY StudentId,SubjectId,ComponentId
am getting the result, thanks
does the minimum for pass/fail...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 19, 2012 at 1:11 pm
when you say its intermittent, is that from the same machine to the same server sometimes it will connect sometimes it wont and nothing changes in the server or app...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 19, 2012 at 12:55 pm
CELKO (3/17/2012)
First you need to read a book on basic data modeling;"name" is an attribute property, which means your column should have been "vendor_name" instead.
it really sounds like the...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 17, 2012 at 12:13 pm
pallavi.unde (3/17/2012)
Currently i am using express editionbut if i want to switch it then will express edition backup get restore in enterprises edition?
best analogy of enterprise and express would be...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 17, 2012 at 8:48 am
you did not pass the parameters to the stored procedure. see my above post on how to execute the master SP.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 6:24 pm
sbaker-757360 (3/16/2012)
http://msdn.microsoft.com/en-us/library/ms189493.aspx
Shrinking below initial size will only work if the database file is empty.
My guess is that as soon as you add data (before shrink), you will be...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 12:05 pm
on multi core machines each core reports their usage time. so 3 cores at 28 seconds is roughly 90 seconds. add a couple of other cores doing a...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 11:15 am
sbaker-757360 (3/16/2012)
I copied a 300GB table out to a new filegroup (because to was too large to shrink after mass deletes)
It ended up...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 9:03 am
ok so you only want to pass the file name and have the folder path static? As i wrote it you pass the entire file path to the stored...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 8:08 am
Jeff,
Depending on the application would using the created on date for the first modified date be better than some future date?
so in the above query it would be rewritten
select *...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 8:00 am
this is starting to sound like homework to me. Any one else?
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 7:54 am
Koen Verbeeck (3/16/2012)
Gianluca Sartori (3/16/2012)
Oracle offers Standard/Enterprise editions and maintains additional...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 7:37 am
you say you have 4 production servers on 2000. does this mean you have other servers on SQL 05 or later? The next question is how much will...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 12:18 am
for ssd's the trim function clears the NAND cells of old data speeding up the read write process by not having "dirty" NAND memory. Windows 7 from what i...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 16, 2012 at 12:02 am
Viewing 15 posts - 811 through 825 (of 859 total)