Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,186 through 22,200 (of 59,072 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (12/16/2014)
WHOO! #HappySnoopyDance
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.
Current execution...
--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 16, 2014 at 5:22 pm

#1765062
RE: SQL Server replace cursor that iterates through X Accounting DBs

Luis Cazares (12/15/2014)
There's a different method but with up to 200 databases the validations can become complex and the improvement is unnoticeable. This is one of those occasions where 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 16, 2014 at 8:06 am

#1764942
RE: Are the posted questions getting worse?

Gosh. I can't believe that the Hierarchies On Steroids #1 article made it to the "Bacon" list on the Tribal Awards. I wouldn't mind winning that one. ...
--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 16, 2014 at 7:57 am

#1764939
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/15/2014)
Jeff Moden (12/14/2014)
In the category of learning something new, I just did some testing on the differences between ONLINE and OFFLINE index rebuilds because of a post I...
--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 16, 2014 at 7:49 am

#1764935
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/15/2014)
Jeff Moden (12/14/2014)
In the category of learning something new, I just did some testing on the differences between ONLINE and OFFLINE index rebuilds because 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 16, 2014 at 7:46 am

#1764934
RE: Fragmented Index - Zero Usage - Zero Updates

ReamerXXVI (12/14/2014)
Howdy,
This is a question more out of curiosity than anything else.
I have produced a report on several Indexes in regards to their fragmentation levels and several have no...
--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 14, 2014 at 10:34 pm

#1764645
RE: Divide by zero error encountered.

farrukhhameed786 (12/14/2014)
Hi SS
Thanks ! but how to apply in one sql query ?
Post the query that you want to use it in.
--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 14, 2014 at 10:26 pm

#1764644
RE: Are the posted questions getting worse?

In the category of learning something new, I just did some testing on the differences between ONLINE and OFFLINE index rebuilds because of a post I saw on LinkedIn. ...
--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 14, 2014 at 9:56 pm

#1764643
RE: Filling gaps in date ranges

clayman (12/10/2014)
Hello,
See sample data below. I want hourly breakdown for the last X years, the month and day will be the same for each year. Thank you
I'm a bit...
--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 14, 2014 at 10:04 am

#1764633
RE: Update statement will not update data beyond 7 million plus rows out of 38 millions rows. HELP!!!

Gazareth (12/12/2014)
davidsalazar01 (12/12/2014)
Gazareth, I will try the update sample you sent.
Jeff, I definitely want to update all values (I don't think there are null values) as I need to sanitized...
--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 12, 2014 at 5:58 pm

#1764588
RE: Load Folder name and Images into SQL Tables

robertdba (12/12/2014)
So there might something wrong with the query, when I ran it without any changes just the way it is nothing is loaded, maybe I am missing something here.
Anyways...
--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 12, 2014 at 5:46 pm

#1764587
RE: Update statement will not update data beyond 7 million plus rows out of 38 millions rows. HELP!!!

davidsalazar01 (12/12/2014)
Hi All,
I run the following statement and it will not update beyond 7 million plus rows and I have about 38 million to complete. This is driving 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 12, 2014 at 1:28 pm

#1764565
RE: Query table

BWFC (12/12/2014)
Try using this
declare @ThisDate datetime;
set @ThisDate = getdate();
select dateadd(wk, datediff(wk, 0, @ThisDate), 0)
Be advised that may not work as expected on all installations because the WK...
--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 12, 2014 at 12:45 pm

#1764563
RE: Load Folder name and Images into SQL Tables

robertdba (12/12/2014)
Sorry that is the write one.
SELECT @Cmd = REPLACE(REPLACE(
'DIR "C:\Car\CarSubfolder\*.jpg" /s /b'
...
--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 12, 2014 at 12:36 pm

#1764561
RE: Drive Spaces - Database size

ramana3327 (12/11/2014)
I need for existing database.
If database current size is about 350GB and growth is about 70GB/month. How do you calcaulate the D:/Drive free space and L:/Drive free space
After making...
--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 12, 2014 at 6:28 am

#1764387

Viewing 15 posts - 22,186 through 22,200 (of 59,072 total)