Viewing 8 posts - 451 through 459 (of 459 total)
Jeff Moden (9/5/2008)
You still haven't answered the question though... why would anyone create such a table of 1 gig of almost nothing but NEWID()'s?
I guess it was to generate a...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 8, 2008 at 6:39 am
Hmmm...true. 🙂 Ran it very quickly on my box as well.
I discovered one more way to create a big table a day or so after submitting my script. Create...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
September 5, 2008 at 7:14 am
For all DBA's here who have the ears of any influential people at Microsoft, for the sake of all that is good and pure in this world, have them deprecate...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
August 12, 2008 at 8:18 am
Try this, it's something I wrote to automate a program that could be optimized on number of processors used:
create procedure num_processors
as
set nocount on
declare @numprocs int
create table #numprocs
(
id int,
colname varchar(128),
IV int,
CV...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 28, 2008 at 8:50 am
Hmmm...thanks. I guess that would be the best way in general. While security can sometimes be complicated, don't make it more complicated than it has to. So...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 24, 2008 at 9:10 am
Thanks very much, that helped quite a bit.
Gaby
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 3, 2008 at 6:48 am
Gail, here's the original code. It's totally different from the first example I gave except the sp_executesql part.
set @ctr = 1
while @ctr <= @numdb
begin
select @dbname = dbname from @names...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 3, 2008 at 6:20 am
Hmmm...that gave me an error, the reason being that @db only exists in the context of @sqlstring so when I build it outside, I get those errors.
On another note, here's...
Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein
July 2, 2008 at 8:13 am
Viewing 8 posts - 451 through 459 (of 459 total)