Viewing 15 posts - 49,786 through 49,800 (of 59,078 total)
Jeff W...
SELECT * works perfect on these type of "pass through" or "surrogate views". You can go through the process of naming all the columns if you want, but...
June 22, 2008 at 1:58 pm
Bilal (6/22/2008)
I expect about 1000 rows to return , and their is one type of index defined which is traffic1each table have millions of records
any thing else ?
Yes...
June 22, 2008 at 9:32 am
Ummm... you guys are getting awfully serious about this... you do realize that the article was written and first posted about 3 years ago, huh? 😉
June 22, 2008 at 8:59 am
Ok... thanks...
Does BitBucket's code do it for you or do you still need help with something?
June 22, 2008 at 8:56 am
Even though I don't like cursors and I don't use them, that would be the first thing to change... I'd have them stop deprecating stuff that works. That's part...
June 22, 2008 at 8:54 am
JRJ (6/22/2008)
That's possible. How can I change a views definition in a proc? Also I am deeling with duplicate indexes, is that ok?thanks
A view's definition can easily be changed using...
June 22, 2008 at 8:48 am
No, NO, NO!!! Never ever store formatted data! You will pay dearly for doing so someday in the future. This type of (leading zero) formatting should really...
June 21, 2008 at 9:08 pm
giontech (6/21/2008)
I need help in how to get data from a table with a daterange from sunday to saturday of the last week.
What I'm looking for is to be able...
June 21, 2008 at 8:47 pm
Mani Singh (6/21/2008)
you can use this and manipulate this query to code as needed..DECLARE @GENRANDOM nvarchar(9)
SET @GENRANDOM =LEFT(SUBSTRING (RTRIM(RAND()) + SUBSTRING(RTRIM(RAND()),3,11), 3,11),9)
--SELECT SUBSTRING(@GENRANDOM ,3,1)
SELECT @GENRANDOM as 'RANDOM_NUMBER'
Yep... you could do...
June 21, 2008 at 8:05 pm
Here's one way to do it in 2005... The neat thing is it doesn't use any RBAR or a sequence table. You could use UPDATE and OUTPUT to return...
June 21, 2008 at 8:00 pm
ola_blixten (6/17/2008)
My case:
I want to generate 5 digit random numbers which should start with:
00001
00002
00003.....
and 2 digit for week so from 1-52
and 1 digit for year, from 0-9
And everyting should be...
June 21, 2008 at 7:05 pm
Rebuilding the indexes after that might help... 🙂
June 21, 2008 at 6:44 pm
During the repopulation of TableB in DTS, your users will wait.
Why does this have to be DTS? Why can't it be DTS executing a proc?
June 21, 2008 at 4:13 pm
If temp table contains ALL the final information that original table will have once you do all the inserts and updates to it, why not just "swap" tables?
June 21, 2008 at 4:07 pm
Ugh... thousands of growths probably also mean thousands of fragments for the database and thousands of fragments for the underlying file. For the same reason that people use defrag...
June 21, 2008 at 3:29 pm
Viewing 15 posts - 49,786 through 49,800 (of 59,078 total)