Viewing 15 posts - 48,226 through 48,240 (of 59,064 total)
Yeaup... still RBAR... but the Tally table get's cached... While loop doesn't. 'Course, you knew that.
If you don't like the Thorn character (used it mostly for visual), Tab character...
September 17, 2008 at 9:45 pm
The problem is the Cross-Apply's... they resolve to a single row in the execution plan. Query may run ok when running from QA because of cache and stats... likely...
September 17, 2008 at 9:07 pm
karthikeyan (9/17/2008)
I hope i have explained enough. Inputs are welcome !
Also i wanted to know whether the way which i...
September 17, 2008 at 8:58 pm
A bit more info is required... please see the link in my signature for faster, better, tested answers....
September 17, 2008 at 8:52 pm
Dunnor if it works in Integration Services, but I Use STUFF to quickly add a couple of dashes.
--===== Setup a simple test.
-- This is NOT...
September 17, 2008 at 8:49 pm
When "rebuilding" and index, the index is NOT available for use. That is also true when using DBCC DBReIndex. They are, however, available if you use DBCC IndexDefrag.
September 17, 2008 at 8:43 pm
Ummm... what are you calling "high consumption"? How big is the MDF and the LDF file for TempDB right now?
September 17, 2008 at 8:18 pm
See the following... it's a long article, but it's worth it.
Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays
September 17, 2008 at 8:16 pm
Mark (9/17/2008)
DECLARE @S VARCHAR(30)SET @S='99202 10060 99000 A6402'
SELECT LEN(@S)-LEN(REPLACE(@S,' ','')) AS NumberOfSpaces
THAT's the way to do it... no RBAR, no join! 🙂
September 17, 2008 at 8:07 pm
ishmael (9/17/2008)
September 17, 2008 at 8:04 pm
You might want to consider using 4 digit years and, possibly, a date format where the month and day cannot be confused... for example, is 06/07/2008 June 7th or July...
September 17, 2008 at 8:01 pm
Google search turned up about a million hits on this error. Here's the KB article from Microsoft that turned up...
September 17, 2008 at 7:53 pm
You're welcome. How did you find the bad data?
September 17, 2008 at 7:48 pm
Thanks, Lynn.
Scott, the article is long because it explains the wrong way to do things as well as the right way. The concept is wicked simple and creating running...
September 17, 2008 at 7:38 pm
Viewing 15 posts - 48,226 through 48,240 (of 59,064 total)