Jeff Moden

Forum Replies Created

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

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
RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

1. In what order are you doing the DELETEs?
2. How many rows do you intend to delete?
--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:20 pm

#1927674
RE: Where Clause IN from delimited field

Provided that you prevent SQL Injection, I believe that you'll find that dynamic SQL using a WHERE IN will be way more efficient than any splitter (and I'm the guy...
--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 6:56 pm

#1927673
RE: Transform rows into columns

littlesun - Thursday, February 9, 2017 6:13 PM
Hi
I need to transform rows into columns. Besides that everytime there are two or more...
--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 6:37 pm

#1927672
RE: skip condition in "where" inside dataset when param is not submited

ebooklub - Thursday, February 9, 2017 12:04 PM
Thank a lot .
Provided solution is working fine
Think so? Please read the following article on...
--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 12:12 pm

#1927621

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