Viewing 15 posts - 49,006 through 49,020 (of 59,065 total)
Matt Miller (7/30/2008)
Jeff Moden (7/30/2008)
July 30, 2008 at 8:41 pm
usman.tanveer (7/30/2008)
Can using (Nolock) or (ReadPass) help gaining performance benefits for select queries?
In my point of view may be we could......like in my scenario......db is accessed by multiple...
July 30, 2008 at 8:21 pm
steveb (7/30/2008)
No worries,you could use the Left and Right functions.
I am not aware of any performance difference between the two and couldn't find anything aobut it on BOL.
LEFT...
July 30, 2008 at 7:47 pm
usman.tanveer (7/30/2008)
These tables are the main tables of the Db and contains alot of data. Also multiple...
July 30, 2008 at 7:44 pm
Angelindiego,
If done incorrectly, your CASE statement will turn out to be RBAR on steroids in the form of a correlated subquery. If you want, please post your final code...
July 30, 2008 at 7:36 pm
Since update does not qualify as a non-logging bulk operation, I'd say you'd have to temporarily put the DB in the SIMPLE recovery mode and do the update in, say,...
July 30, 2008 at 7:20 pm
Matthew O'Gorman (7/30/2008)
July 30, 2008 at 7:13 pm
Heh... someone asked me why I've tried to specialize in behind-the-scenes-batch-programing in SQL Server... I believe I'll refer them to this thread. 😛
July 30, 2008 at 6:41 pm
Heh... space used... the Tally or "Numbers" table only takes 136KB for an 11,000 row table and that includes the clustered index in the form of a primary key. ...
July 30, 2008 at 6:00 pm
kannan (7/30/2008)
Use DISTINCT..!
Sure... let's see your code example... 😉
July 30, 2008 at 5:37 pm
DBA (7/8/2008)
thank you!, both functions would do the same as using unpivot?
No... unpivot needs a predefined number of columns... neither the Tally table method nor the XML method need to...
July 29, 2008 at 7:56 pm
Jason Selburg (7/7/2008)
Sure, create a Tally table and use the below function ....(compliments to Jeff Moden)
Thanks for the honorable mention, Jason. 🙂
July 29, 2008 at 7:51 pm
You may want to try rebuilding the indexes which will also update the associated stats.
July 29, 2008 at 7:43 pm
Very nice intro to stored procs... outstanding video, too! Great job, Brian.
Is it "Smart TV" that allowed you to create such a beautiful performance? If not, what did...
July 29, 2008 at 4:50 am
timothyawiseman (7/29/2008)
July 29, 2008 at 4:06 am
Viewing 15 posts - 49,006 through 49,020 (of 59,065 total)