Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,871 through 54,885 (of 59,101 total)

RE: Problem with bacth processing

If it's only 100K rows, lock the table when you do the delete... it'll take less than 10 seconds if you do it right.
Of course, if you have 72 indexes...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 9:50 pm

#736607
RE: ReadMe

Knock knock... not locked...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 9:46 pm

#736604
RE: Whitepaper for developers

Like I said... there's a couple of summary articles on SQLServerCentral.com... just do a search for them... some thing like "Differences between SQL Server 2000 and 2005" should do...
Of course,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 7:30 am

#736363
RE: Looping in T-SQL

Piet van der Westhuizen (9/26/2007)
OK I made it sound very simple.
My data looks like this in tblTransactions (all hypothetical) 🙂
Factory Item PurchasePeriod Spend
=============================
Fact1 ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 7:03 am

#736352
RE: how to start a program like Notepad.exe in a job

I looked up "AT" in Windows "Help"... and they have a command that is "AT" on sterioids! It's called SCHTASKS... take a look... too much to post here...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 6:58 am

#736347
RE: Get Table Count without using COUNT

Dear Site Owners,
Go to a look at the code for this one... appears that something was lost in this last weeks "translation" 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 6:47 am

#736341
RE: how to start a program like Notepad.exe in a job

Ok... I know it's an old post... but that's COOL! I had no idea about the DOS "AT" command. Would have saved my previous company some serious heart-ache...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 6:45 am

#736339
RE: Help with TSQL, getting StartDate and EndDate from WeekDate !!!

Zee,
The reason I asked the questions is because the solution you're so happy with (thank you for posting it) does 4 table scans... if the right indexes are present, it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 6:32 am

#736335
RE: Manual data entry in tables..Any shortcut

Yes, it can be done pretty easily...
When you open the table in EM, instead of selecting all rows, tell it to select the TOP 1. Makes the "end" you're...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 6:21 am

#736327
RE: Looping in T-SQL

You can certainly loop if you want... but let's try to avoid that in a relational database if we can. 😉
You say you want the top 6 transactions for each...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 6:18 am

#736326
RE: Indexing on CHAR/INT columns

Yep... it does depend... but indexing on INT will be faster than just about anything else including SmallInt and TinyInt because of the way the operating/disk systems work... INT is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 26, 2007 at 12:26 am

#736253
RE: No DBAs allowed access to Production DB Servers...

Uh huh... who fixes the auditing system if it breaks or causes any performance problems? 😉 And who's going to do all the other checking you suggested when...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 25, 2007 at 11:54 pm

#736249
RE: How to create a compostie field even if field/s can be NULL??

In other words, the following works...
CREATE TABLE #MyHead
(
ColA INT, ColB INT, ColC INT
)
CREATE...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 25, 2007 at 9:46 pm

#736232
RE: Compare two tables and find unmatch rows

I agree... now's the perfect time to begin exploring Books Online... and when someone gives you a hint like what Serqiy did, don't just stop at the hint... look for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 25, 2007 at 9:34 pm

#736226
RE: using a string statment inside sql "between" statement

Heh... they won't be able to keep the appointment for the interview because their dates will be all haywire...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 25, 2007 at 9:28 pm

#736221

Viewing 15 posts - 54,871 through 54,885 (of 59,101 total)