Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,746 through 17,760 (of 59,069 total)

RE: DIR /B switch

Sergiy (4/28/2016)
Jeff, don't be so sure.
It's MS Windows we're talking about here.
Ever noticed Modified Date earlier than Created Date?
I did. Not once, not twice.
Understood. I did a test (before...
--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)

April 28, 2016 at 9:14 am

#1875303
RE: free the cache - SQL Server Server

GilaMonster (4/28/2016)
Jeff Moden (4/28/2016)
river1 (4/27/2016)
I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats
Ah, careful now. Specifically, REORG does NOT rebuild stats....
--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)

April 28, 2016 at 9:09 am

#1875301
RE: Does T-SQL have a means of iterating over the columns of a table?

I'll try to post the code tonight. Have to do some cleanup on it to remove some of the proprietary/sensitive stuff.
--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)

April 28, 2016 at 8:53 am

#1875295
RE: free the cache - SQL Server Server

river1 (4/27/2016)
I have a proc running every day that reorg/rebuild indexes. If reorg then also updates the stats
Ah, careful now. Specifically, REORG does NOT rebuild stats. Only 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)

April 28, 2016 at 6:30 am

#1875212
RE: XML to SQL tables

Alan.B (4/28/2016)
squvi.87 (4/28/2016)
any set based approach? with out using cross apply ?
XML is a different animal...
When did CROSS APPLY become the "not set based" approach?
A lot of people incorrectly consider...
--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)

April 28, 2016 at 6:19 am

#1875207
RE: String Together Mulitple fields when not NULL

Luis Cazares (4/27/2016)
Or if you're on 2012, you could use CONCAT.
SELECT ID,
STUFF(
...
--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)

April 28, 2016 at 5:29 am

#1875198
RE: DIR /B switch

inHouseDBA (4/27/2016)
If you dump results of DIR PATH /S /OD to the table and then query that table, then the first chars for each row is the...
--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)

April 28, 2016 at 5:25 am

#1875197
RE: XML to SQL tables

squvi.87 (4/28/2016)
any set based approach? with out using cross apply ?
That's the "lovely" part of XML... Cross Apply IS the set-based approach.
--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)

April 28, 2016 at 5:05 am

#1875189
RE: strange problem with varchar(8000) getting cut at 4000 characters

To add to that, if you are, in fact, using SQL Server 2012, make sure that you're at SP3 with the latest CU. There were a couple of problems...
--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)

April 27, 2016 at 6:41 pm

#1875125
RE: free the cache - SQL Server Server

river1 (4/27/2016)
Dear all,
We will try in Production environment to clean the cache in order to get new query plans (stored procédures will need to create new plans)
This is because everytime...
--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)

April 27, 2016 at 4:45 pm

#1875099
RE: DIR /B switch

Cool. When you figure it out, let us know what "some way" turned out to be, please. Thanks.
--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)

April 27, 2016 at 4:20 pm

#1875096
RE: Does T-SQL have a means of iterating over the columns of a table?

TheSQLGuru (4/27/2016)
I have come across a few clients over the years that had built their own "column-based" auditing. In every case the overhead of such systems (regardless of how they...
--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)

April 27, 2016 at 9:26 am

#1874982
RE: Calendar Table Function

Iwas Bornready (4/27/2016)
Wow, the quoting is kind of getting crazy.
Can I quote you on 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)

April 27, 2016 at 7:28 am

#1874932
RE: SQL Server Resource Governor

BLOB_EATER (4/27/2016)
Jeff Moden (4/26/2016)
Thanks for the article, Raul. I especially like what I saw on the PerfMon chart in the "Results" section.
Not much to add because Kevin beat 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)

April 27, 2016 at 7:10 am

#1874922
RE: Cloud First

David.Poole (4/27/2016)
Cloud DB Servers mean you have to rely on architecting your solution correctly and designing your schema properly. Failing to do so results in a big bill every...
--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)

April 27, 2016 at 6:50 am

#1874914

Viewing 15 posts - 17,746 through 17,760 (of 59,069 total)