Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,691 through 15,705 (of 59,101 total)

RE: How to break down time span in Categories

The good method that Chris posted above is called a "CROSSTAB". You can learn how it works at the following URL:
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)

February 10, 2017 at 3:39 pm

#1927902
RE: Insert into linked server

adb2303 - Friday, February 10, 2017 3:01 AM
I have changed to SQL to pull, rather than push the records. That works fine....
--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)

February 10, 2017 at 3:34 pm

#1927901
RE: Create CSV file using xp_cmdshell

Step one is to materialize the BCP command contained in the variable and try it from the command prompt to make sure that things are working correctly. Also be advised...
--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)

February 10, 2017 at 3:06 pm

#1927899
RE: SQL Server DBA training.

Kevin3NF - Friday, February 10, 2017 8:09 AM
Jeff Moden - Friday, February 10, 2017 7:37 AM
--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)

February 10, 2017 at 9:22 am

#1927822
RE: How to Group By day and get a total from the Amount column per day?

Lots of the code posted is great. The problem that I see with most of it is the omission of "zero" days that will occur. You need a reference that...
--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)

February 10, 2017 at 9:21 am

#1927821
RE: Conditionally execute SHRINKFILE "only" if the file / DB exists

Express12 - Friday, February 10, 2017 8:26 AM
John and Lowell - thx a million.. Your combined solution worked perfectly:
DECLARE @SHRINK_DBS NVARCHAR(4000)
SELECT @SHRINK_DBS...
--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)

February 10, 2017 at 8:59 am

#1927816
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, February 10, 2017 7:05 AM
I'm waiting for the pork chop trebuchet.
You can educate your kids...
--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)

February 10, 2017 at 7:51 am

#1927785
RE: SQL Server DBA training.

Kevin3NF - Friday, February 10, 2017 5:42 AM
Jeff Moden - Thursday, February 9, 2017 8:50 PM
--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)

February 10, 2017 at 7:37 am

#1927778
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

p.s. Heh... after you get done rebuilding the clustered index of that size, answer my two questions and I'll tell you how to recover all the disk space that caused...
--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)

February 10, 2017 at 7:32 am

#1927772
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

syen.j - Friday, February 10, 2017 6:31 AM
Yeah we fixed it, we understood the underlying reason from the beginning, we 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)

February 10, 2017 at 7:21 am

#1927763
RE: Reclaiming space after dropping index

proxybon 7787 - Wednesday, January 25, 2017 2:34 PM
Forgot to mention - I'm targeting 150gb to be reclaimed. Total server capacity is...
--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)

February 9, 2017 at 10:04 pm

#1927686
RE: Is having a lookup table that is for multiple entities a common practice?

Doctor Who 2 - Wednesday, February 8, 2017 9:57 PM
I've been programming and designing databases of various sorts for several years. 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)

February 9, 2017 at 9:41 pm

#1927684
RE: Insert into linked server

adb2303 - Thursday, February 9, 2017 9:17 AM
RVSC48 - Thursday, February 9, 2017 8:55 AM
--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)

February 9, 2017 at 9:09 pm

#1927683
RE: SQL Server DBA training.

I cannot speak for anyone else but my recommendation is... don't settle for being "just" a DBA. I have no degrees (although I've 4.0'd every college course I've ever taken...
--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)

February 9, 2017 at 8:50 pm

#1927681
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

As a bit of a sidebar and personal observation, I guess disk space isn't cheap after all. 😉
--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)

February 9, 2017 at 7:23 pm

#1927675

Viewing 15 posts - 15,691 through 15,705 (of 59,101 total)