Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,216 through 22,230 (of 59,098 total)

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
RE: SQL2014RTM or SQL2014RTM+CU4

MS usually only supports migrations from 2 previous revs. Unless there's something desperately needed from 2014, you might want to consider migrating to 2012 just to make things 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 12, 2014 at 6:21 am

#1764384
RE: Backup Exec stomping on my SQL Server Backups

plamannkathy (12/12/2014)
Then I want to test, test, test recoverability.
Thanks
Kathy
+1000
--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:17 am

#1764381
RE: The Last Job

The question from the article:
Is this the last full time, technology job you'll have?
Yes it is! I love what I do. Even though I'm at retirement age, 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 11, 2014 at 9:00 pm

#1764259
RE: Help with number / percentage format

Jason-299789 (12/4/2014)
Phil Parkin (12/4/2014)
Jason-299789 (12/4/2014)
IN SQL server if you do a divide an Integer by an integer you get an integer, and a count will only ever produce an integer....
--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 11, 2014 at 7:01 pm

#1764256

Viewing 15 posts - 22,216 through 22,230 (of 59,098 total)