Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,661 through 15,675 (of 59,063 total)

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
RE: How to Group By day and get a total from the Amount column per day?

Lowell - Thursday, February 9, 2017 11:29 AM
i think this will do it.
i'm using datemath to round the dates down to midnight...
--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:04 pm

#1927618
RE: Data loading is incomplete -

ramana3327 - Thursday, February 9, 2017 6:46 AM
We are using the database in simple recovery. I believe simple recovery model is also...
--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:22 am

#1927568
RE: Need Some Urgent Help in converting the 24 hour date format to grouping with 0-23 range

Ravi Teja - Tuesday, February 7, 2017 7:44 PM
Hi Friends need some help here. I am having a table with order date(yyyy-mm-dd)...
--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 8, 2017 at 5:01 am

#1927290
RE: How to write a string to a file in SQL.

Heh... if that's all there is to UTF-8, you have to wonder what the hell MS has been waiting 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 8, 2017 at 4:45 am

#1927285

Viewing 15 posts - 15,661 through 15,675 (of 59,063 total)