Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,251 through 53,265 (of 59,072 total)

RE: delete records from tables

By the way... I call these While Loops that do deletes, "Delete Crawlers" because they "crawl" through the rows to be deleted, mostly unnoticed. Here's the basis of how...
--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)

December 29, 2007 at 9:10 am

#763516
RE: delete records from tables

First, the database will take a while to "recover"... it'll take less time because you rebooted it as it won't let anyone in until it's done... so no blocking of...
--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)

December 29, 2007 at 9:07 am

#763515
RE: DateTime Problem

Oh bugger... I'm sorry. I'm the same way... I do like to have "Jeff" spelled correctly.
Heh... lately, I've been using your name (or a mispelled version of it :hehe:...
--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)

December 29, 2007 at 9:00 am

#763514
RE: How to debug T-SQL

Both are huge, very broad subjects....
There are a large number of articles on debugging SQL... Google for "HOW TO DEBUG SQL" and you'll get some great articles including how to...
--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)

December 29, 2007 at 8:57 am

#763513
RE: Row-By-Row Processing Without Cursor

John Beggs (12/8/2006)
All of this seems like a lot of work to replace a cursor in a row by row process is needed.
Why is it that people don't seem to...
--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)

December 29, 2007 at 8:29 am

#763511
RE: SQL for numeric ranges

Thanks for the compliment, but I don't actually have the time to be a moderator... would take away from problem-solving time. 😀
--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)

December 29, 2007 at 8:16 am

#763509
RE: Format

Heh... I'm thinkin' that why Mike as how to check the column 😉
--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)

December 29, 2007 at 8:06 am

#763505
RE: Tabular Format

Actually... I've done it... I've got a few more pieces together, but it's all but done.
--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)

December 29, 2007 at 12:41 am

#763494
RE: Tabular Format

Ray,
Just curious... obviously this information is produced by a database somewhere... is there no way to convince the data provider to provide the information either in a delimited format or...
--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)

December 28, 2007 at 9:40 pm

#763488
RE: Table Defaults

I surely hope to God that you are not using IDENTITY or other non-relational auto-increments in tables.
Heh... Joe, you should write an article for SQLServerCentral and explain why you think...
--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)

December 28, 2007 at 9:02 pm

#763486
RE: Table Defaults

Nice article, Andy.
We have a LastModifiedBy column on most of the tables where inserts and updates come from the GUI's... they capture the login of the person making the entry....
--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)

December 28, 2007 at 8:27 pm

#763485
RE: Evaluate a resume

That's pretty good advice, right there...
--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)

December 28, 2007 at 8:01 pm

#763484
RE: TIME SENSITIVE: SQL Server 2008 developer training available JAN 2008

Jason, thank you for the very high compliment. As any one would probably ask, doing what and for how much? I'm thinking that, at this point, a...
--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)

December 28, 2007 at 7:57 pm

#763483
RE: TIME SENSITIVE: SQL Server 2008 developer training available JAN 2008

--- I sincerely doubt that !!!!
That, sir, is because you don't know me... 😉
--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)

December 28, 2007 at 4:57 pm

#763476
RE: do DBAS need local system admin privileges? and why?

It took me a couple of months to figure out what was the best political way get better response times from him. My soultion was to include both our Bosses...
--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)

December 28, 2007 at 4:56 pm

#763474

Viewing 15 posts - 53,251 through 53,265 (of 59,072 total)