Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,706 through 15,720 (of 59,101 total)

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
RE: Backups Aren't Backups Until a Restore Is Made

We do a restore of our two big "money makers" every night. We use them for troubleshooting purposes if anything goes wrong in prod but I'd do it anyway even if...
--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:36 am

#1927282
RE: Query fills tempdb after upgrade from 2005 to 2012

Definitely post the query. If you can post the actual execution plan as an SQLPlan attachment, that would help, as well.
--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 7, 2017 at 11:40 pm

#1927242
RE: Trouble with openxml query

pisorsisaac - Tuesday, February 7, 2017 8:24 PM
GRRR (at myself) ... I'm very thankful to you for looking at my problem, can't...
--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 7, 2017 at 10:38 pm

#1927237
RE: Very large Indexes (~3TB) and need to rebuild fast

ALIF-662928 - Tuesday, February 7, 2017 11:24 AM
As it seems like there is not a standard approach for this, so have to...
--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 7, 2017 at 5:35 pm

#1927224
RE: Trouble with openxml query

Either I'm not yet used to the new forum software or you forgot to attach the attachment you're talking about.
--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 7, 2017 at 5:07 pm

#1927222
RE: trouble wit a poor performing query

srmc - Tuesday, February 7, 2017 2:44 PM
I've got a poor performing query and not sure the best approach to fixing it. ...
--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 7, 2017 at 5:00 pm

#1927220
RE: convert HH:MM:SS to datetime

I have to ask why someone is storing something that will only ever contain digits and colons as NVARCHAR. It should be stored simply as CHAR(8) if the times never...
--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 7, 2017 at 9:20 am

#1927117

Viewing 15 posts - 15,706 through 15,720 (of 59,101 total)