Viewing 15 posts - 301 through 315 (of 859 total)
rhythmk (7/10/2012)
capn.hector (7/10/2012)
jasona.work (7/10/2012)
SQLRNNR (7/10/2012)
Cliff Jones (7/10/2012)
crookj (7/10/2012)
Daniel Bowlin (7/10/2012)
rhythmk (7/9/2012)
Possinator (7/9/2012)
SQLRNNR (7/9/2012)
Cliff Jones (7/9/2012)
Ray K (7/9/2012)
Revenant (7/9/2012)
rhythmk (7/9/2012)
Brandie Tarvin (7/9/2012)
Daniel Bowlin (7/9/2012)
HeatwaveHeatstroke
Engine
Piston
V6
V8
HEMI
Barracuda
Fearsome
Foursome
Quartette
Beatles!
Monkees
wiener mobile
Hot Dog
Microwave
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]
July 11, 2012 at 6:09 am
jasona.work (7/10/2012)
SQLRNNR (7/10/2012)
Cliff Jones (7/10/2012)
crookj (7/10/2012)
Daniel Bowlin (7/10/2012)
rhythmk (7/9/2012)
Possinator (7/9/2012)
SQLRNNR (7/9/2012)
Cliff Jones (7/9/2012)
Ray K (7/9/2012)
Revenant (7/9/2012)
rhythmk (7/9/2012)
Brandie Tarvin (7/9/2012)
Daniel Bowlin (7/9/2012)
HeatwaveHeatstroke
Engine
Piston
V6
V8
HEMI
Barracuda
Fearsome
Foursome
Quartette
Beatles!
Monkees
wiener mobile
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]
July 10, 2012 at 6:10 pm
eh.shams (7/10/2012)
SET NOCOUNT ON;
Declare @90000119 varchar(8),@ali varchar(50)
Declare @cslPricingFactorRef varchar(3),@Avamel varchar(50)
SET @90000119 = 0;@ali=0
Declare spid_List2 Cursor FORWARD_ONLY...
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]
July 10, 2012 at 7:30 am
Taking a wild *** guess here and wondering if its because when using the synonym the query optimizer does not see the index on the view?? not sure why...
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]
July 3, 2012 at 1:54 pm
on some of our ETL loads we have a staging database with an initial table. we then run data validation and insert into a second staging table then insert...
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]
July 3, 2012 at 1:29 pm
it depends. way to vague to really answer. can you post a more detailed explanation and some DDL, Sample data, and expected results?
See the first link in my...
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]
July 3, 2012 at 1:22 pm
what is the exact error you are getting. if you were getting no errors with the code you posted the changes to the code should not have caused any...
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]
July 3, 2012 at 1:05 pm
Munabhai (7/2/2012)
I have employee table which is in sybase, which looks like
EmployeeIDEmpName Salary State
1 ...
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]
July 2, 2012 at 1:51 pm
Bill Talada (7/2/2012)
I don't remember you posting code for your 8k splitter. We all knew there was a general splitter function being used. It doesn't matter...
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]
July 2, 2012 at 10:20 am
eagb (6/28/2012)
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]
June 28, 2012 at 5:05 pm
StephenNL (6/28/2012)
Yes, I have attached the db on a non productive server in Hyper V (of course).
The result was a language-collation error when attempting to add users (schemes).
So, instead,...
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]
June 28, 2012 at 5:00 pm
is this line in the trigger?? from your post i think so:
SELECT @ID=ID FROM deleted
if so the trigger looks to only be able to handle one row being deleted...
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]
June 28, 2012 at 4:17 pm
have you tried restoring a backup taken from the 2k server on the 2008 server?? i believe that should work provided you set the compatibility level correctly on 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]
June 28, 2012 at 2:11 pm
i dont think you need your function. i think you just need the create proceture like follows:
CREATE PROCEDURE MyProceture
@StartDate DATE,
@EndDate DATE
AS
SELECT ProducttId,
...
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]
June 28, 2012 at 2:06 pm
from your excel i can recomend you get rid of the line_on_charge table and have a composite key of charge_guid (although i may look at going to an int or...
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]
June 28, 2012 at 10:58 am
Viewing 15 posts - 301 through 315 (of 859 total)