Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,126 through 10,140 (of 59,102 total)

RE: Determining uncompressed size when removing Row level table compression

phil.martin 65477 - Monday, January 7, 2019 4:38 AM
Glenn's code worked well in determining the uncompressed size. We have plenty of disk...
--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)

January 7, 2019 at 7:41 am

#2018165
RE: Keep Column Headers Visible in SSRS

I don't use SSRS but the question of headers does come frequently on these forums. Now I've got a great place to point them to. Well done.
--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)

January 7, 2019 at 6:16 am

#2018154
RE: Synonyms

Ivanova - Monday, January 7, 2019 1:24 AM
In a previous role, I used synonyms to allow us to keep a fraud detection...
--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)

January 7, 2019 at 5:57 am

#2018153
RE: Synonyms

robert.sterbal 56890 - Sunday, January 6, 2019 9:47 PM
How many times does the view for a table:
select * from table_name
get improved by...
--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)

January 7, 2019 at 5:51 am

#2018152
RE: Shrink database only x gig a week.

sundar329 - Monday, January 7, 2019 4:10 AM
You may use this query to shrink data file.
declare @src bigint,@sql varchar(250),@filename varchar(25),@shrink bigint
set @filename='BEL_CDR'--change...
--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)

January 7, 2019 at 5:36 am

#2018151
RE: Parsing Nested XML file

Steve Dell - Sunday, December 23, 2018 2:07 AM
Eirikur Eiriksson - Saturday, December 22, 2018 8:05 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)

January 7, 2019 at 4:42 am

#2018145
RE: Determining uncompressed size when removing Row level table compression

phil.martin 65477 - Monday, January 7, 2019 4:25 AM
Brilliant thanks. Worked a treat
So you're saying that going from Row Compression to No...
--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)

January 7, 2019 at 4:33 am

#2018142
RE: Update stats

RGP - Sunday, January 6, 2019 5:28 PM
I have a sql agent job that runs update stats every day actually every 5...
--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)

January 7, 2019 at 4:15 am

#2018136
RE: Translate Sql Query to Clr

Solomon Rutzky - Sunday, January 6, 2019 2:59 PM
I also recommend to Jeff to do the same (i.e. update his reply...
--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)

January 7, 2019 at 3:44 am

#2018131
RE: Translate Sql Query to Clr

meryemkurs072 - Sunday, January 6, 2019 12:38 PM
Thank you Jeff
Is there an application that translates the following code
CREATE ASSEMBLY [Database8]
...
--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)

January 6, 2019 at 2:54 pm

#2018105
RE: how to do this join?

drew.allen - Friday, January 4, 2019 9:22 AM
Jeff Moden - Thursday, January 3, 2019 8:22 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)

January 6, 2019 at 2:51 pm

#2018104
RE: Query

pietlinden - Friday, January 4, 2019 9:28 PM
Oh wow... MUCH more readable!
And no Temp Table. 😀
--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)

January 6, 2019 at 2:34 pm

#2018103
RE: Update stats

p.s. What code are you using to identify when the stats need to be rebuilt and what is the code that you're using to do the actual rebuilds? By 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)

January 6, 2019 at 2:24 pm

#2018102
RE: Update stats

RGP - Saturday, January 5, 2019 8:56 PM
Question: in my production server I had noticed the update stats job was failing for...
--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)

January 6, 2019 at 2:13 pm

#2018101
RE: Trigger not working properly

saum70 - Saturday, January 5, 2019 9:36 PM
Hi.
I have a table A in which datq gets inserred through stored procedure. I 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)

January 6, 2019 at 1:53 pm

#2018100

Viewing 15 posts - 10,126 through 10,140 (of 59,102 total)