Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,031 through 48,045 (of 59,099 total)

RE: Calculating and allocating serial numbers

If it's gotta be... correctly update "sequence" table would probably fit the bill 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 30, 2008 at 8:39 pm

#879280
RE: T-SQL PIVOT vs. Expressions

See the "performance" section of the following article...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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 30, 2008 at 8:26 pm

#879278
RE: converting datetims variable string to datetime sql server

No... you have the conversion on one of the columns in the Insert list... it has to be on the Date column in the Values list, instead.
--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 30, 2008 at 8:19 pm

#879276
RE: Add a User-Defined Function to Master DB?

rmechaber (9/30/2008)
Corollary: kick the trash barrel before sticking your hand in!
We used to have a saying in the Navy... buy lunch... leave the trash barrels alone. 😛
Anyway, thanks for the...
--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 30, 2008 at 7:57 pm

#879274
RE: Breaking a SP into smaller modules

Dave (9/25/2008)
Wait for it...
🙂
Heh... too easy... not even going to bother. 😛 I just shake my head and wonder. :Whistling:
--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 30, 2008 at 7:53 pm

#879273
RE: Autogrowth - Best Pratice

Grant Fritchey (9/30/2008)
ruyfigueiredo (9/30/2008)
The problem is that the log files increase a lot.
I have an database with 250MB and a Log File with 24GB.
After i reconfigure the Autogrowth i have...
--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 30, 2008 at 7:48 pm

#879272
RE: Best way to reindex large tables/indexes

You bet. Thanks for the feedback. Just curious because other folks have had the problem of finding "Example E" and I'd like to be able to better direct...
--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 30, 2008 at 7:43 pm

#879270
RE: sorting algorithm in sql server

You bet. Thanks for the feedback. Does this mean you're all set?
--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 30, 2008 at 7:40 pm

#879269
RE: Trying to join to xp_fileexist

Mark... you showed the naming convention for the directories... what's the naming convention for the file names and extensions themselves?
--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 30, 2008 at 7:39 pm

#879268
RE: Trying to join to xp_fileexist

rbarryyoung (9/30/2008)
Heh. Now this is one of the few things that SQLCLR is good for. It is fairly easy to write a SQLCLR Function with EXTERNAL_ACCESS rights 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)

September 30, 2008 at 7:21 pm

#879267
RE: Script to return Rows count from table using sp_ExecuteSQL

You didn't copy the script correctly... you're comparing an Object_ID to a table Name in your from clause.
But, again, all that just isn't necessary. Look at my previous post.
--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 30, 2008 at 7:15 pm

#879265
RE: Trying to join to xp_fileexist

Ummm... ok... can you use xp_CmdShell or sp_OA* routines?
--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 30, 2008 at 11:28 am

#879026
RE: Add a User-Defined Function to Master DB?

Just about anything that begins with "sp_" willl be checked for in Master first. I've known people to make Calendar and Tally tables that begin with sp_ just 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)

September 30, 2008 at 6:16 am

#878788
RE: sorting algorithm in sql server

Anirban Paul (9/30/2008)
I am not sure whether you could open the link provided by Jeff. You can try this:
http://msdn.microsoft.com/en-us/library/aa174541(SQL.80).aspx
The link is a Books Online link... you need to copy and...
--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 30, 2008 at 6:05 am

#878779
RE: sorting algorithm in sql server

SQL Server uses a lot of "B-Tree" for this type of stuff... start at the following Books Online listing and drill down on the various types of indexes...
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8936789a-e803-4814-83f2-77e717f81736.htm
--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 30, 2008 at 5:39 am

#878768

Viewing 15 posts - 48,031 through 48,045 (of 59,099 total)