Heh... no... these are... 😉

[font="Tahoma"]Jeff Moden's Three Rules of DBA's.

1. A DBA may not injure data or performance...

ashoknegi84 (4/1/2008)

---

hi

i have a table like

empname empid empsal

---------------------------

abc 1 ...

rbarryyoung (4/1/2008)

---

No, you have to use a cursor/loop (of some kind). Executing DDL's/DML's across a restricted range of SQL objects is one of those cases (DB management/operations tasks) that...

SQLZ (4/1/2008)

---

Say I want to run an ALTER INDEX ALL ON table_name REORGANIZE;

command on all tables that are more than 10% fragmented.

I know I can use sys.dm_db_index_physical_stats to get this...

WHERE IN...

Heh... I'm thinking that's more than two options right there 😉 Lets see... DTS, OSQL query, SP_OA* sprocs... there's a couple more, but I forget.

Yes... don't use either... use an INNER JOIN instead.

Extract into what? Are the files all in the same format? We need just a little more info.

p.s. A join to a Calendar table would be even more effective...

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

tickler_foryou (3/31/2008)

---

Hi friends,

I have a Order_date column where order dates are captured in SQL server 2005 DB, I need to find the order dates that falls on Week Days only...

You'd be amazed what it can do... as you've seen, it'll do splits. It'll also fill in missing dates, generate multiple rows for each row according to a "QTY",...

Sure could... now, pretend it's 5PM on a Friday and you have a really hot gig at 5:30PM (what...

The only thing that can be faster than the Tally Table is Dynamic SQL... but that's not a split and it does have some security issues if it's public facing.

escaleraroyal (3/31/2008)

---

Jeff,

They just asked me to performance tune it.

But it appears the SP insert data if (party_data) > 36. Then it adds up a sort_order, and for new instrument_id the...

Any bets? 😉 Post your test data please, the...