Viewing 15 posts - 48,316 through 48,330 (of 59,064 total)
It actually doesn't matter what privs you give Developers on the Dev box... if you allow Developers to design their own tables and you don't have any coding standards and...
September 13, 2008 at 3:17 pm
True enough... my question is why you'd want to do anything to all tables from outside the database when the database does it so well?
September 13, 2008 at 2:35 pm
Funny you should bring that article up... 🙂
http://www.sqlservercentral.com/articles/TSQL/62867/
But the desired method to do the split depends on my question... Is this a single parameter being split or does a whole...
September 13, 2008 at 2:32 pm
Bulk Insert will load up to 5.1 million rows of 20 columns each in 60 seconds flat. How many rows are you trying to import?
September 13, 2008 at 2:23 pm
To clarify what Sergiy just said... all those functions that do "lookups" are just an insideous way of doing correlated subqueries which are RBAR on sterioids. RBAR can appear...
September 13, 2008 at 2:21 pm
After looking at this, I think the folks that recommended "NTile" are probably producing the more accurate answer. Are you absolutely positive you want to do that running total...
September 13, 2008 at 2:00 pm
pps... I'm not sure that you need the likes of a running total on this... I'm still looking...
September 13, 2008 at 1:41 pm
Ps... I didn't change any of the smiley faces to ")"... you'll need to do that, I just copied your code.
Also, if you don't mind... you said it took a...
September 13, 2008 at 1:32 pm
upperbognor (9/12/2008)
I'm wondering if there is a faster solution possibly....It's currently taking the longest calculating the running total due to the cross join.
Yes, there is a much faster method and,...
September 13, 2008 at 1:29 pm
Heh... ACK!... cursors... while loops... sp_MSForEachTable which contains one of the most ineffecient general purpose cursors there will ever be...
Yeaup... they all work. But, in SQL Server 2005, there...
September 13, 2008 at 12:14 pm
rsheppick (9/12/2008)
Well, I have to manipulate them somewhat.
Not quite the business reason we were hoping for. 😉 There are several solutions depending on the requirements of a valid business...
September 13, 2008 at 11:52 am
greig.burrows (9/12/2008)
Hi there! I'm struggling to split a string.. hope somebody can help me. Here's a description of my problem:
Ugh... UDF's... While Loops... all good ways to slow your code...
September 13, 2008 at 11:26 am
jmuldoon (9/10/2008)
September 13, 2008 at 11:14 am
dulanjan (9/12/2008)
if the start date is a saturday and the end date is a sunday it returns a -1.
i think this...
September 13, 2008 at 10:34 am
Ummm... high IO and CPU isn't necessarily caused by either Table Variables or Temp Tables. It's HOW they are used. I think what you're going to find is...
September 13, 2008 at 10:23 am
Viewing 15 posts - 48,316 through 48,330 (of 59,064 total)