Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,786 through 31,800 (of 59,099 total)

RE: Dropping and restoring DB to fix file fragmentation

Eric Niemiec (12/3/2011)
If you need to keep the database online and you have another available LUN on your SAN, you could move all your clustered indexes, then your non-clustered 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)

December 4, 2011 at 10:02 am

#1416424
RE: To change datetype varchar(14)

David Moutray (11/29/2011)
A CLR function, if practical, would probably be better.
Heh... "better" how? I don't believe it will be any faster than STUFF. Of course, my opinion isn't...
--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 4, 2011 at 9:50 am

#1416421
RE: Getting Last modified record from table

Now all we need to know is the true reason why someone would want to do this especially since, as Michael Valentine Jones pointed out, the last row updated could...
--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 4, 2011 at 9:40 am

#1416420
RE: Enable autogrowth for databases in SQL Server

opc.three (11/30/2011)
Jeff Moden (11/29/2011)
opc.three (11/29/2011)
Taking it a step further we can easily employ PowerShell and WMI to discover all SQL Server instances on our network without relying on the SQL...
--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 4, 2011 at 9:15 am

#1416416
RE: Try catch in a transaction block or transaction in try catch block???

SQL_By_Chance (10/13/2011)
CREATE PROCEDURE EXAMPLE (@parameter)
---- To illustrate how I intend to Use Execption Handling inside my Cursor
AS
BEGIN
BEGIN TRY
DECLARE @TABLENAME VARCHAR (10)
DECLARE DROPTABLE CURSOR
FOR SELECT...
--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 4, 2011 at 9:10 am

#1416413
RE: Percentile function

John Mitchell-245523 (12/1/2011)
Jeff, I don't think that's what Vijay was asking for. Your solution splits the scores into four evenly-sized groups. The requirement was for the scores 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 4, 2011 at 9:02 am

#1416411
RE: HierarchyID performance problems... Really???

dw.bi (12/1/2011)
My stored proc takes in a node number as a parameter and returns the downline depending on the filters.
For the tree in image(attached), assuming that the RED BLOCKS...
--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 4, 2011 at 8:55 am

#1416408
RE: HierarchyID performance problems... Really???

hugo-939487 (12/2/2011)
Hi Jeff,
Ik don't understand the BuildTestHierarchy stored procedure.
In my database I get the Employee table, but I don't see any column of type hierarchyid.
Do I have to do some...
--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 3, 2011 at 8:45 pm

#1416375
RE: Are the posted questions getting worse?

Dev (12/3/2011)
Kit G (12/3/2011)
Thanks for all the congratulations on our anniversary. 🙂 Had a really nice day and am looking forward to the vacation with my...
--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 3, 2011 at 8:38 pm

#1416374
RE: Last day of Month

Just a point of interest... Michael is correct. Anything you can do to stay away from character based conversions on these types of calculations will increase the performance 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 3, 2011 at 7:50 pm

#1416372
RE: link of exec plan's parts with running query

den_sidr (12/2/2011)
Good Morning ,
is it possible to map estimated plan (its parts) to currently running query?
for example i have a simple query has been running for 5 minutes...
--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 3, 2011 at 7:44 pm

#1416371
RE: Splitting a Date range

Evil Kraig F (12/1/2011)
Ugh, nasty. You need a row-repeater. Which means... To the TALLY!
BWAAA-HAAA!!!! Beer popsicles... Dust Bunnies... nicely done Tally Table solutions... and a sense 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 3, 2011 at 7:34 pm

#1416369
RE: Calcation of Date difference

The following should help quite a bit. As usual with my code, the details are in the comments. Please let me know if you find it useful 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 3, 2011 at 7:14 pm

#1416366
RE: SSRS- Needs to display All month

The following article will help you do exactly what you need to do...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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 3, 2011 at 4:00 pm

#1416351
RE: ER diagram question

tangoo111 (12/3/2011)
Thanks for everyone I will try and see .
Rather than starting out with articles written by Celko which are kind of advanced and a bit ANSI oriented, try starting...
--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 3, 2011 at 3:41 pm

#1416349

Viewing 15 posts - 31,786 through 31,800 (of 59,099 total)