Viewing 15 posts - 346 through 360 (of 859 total)
ColdCoffee (5/7/2012)
MERGE
+1 with Merge you only have to run 1 query instead of 2 (one for insert one for update)
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]
May 7, 2012 at 3:43 pm
Grant Fritchey (5/7/2012)
Unless we're talking about some type of actual error, no, there's nothing to see for a query that behaved, but didn't do what you wanted.
what i expected to...
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]
May 7, 2012 at 1:05 pm
Lowell (5/7/2012)
1. zero rows got deleted, but you expected it to delete something,
2. or do you...
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]
May 7, 2012 at 9:33 am
ChrisM@Work (5/4/2012)
capn.hector (5/3/2012)
crookj (5/3/2012)
capn.hector (5/3/2012)
Ray K (5/3/2012)
ChrisM@Work (5/3/2012)
bopeavy (5/3/2012)
Ray K
EL Jerry (5/2/2012)
--------------------------------------------------------------------------------
bopeavy (5/2/2012)
--------------------------------------------------------------------------------
hypothesis
Hypothermia
hypochondriac
hypothalamus
Beta thalassemia
Beta release
windows vista
Windows ME :crazy:
Mighty Excrement
Coproheavy
T-Rex
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]
May 4, 2012 at 1:09 pm
its not 100 percent but when an index is rebuilt the statistics get updated. you can use the following to kinda see when the last time it was rebuilt....
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]
May 4, 2012 at 12:29 pm
your right those dont really look like bad fragmentation numbers. im at the end of my knowledge here. with the incorrect data getting in have you tried rebuilding...
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]
May 4, 2012 at 10:54 am
what does the string look like? are there nice delimiters or is it a fixed width set up?
with delimiters have a look at Jeff Moden's DelimitedSplit8K[/url]. if its...
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]
May 4, 2012 at 9:23 am
Coming from BOL:
When a unique clustered index is created on a view, the result set is stored in the database just like a table with a clustered index is stored.
then...
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]
May 4, 2012 at 9:06 am
From my limited testing you can use the following code:
SET CURSOR_CLOSE_ON_COMMIT OFF
DECLARE @ID INT
DECLARE test CURSOR FOR
SELECT productID FROM product ORDER BY productID
OPEN test
FETCH NEXT FROM test INTO @ID
WHILE @@FETCH_STATUS...
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]
May 4, 2012 at 8:37 am
bostonjoey (5/4/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]
May 4, 2012 at 8:26 am
Eugene Elutin (5/4/2012)
Jeff Moden (5/3/2012)
michael vessey (5/2/2012)
does the following count as a loop?INSERT INTO dbo.yourTable default values
go 100
??:-P??
BWAAAA-HAAAA!!!!! Ask that question on the receiving end of an interview and...
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]
May 4, 2012 at 8:07 am
i was attacking it the same way lynn was and my code is very similar. i may suggest making idLigne an INT instead of a VARCHAR as that would...
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]
May 4, 2012 at 8:02 am
im having a little dificulty understanding your requirements. do you have multiple entries for a location and product id that you need to sum the cases for??
Can you post...
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]
May 4, 2012 at 7:56 am
slunt01 (5/3/2012)
ok what is a bulk insert?See i told you i was new.
It seems like there is a million ways to do one thing.
Here is the MSDN article on it...
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]
May 3, 2012 at 4:38 pm
Evil Kraig F (5/3/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]
May 3, 2012 at 4:33 pm
Viewing 15 posts - 346 through 360 (of 859 total)